Birt reports - multiple "joins"?
Let's say that I want to show a report with all the defect WIs and some related information like....
e.g.: id summary owned by state priority severity 10 defect 1 claudia raised high critical 11 defect 2 claudia rejected low medium Based on what I've seen on other reports, and trying to replicate the idea here, is to have a Defects Data Set where I collect the WIs based on specific criteria. Then I join the result with another table (e.g. STATE) to get the "friendly" names. Now... what about when I have to get friendly names coming from more than one table? Like it is shown in this example, I need to join with STATE, PRIORITY and SEVERITY. But it seems I cannot have multiple joins, so how can I get all those friendly names in the same result data set to be shown to the user? Thanks for any guidance! Claudia |
2 answers
That is one of the reasons I usually avoid using BIRT joins.
What you could do is fetch each of the dimensions like STATE, PRIORITY, etc in a javascript Object that maps the ids to the friendly names. Then define the columns for the friendly names as computed columns. The following two videos show how that can be done: http://jazz.net/library/video/288 http://jazz.net/library/video/289 |
|
Thanks Rafik,
now I can clearly see the differences between these 2 methods and have it working. Claudia |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.