Find Duplicate Records

[Jaimekb]

I want to produce a report that will display ONLY duplicates.
Can anyone tell me how to do this?

Thanks.

 

[kenhamady]

Create a group on a field that should be unique (so that the duplicates are in the same group). Most groups will have one record. Those that don't are the duplicates.

Create a summary field that counts the records in each group. Most will have one.

In the select expert create a rule using this summary field. Select where the Count is greater than 1.

The report will retrieve all records that meet the other criteria but will only PRINT the groups that are duplicates. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.