How to create a BIRT report with Enumeration list
Hi,
I have a enumeration list called "Problem Determination" this value is a enumeration list that could include multiple values. When I use BIRT to get a report of this filed. I get the following result: in the first dataset created: as you can see in WI 41 I have multiple values. I would like to group this result by Problem Determination but If I make this I will get the following: How can I split the Multiple values to represent correctly the quantity of problem determination? and avoid to show the multiple values as a separate value. Thannks. |
2 answers
Even though it is an old post, I would put the answer here for future reference.
Basically we need another data set to contain the split enumeration lists, because a single row in the original data set such as 1 key |value1|value2|value4|can become multiple rows 1 key |value1|Using a scripted data set should be quite straightforward. Here is a short tutorial for creating such a data set. http://developer.actuate.com/be/documentation/ihub3/help/adg/adg65/index.html#page/ADG/ProgramDataAccess.1.3.html For our purpose here, we will use a global object "data" to store the processed data. We only need to make slight changes to the scripted data set so that it reads data from the global "data" object in the "fetch" method. Of course we will have to first populate the global "data" object with the original Jazz data set, in the "onFetch" method. Here are the codes of the "ofFetch" method. id = row["WI_ID"];(Remember to skip the first and last items of the valueSet[] arrays since they are empty) This is how it looks like with the original Jazz data set on top and the scripted data set at the bottom. |
Hi Rodolfo,
I used this video to create BIRT report with enumeration: http://www.youtube.com/watch?v=8q29We9QoHE . You can also see the similar topic created by me: https://jazz.net/forum/questions/113221/using-custom-attribute-as-a-parameter-in-birt. Let me know if it helps for you. Regards, Krzysztof Kazmierczyk Comments 1
Hi Krzysztof,
1
ryosuke oka
commented Apr 17 '14, 2:40 a.m.
Hi Rodolf,
|
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.