Suppress Duplicate records.

I have group1 that prints "x" amount of records in order to produce a separate report for each record.  There are times when the records are duplicates, and I do not want to process the dups.  I then have group2 that processes these same records, and lists them within each report.  I need it to show the duplicates within the report, but not print it when processing group1.  

Group1
        abc corp
        xyz corp
        dhl corp
        abc corp

I need suppress duplicate occurences within Group 1.  Group1 is used specicially to print reports all the records processed.

Group2
       abc corp
        xyz corp
        dhl corp
        abc corp

However, I need all the records displayed within each report.

How can I create a suppression formula for group1 not to process duplicate records?  I tried selecting distinct records within the Database menu without luck.  Thanks...






cmp119IT ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Where are you doing this?

What are you grouping on?

mlmcc
cmp119IT ManagerAuthor Commented:
I am grouping by claim ID.  Each record has a unique claim id, but can have the same Payee.NameID.  Grouping is accomplished using the group expert.
mlmccCommented:
I think if you add a new group - Company Name you can use the group header for the information.  Since the group header is only printed once for each group you should see a company only listed once.

mlmcc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
Glad i could help

mlmcc
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.