How can I report on ONLY duplicate records?

[jolie555]

Our AMS is composed of about 18,000 producer files. I want to create a report that will show duplicate entries. I would like to do this by social sec # as names may have been entered differently... Hope this made sense...

Thanks!
Jolie

 

[dgillz]

Group by SS# and insert a count summary. Then do a group selection formula where the count of the SS#>1. This will return only duplicates. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[rhinok]

dgillz' solution is very simple within Crystal Reports itself, but you're going to pull back all records before you can evaluate the count. Depending on the size and integrity of your DB, this may not be ideal.

If possible, use a view to eliminate unnecessary records before they ever get to Crystal. Following is a simple example:

Select
A.Producer
From
Table A
Group By
A.Producer
Having
Count(A.Producer) > 1

In this sample, you will eliminate all single producer records before you pull the data into Crystal.