Duplicate rows in result set

Hi,

I have a report that generates a table. Somehow for various reasons I'm getting duplicate rows in the result set. Is there a way to suppress the duplicates after the report initialization.

Attached is the screenshot of the table with duplicate rows.

Find more posts tagged with

Comments

Megha Nidhi Dahal

Hi Bharath, 
 
Can the query that is used to get these data be modified? As far as I'm understanding from the screenshot above, some join clauses would have been missed. Can distinct be used while querying the data? Do these duplicate rows come up in the preview section of the dataset also? It would be easier to solve, if the root cause could be identified. 
 
BIRTers, I might not be understanding it completely, anyone more aware of this problem can respond. 
 
regards 
Arpan

Bharath406

<blockquote class='ipsBlockquote' data-author="'Arpan'" data-cid="71274" data-time="1292248510" data-date="13 December 2010 - 06:55 AM">
Hi Bharath, 
 
Can the query that is used to get these data be modified? As far as I'm understanding from the screenshot above, some join clauses would have been missed. Can distinct be used while querying the data? Do these duplicate rows come up in the preview section of the dataset also? It would be easier to solve, if the root cause could be identified. 
 
BIRTers, I might not be understanding it completely, anyone more aware of this problem can respond. 
 
regards 
Arpan </blockquote>
Hi Arpan, I'm running this report against Jazz and I can't use a query there. And yes, the duplicate rows come up in the data set preview as well. 
 
I'm actually looking for a script that can suppress these duplicates(or any other better solution?) 
 
Thanks

Megha Nidhi Dahal

<blockquote class='ipsBlockquote' data-author="'Bharath406'" data-cid="71276" data-time="1292249330" data-date="13 December 2010 - 07:08 AM">
Hi Arpan, I'm running this report against Jazz and I can't use a query there. And yes, the duplicate rows come up in the data set preview as well. 
 
I'm actually looking for a script that can suppress these duplicates(or any other better solution?) 
 
Thanks </blockquote>
 
I'm totally unaware of Jazz. Maybe you can throw up some light so that I can understand your problem better. How exactly is BIRT getting the data? The only ways that I have used and know is to get either from a flat file or from database. Probably if possible, the best solution would be to filter these duplicate rows from the source itself. 
 
Also, I can see that these records are not exactly duplicate, the approver's name column varies. 
 
Though I would try to find more about Jazz, I guess I'm not the right person to answer at this time. 
 
regards 
Arpan

mwilliams

Bharath406,

There is not a duplicated row in your above sample. There are 2 different approvers and 2 different approval descriptions that are mixed to make 4 rows. If you're only wanting 2 of these, which 2 do you want? How would you like these 4 rows to look given that there are 2 approvers each with the same 2 approvals?

Bharath406

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="71282" data-time="1292252726" data-date="13 December 2010 - 08:05 AM">
Bharath406, 
 
There is not a duplicated row in your above sample. There are 2 different approvers and 2 different approval descriptions that are mixed to make 4 rows. If you're only wanting 2 of these, which 2 do you want? How would you like these 4 rows to look given that there are 2 approvers each with the same 2 approvals? </blockquote>
Good catch Michael. Actually I missed that. But this still is an issue. Let me explain a bit. The record 88237 has two approval entries. 
Appr 1. 03 [LEAD] README & xxxxxxxxx approved by Christopher Thornton 
Appr 2. A1 [ENG] Patch reaxx xxxxxxx approved by Martin Sanders 
 
But somehow, if you see in the report, only two rows have the correct combination i.e., row 1 and row 4. So I need to filter off row 2 and row 3. 
 
I definitely don't know if it is a BIRT issue or Jazz issue. If you can help me out that would be great. 
 
Thanks

mwilliams

BIRT is just bringing in the data as it is given, so I don't think it'd be a BIRT issue. Is there any way you can determine who gives what approval? This is really your only option to filter rows out. You could, however create groupings that just list the 2 approvals and the 2 approvers. This wouldn't tell you who approved which, but it would reduce your "duplicate lines". You'd have to be able to tell who made what approval to do any better.

Bharath406

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="71296" data-time="1292264230" data-date="13 December 2010 - 11:17 AM">
BIRT is just bringing in the data as it is given, so I don't think it'd be a BIRT issue. Is there any way you can determine who gives what approval? This is really your only option to filter rows out. You could, however create groupings that just list the 2 approvals and the 2 approvers. This wouldn't tell you who approved which, but it would reduce your "duplicate lines". You'd have to be able to tell who made what approval to do any better. </blockquote>
Thanks Michael. I'll check out the options.

mwilliams

Alright. Let me know if you have any questions.