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; } } }

Not able to Join more than two tables in brit.

basudeba87

Hi All,

I am trying to join more than two tables for brit report. I am using eclipse designer IDE.
Anybody please let me know any suggestion or step procedure for joining complex queries.

Regards,
Basudeba

Find more posts tagged with

Comments

averma

Hi Basudeba,
There are several ways you can do this. If these tables are from the same data source, you could write a SQL statement that merges(joins) the data at the database layer. If you do a web searh on "SQL join" you will find several examples.
Using BIRT you can also join data from disparate data source. This would involve first defining the data sets from different sources and then creating another joint data set and specify the join type (inner, outer etc...). Here is an example of the latter approach:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/361-how-to-join-data-sets/