How to Create Birt Report Based on Multiple Data Sets

How to create BIRT report based on multiple data sets

If your multiple datasets are coming from the same datasource, I recommend combining the queries.

If the multiple datasets are coming from different datasources, you can link them together using the Joint Data Set functionality in BIRT.

To link two separate datasets together:

1. Right-click on Data Sets in the Data Explorer pane within the BIRT Report Designer, and select New Joint Data Set.
2. On the New Joint Data Set dialog, select the data set and field (Operator, here) to be joined from on the left-hand list.
3. Select the join type (Inner, Left Outer, Right Outer, Full Outer) from the options between the two lists.
4. Select the data set and field (Operator again, here) to be joined to on the right-hand list.
5. Give the resultant new dataset a meaningful name, in the option at the bottom of the dialog.
6. Click Finish.
7. Edit the resultant dataset to produce output as required, from the Edit Dataset dialog.

You can only produce joint datasets from no more than two existing datasets. However, joint datasets can themselves be included as input datasets for other joint datasets - so if you need to join three datasets together, this can be achieved by linking two of them into one joint dataset, then creating a new joint dataset based on the first joint dataset and the third original dataset.

It is not necessary to paramterise any of the existing queries to join datasets. A parameter condition on Operator in the query should only be included if the intention is to restrict the Operators returned in that dataset (eg. to return operators 100-121 only).

Birt: prevent repeat DataSet execution were used in multiple tables in report

You can add the data set to a grid on top of your report
you have to give that grid an unique elment name

for your three tables you can switch in the Propert Editor -> Binding from Data: (the data set) to Report Item (choose the unique elmenet name of the grid)

after makeing this changes the dataset is executed only once and reused in all three tables

Related Topics