Skip to main content



      Home
Home » Archived » BIRT » BIRT - Merging Data from 2 Rows
BIRT - Merging Data from 2 Rows [message #1774707] Wed, 18 October 2017 18:17 Go to next message
Eclipse UserFriend
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 Go to previous messageGo to next message
Eclipse UserFriend
See if this will help get you started.

index.php/fa/31058/0/


Re: BIRT - Merging Data from 2 Rows [message #1774812 is a reply to message #1774786] Thu, 19 October 2017 16:50 Go to previous messageGo to next message
Eclipse UserFriend
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 Go to previous message
Eclipse UserFriend
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:
  


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

Powered by FUDForum. Page generated in 0.28852 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top