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!
  • Students Click Here

*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


Crystal Report - How to prevent records from Duplicating

Crystal Report - How to prevent records from Duplicating

Crystal Report - How to prevent records from Duplicating

Need a little assistance with a report I am attempting to complete. I have 3 files from which I am getting data and I have used the Select Distinct Records under the Database tab but this is not eliminating my duplicates.

The files I am using are Task file, InvAdj File and finally Location file. Each of these files have what we call the long SKU which is Sea (season), SYR (SeasonYear), Style, Style Suffix, Color and SZCD (Size code) and SZPO (Size Posn) in addition to that the have Whse, Co and Div.

On the report I want to show all the records from the Task file that match, based upon certain criteria, the other two files and the resulting data I am receiving is what is expected except for the fact that there are multiple occurrences of the same record.

Is there a way to eliminate the multiples? I am uncertain to where to begin to look for the solution.

Appreciate any help. Not sure what information would be needed to clarify my request.

Thank you

RE: Crystal Report - How to prevent records from Duplicating

Sometimes records get duplicated because a table join gets missed but often it arises because of a one to many relationship between tables. The usual approach to dealing with the latter issue is to use a Group and move the displayed fields from the Details section to the Group Header or Footer.

It is a bit difficult to be any more specific than this with the information available. If you can post the SQL (Database => Show SQL Query), some sample data and an explanation of what duplicates you don't want to see it might help. If you are prepared to post the RPT file (with saved data) I'd be happy o take a look for you, but understand it if you can't due to issues of confidentiality.


RE: Crystal Report - How to prevent records from Duplicating

Hi pmax9999
Sorry for the delay in responding. I did end up resolving the issue just by chance but doing suppressing all the detail fields that were duplicated. When I did this I found one field that was not duplicating and realized what was causing the multiple lines to appear (it happened to be a date field) Based upon this discovery I added another line to a Yes/No formula I have and the duplicates were removed. The data looks good now and we are testing as we go along to insure this change is correct.

I appreciate you taking the time to assist with my questions.

Thank you

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!

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