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