Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Filtering out non duplicates of Birt dataset
Migrateduser
<p>I'm using Birt Report Designer to create the report.</p><p>I need to create a Birt report that will show the duplicate values for a given field plus the other fields on that row of dataset results. The MS SQL Server query returns a set of rows that look like this. The results are ordered by Rack.<br />
[font="'courier new', courier, monospace;"]RACK DC SYS<br />
09 2 DEF<br />
10 1 AAA <br />
10 5 ABC<br />
12 1 A2B<br />
15 2 EFG[/font]<br />
<br />
After parsing the results, the display should look like this.<br />
[font="'courier new', courier, monospace;"]RACK DC SYS<br />
10 1 AAA <br />
10 5 ABC[/font]<br />
<br />
Duplicates in the Rack column indicate a problem and I don't want to hide the problem by making the Rack field not accept duplicates.<br />
<br />
I'm not sure which event handler this parsing should be done in and how to parse & remove non duplicated rows from the result set. The database table should be untouched after this parsing.</p><p> </p><p>Any help would be greatly appreciated.</p>
Find more posts tagged with
Comments
There are no comments yet