×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How can I report on ONLY duplicate records?

How can I report on ONLY duplicate records?

How can I report on ONLY duplicate records?

(OP)
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
Replies continue below

Recommended for you

RE: How can I report on ONLY duplicate records?

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

RE: How can I report on ONLY duplicate records?

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close