Report Example - Multiple Datasources/DB, Scripted Data Source and Report Parameters

shirpak

The requirement is to fetch data from 2 same tables from 2 different databases and combining the result of both to create a table in report.


Also, the query is dynamic which will be created based on Report parameters. Report parameters are single value and multi-valued.

About BIRT Joint Dataset
====================
From some documents on internet Joint dataset concept seems to do union. But, there is no concrete example of UNION using Joint dataset. Joint datset example found are basically for joining 2 datasets.

bhanley

Joint data sets handle things by doing a Join on the data. If that does not work for you, you can always create a "virtual" table on the report using a grid to bind together different controls bound to independent data sources.