Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can I report on ONLY duplicate records?
- Thread starter jolie555
- Start date
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.
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.
- Status
Similar threads
- Locked
- Question
- Locked
- Question