Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT - Merging Data from 2 Rows
BIRT - Merging Data from 2 Rows [message #1774707] Wed, 18 October 2017 22:17 Go to next message
Arka Adhya is currently offline Arka AdhyaFriend
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
Re: BIRT - Merging Data from 2 Rows [message #1774786 is a reply to message #1774707] Thu, 19 October 2017 14:49 Go to previous messageGo to next message
Jerry Sheets is currently offline Jerry SheetsFriend
Messages: 68
Registered: July 2009
Location: Salt Lake City, UT
Member
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 20:50 Go to previous messageGo to next message
Arka Adhya is currently offline Arka AdhyaFriend
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
Re: BIRT - Merging Data from 2 Rows [message #1774867 is a reply to message #1774812] Fri, 20 October 2017 17:23 Go to previous message
Arka Adhya is currently offline Arka AdhyaFriend
Messages: 4
Registered: October 2017
Junior Member
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 Aug 20 15:18:25 GMT 2018

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

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

Back to the top