Eclipse Community Forums: BIRT » BIRT - Multiple Row for each Worker issue

Help

Home

Home » Archived » BIRT » BIRT - Multiple Row for each Worker issue(Please help)

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

BIRT - Multiple Row for each Worker issue [message #1775227]

Thu, 26 October 2017 14:26

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 - Multiple Row for each Worker issue [message #1775480 is a reply to message #1775227]

Mon, 30 October 2017 18:37

Chris Mills

Messages: 6
Registered: October 2017

Junior Member

Are you sure your sql is returning 1 row for each worker and not two ?

Report message to a moderator

Re: BIRT - Multiple Row for each Worker issue [message #1775488 is a reply to message #1775227]

Mon, 30 October 2017 20:13

Chris Mills

Messages: 6
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.

Report message to a moderator

Previous Topic:	BIRT Upgrade 3.7.1 to 4.6.0 and Report differences
Next Topic:	Set default value to parameters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 02:47:45 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter