Eclipse Community Forums: BIRT » BIRT - Merging Data from 2 Rows

Help

Home

Home » Archived » BIRT » BIRT - Merging Data from 2 Rows

Show: Today's Messages :: Show Polls :: Message Navigator

BIRT - Merging Data from 2 Rows [message #1774707]

Wed, 18 October 2017 22:17

Arka Adhya

Messages: 4
Registered: October 2017

Junior Member

Hello BIRT Experts,

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
Dept IT
Stock Unit A Type Unit A
Stock Unit A Amount $100
Stock Unit B Type Unit B
Stock Unit B Amount $200
Age 25
Country USA

How do i accomplish this?
Any help would be greatly appreciated. I'm new to BIRT so any example would help.

Thank you,
Arka

Report message to a moderator

Re: BIRT - Merging Data from 2 Rows [message #1774786 is a reply to message #1774707]

Thu, 19 October 2017 14:49

Jerry Sheets

Messages: 76
Registered: July 2009
Location: Salt Lake City, UT

Member

See if this will help get you started.

index.php/fa/31058/0/

Attachment: MaryJoe.jpg
(Size: 21.62KB, Downloaded 240 times)
Attachment: Arka_Adhya.csv
(Size: 0.11KB, Downloaded 63 times)
Attachment: Mary Joe.rptdesign
(Size: 25.09KB, Downloaded 299 times)

Report message to a moderator

Re: BIRT - Merging Data from 2 Rows [message #1774812 is a reply to message #1774786]

Thu, 19 October 2017 20:50

Arka Adhya

Messages: 4
Registered: October 2017

Junior Member

Hi Jerry,
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.

Thank you so much for looking into this.

-Arka

Report message to a moderator