Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT - Multiple Row for each Worker issue(Please help)
BIRT - Multiple Row for each Worker issue [message #1775227] Thu, 26 October 2017 14:26 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 - Multiple Row for each Worker issue [message #1775480 is a reply to message #1775227] Mon, 30 October 2017 18:37 Go to previous messageGo to next message
Chris Mills is currently offline Chris MillsFriend
Messages: 3
Registered: October 2017
Junior Member
Are you sure your sql is returning 1 row for each worker and not two ?
Re: BIRT - Multiple Row for each Worker issue [message #1775488 is a reply to message #1775227] Mon, 30 October 2017 20:13 Go to previous message
Chris Mills is currently offline Chris MillsFriend
Messages: 3
Registered: October 2017
Junior Member
select unita.name unita.dept unitA_amt, unitB_amt
from (select name, dept, unita_amt from table_name where unit = 'A') unita,
(select name, dept, unitb_amt from table_name where unit = 'B') unitb
where unita.name = unitb.name
and unita.dept = unitb.dept;


Don't know if the syntax is exactly correct. This format works with Oracle 12. I don't know your DB.
Previous Topic:BIRT Upgrade 3.7.1 to 4.6.0 and Report differences
Next Topic:Set default value to parameters
Goto Forum:
  


Current Time: Wed Aug 22 05:46:05 GMT 2018

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

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

Back to the top