Combining multiple records into one record?

Hi,
 
I am reading in data using union that looks like the following (see attached image).
 
As you can see each wonum has data on different records. I want to combine the multiple records into one record in BIRT. Is this possible? At the moment it's grouped by wonum, but each record is output to its own report page.
 
note: I've had to use union to get round an issue I have been having with joining the data on relationships.

Find more posts tagged with

Comments

wwilliams

When you say one record do you mean one row? Can you draw a picture. in the thumbnail you have one work order and then the related records. the workorder table has one row and labtrans and matusetrans can have many records\rows

khitch

<blockquote class="ipsBlockquote" data-author="wwilliams" data-cid="147315" data-time="1491939432">
<div>
When you say one record do you mean one row? Can you draw a picture. in the thumbnail you have one work order and then the related records. the workorder table has one row and labtrans and matusetrans can have many records\rows
</div>
</blockquote>
 
My bad I was meaning 2 rows, as there are 2 labtrans, matusetrans, etc. 
 
wonum | description | worktype | location | pluspcustomer | refwo | laborcode | startdate | starttime | etc.. 
1234 desc wt loc pluspcust 1234 labcode1 sd1 st1 
1234 desc wt loc pluspcust 4233 labcode2 sd2 st2 and so on ...

wwilliams

I'd try one chunk of sql like I showed on my previous post.

khitch

<blockquote class="ipsBlockquote" data-author="wwilliams" data-cid="147321" data-time="1492000480">
<div>
I'd try one chunk of sql like I showed on my previous post.
</div>
</blockquote>
 
thanks,
 
managed to sort it