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

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

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

Wed, 18 October 2017 18:17

Eclipse User

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

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

Thu, 19 October 2017 10:49

Eclipse User

See if this will help get you started.

index.php/fa/31058/0/

Attachment: MaryJoe.jpg
(Size: 21.62KB, Downloaded 312 times)
Attachment: Arka_Adhya.csv
(Size: 0.11KB, Downloaded 88 times)
Attachment: Mary Joe.rptdesign
(Size: 25.09KB, Downloaded 338 times)

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

Thu, 19 October 2017 16:50

Eclipse User

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

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

Fri, 20 October 2017 13:23

Eclipse User

Please let me know the details if you can.

Thank you,
Arka

Previous Topic:	Data of two data sets in one table
Next Topic:	WANTED: Drill Down Tutorial

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 07 11:31:41 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter