How to Merge columns in Birt

Hi everyone,
 
I have to create a report that has needs different columns that need different datasets. So every columns consists a count sql statement and a date. With a scripted data set I create a date column and try to join the the other datasets with a lot of joint datasets together.
 
But this does not work on the test stage because whenever I join a scripted dataset with a sql dataset the scripted datasource handler is not called which would correct the jndi name string.
 
So I do need an alternative idea of how to merge columns without joint dataset.
 
Thank you in Advance!

Find more posts tagged with

Comments

SailRCG

This sounds like a case for a nested table. You are able to create the effect by a single column table nested inside of your desired column of the containing table. You will need to use a table filter definition to ensure you maintain relevancy/connection. Additionally you will need to pay very close attention to padding to create a seamless look & feel.

Alex Zot

Thank your for your answer,
 
the problem is, that I have an sql that gets me counts grouped by days. The scripted dataset generates a time collum and if I donÂ´t merge the two The time collum still has letÂ´s say 31 days for a month and the sql only gives values for 3 days because on the other days there is no data. So I donÂ´t really see how nested tables could help there.
 
Example:
Parameter:
from: 2017-02-01
to: 2017-02-07
 
The scripted data set gives me
2017-02-01
2017-02-02
2017-02-03
2017-02-03
2017-02-04
2017-02-05
2017-02-06
2017-02-07
 
But the sql dataset gives me
Date | count
2017-02-01 | 1
2017-02-05 | 3
 
So I do need to merge it but I donÂ´t how to make this work with birt