I'm going through a tricky situation and need a solution asap. So here's my issue.
I have a Report that is generating 2 rows per employee, for example
Name Dept Stock Unit Type Stock Amount Age Location
Mary Joe IT Unit A $100 25 USA
Mary Joe IT Unit B $200 25 USA
What i'm trying to accomplish is printing one statement with the UNIT A and Unit B combined. The rest of the data is the same and i don't want to generate duplicate statement. Here's the desired output.
Name Mary Joe
Stock Unit A Type Unit A
Stock Unit A Amount $100
Stock Unit B Type Unit B
Stock Unit B Amount $200
How do i accomplish this?
Any help would be greatly appreciated. I'm new to BIRT so any example would help.
Thank you for your response.
I can see the output and this is something what i'm looking for. But in the report design i don't see the code. Could you please let me know what you are doing to get this output.
i want to find out that if this is even possible, to grab something from an additional row and promote to the other row.