showing only duplicate records in a report

[murali]

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

[cogman]

Ddi you try using Group By and then applying count >

[sunintsingh]

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

[pw]

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)