COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: murali on 02 May 2006 08:38:16 PM

Title: showing only duplicate records in a report
Post by: murali on 02 May 2006 08:38:16 PM
Hi Friends,

I have a requirement like i have to show only the duplicate records in tht report tht is the amount which is repeated in the report and all other records i want to block. Can any one suggest weather this is possible in reportnet? If so how i can filter the only the repeated amount and show in the report.

Any help will be greately appreciated.


Thanks
Murali
Title: Re: showing only duplicate records in a report
Post by: cogman on 03 May 2006 05:22:14 PM
Ddi you try using Group By and then applying count >
Title: Re: showing only duplicate records in a report
Post by: sunintsingh on 20 Sep 2006 03:31:24 PM
Hi Murali,

Did you figure it out?

If yes, could you please help me with the same answer? I have same requirement.

Will appreciate it

Sunny
Title: Re: showing only duplicate records in a report
Post by: pw on 20 Sep 2006 04:49:43 PM
I did this by creating a materialized view with all duplicate entries in it.
also i aggregated the count() of each dupe and a sum of all (report was about duplicate files on a server)