Problem with different database connections

ayyalaraj

Hi,
I came accross one typical scenario while writing the reports. I need to get data from two or more different databases and put it all the data as a report. Is it possible to do in birt? How can I do that?
For Example : I have 10 rows in Database1 and 20 rows in Database2 and 20 rows in Database3. My report should get all the 50 rows from 3 different databases and format the data using cross tab.
Any immediate help is highly appreciated.

Thanks,
Chandra

mwilliams

Hi Chandra,

You can definitely bring in data from 3 different databases. If you're wanting the rows to be stacked on top of each other in the same dataSet, you'll have to use joins to join them. You can do this with joint dataSets with full outer joins and then use computed columns to stack the like columns. Let me know if you have questions.