nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Join 3 datasource results

chetan_1981

Hi,
 
I want to create consolidated report in which Status 1 (Datasource 1), Status 2 (Datasource 2), Status 3 (Datasource 3).
 
I have created 3 separate queries for the same. But want to show the consolidated result of all 3 Status in one report. So, created joint data-set. But, don't understand how to add 3rd Datasource to display the consolidated status report. Please help to solve the problem.

Find more posts tagged with

Comments

micajblock

In OS BIRT you can only join 2 data sets. In commercial BIRT you can join as many as you want. The workaround is to join 2 of the 3 and then create another joined data set that joins the first joined data set to the 3rd data set. See attached example.