Row duplicates Supress

Hi All,

I m using the BIRT 2.3.2.
We have a Table and we need to avoid the row duplicates.
For this i have used Row option "supress Duplicates" and set it as "true".

But this option is not working and the column supress is working.
Could anyone please tell me is there any other option need to set to work row supress.

Note :- I need to work out row supress.is there any limitations or settings for this.

Thanks and Regards
Swetha.

Find more posts tagged with

Comments

sswetha

PFA output.

Thanks and Regards
Swetha.

cohara

Hi Swetha 
 
There is a discussion of this behaviour on Bugzilla here <a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=144383'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=144383</a> 
 
The supress duplicates feature currently allows duplicate data in a column to be omitted visually from a report, but the supression of entire rows is a future enhancement request. 
 
The easiest way to remove duplicate rows form your report is probably to scrub or filter the original data set to remove duplicates. For example, if you are using a JDBC data source with a SQL query, you could use SELECT DISTINCT rather than SELECT to retrieve your data. 
 
Hope this helps.