BIRT - RTC Displaying multiple custom attributes grouping on ID

Hello,
I'm using RTC and BIRT to display 2 custom attributes of type enumeration (STRING_KEY/STRING_VAL). I've defined computed columns to display the correct enumeration value. When I run the report I got duplicate row IDs.
There are 2 rows with the same IDs for each custom attributes. I tried to "Group by ID" and I've selected "Hide the details" but I cannot see both custom attribute value at once on a single row.
What am I doing wrong?
Thanks for your help.

Find more posts tagged with

Comments

mwilliams

If I'm understanding correctly, you could put your data in a table, group by your ID column, delete the detail row, then, in your group header, in a second column, add an aggregation and use the concatenate function. Be sure to concatenate over the group and not the whole table. This would give you your ID field with both attribute values in the same row. Let me know if this isn't what you're trying to do.

Darshan Patel

This doesn't work for me. I have two enumeration, Priority and Severity and i am not able to show them into same row as
 
WI ID Priority Severity
1 High Critical
2 Low Medium
 
I have computed columns for both Priority and Severity on the same data set as below
 
priority[row["STRING_VAL"]];
severity[row["STRING_VAL"]];