Joins in reports

Hi,
I need to display the attributes of one table corresponding to another table.
I used inner join facility of BIRT for it.
But the problem is, every time, for any attribute matching b/w two tables, it is repeating the contents of second table, which is not as per our need.

Any solution ll' be a great help.
Thanks

Find more posts tagged with

Comments

mwilliams

Hi Rinki,

Have you tried any of the other types of joins to see if you can get what you're wanting? Can you provide a small sample of what your data looks like in both dataSets and what you'd like it to look like in the joint dataSet? Thanks.

Rinki

Thanks for your reply.
I tried on all the joins (i.e. Inner join ,left outer join , right outer join, all outer join)but it is still creating the same problem.

I just need to merge two different reports which have a few parameters in common.

Now I just want to display the data of both the reports such that, the data with same values of the common parameter come adjacently, and after that other data.

But the problem I am facing by using joins is, it is displaying the same data of second report several times.

mwilliams

Rinki,

Can you attach a screenshot of what you're getting when you run the report. If you can post some sample data from both dataSets for me to work with, that may help me in suggesting a solution.