Not able to Join more than two tables in brit. in case simple query, i am able to get the results in the report.
Posted 14 March 2012 - 09:33 AM
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: