Using Data from different Datasets for each Series (Y-Axis) to generate Birt Chart

I have a very complex scenario in which a Birt Chart (Bar graph) needs to be generated. However each series of the Bar graph needs to be from a different data set since it is not possible to generate the required data from a single SQL query. Is this possible in BIRT?

What is the alternative solution for this problem in case it is not possible.

Thanks in advance
-Kiran

Find more posts tagged with

Comments

mwilliams

Hi Kiran,

Do you have a common key in which you can join your dataSets into one using a joint dataSet?

kiranv

Nope!
There is no common key in which I can join dataSets into one using a joint dataSet!

mwilliams

Kiran,

How will they associate with each other in a graph? There is not a common x-axis field, like date or something?