Avatar of Melisa B
Melisa B
 asked on

Crystal Reports - Suppress Non-Consecutive Duplicates in Group

I'm working on building a report that pulls name data based on a specific report identification number. I have the information grouped by the report number and want to display names related to the report. The problem is that each report number can/often does have subsequent reports written that are attached to the same number which include the same names, thus giving me duplicate names in the group, but not listed consecutively. The report looks like this currently:

Report #                Name
170001                   Smith, Bob
                                Doe, John
                                Doe, Jane
                                Smith, Bob
                                Doe, John
                                Doe, Jane
170002                   Jones, Mike
170003                   White, James
                                White, Jack
                                White, James

I want to suppress all instances where there are duplicate names under the same report number.

Thanks in advance for any help!
Crystal Reports

Avatar of undefined
Last Comment
Melisa B

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Mike McCracken

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Melisa B

ASKER
The report has the following headers/information:
Report #
Date
Report Type
Location
Make (of Vehicle)
Style (of Vehicle)
Type (for the person listed, this includes codes for the following - suspect, defendant, arrested party)
Name (of the suspect, defendant, arrested party - suspect if they're named, defendant if they're identified in the course of the investigation, arrested party if they're actually arrested for the crime)

The report is grouped by report number so that I avoid duplicates on those - each report can have anywhere from just the original report to several supplemental reports with duplicate information on everything except the actual narrative, so I run into this problem A LOT. The formulas you gave me worked beautifully, but now I can't suppress "blank" sections because of the "Type", since if there are 2 suspects listed, the code shows for each listed suspect name AND the code is there for those blank suspect name fields...so it looks like this:

11111            01/13/17             AUTO THEFT          123 MAIN ST           CHEV/LL        SUS          SMITH,CARL
                                                                                                                                             SUS          SMITH,MARIA
                                                                                                                                             SUS
                                                                                                                                             SUS

because the suspects are listed in both the original and the supplement report. If I suppress duplicates, the code next to MARIA will also disappear, and since there is more than one possible code that could be there, it would create confusion.
SOLUTION
Mike McCracken

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Melisa B

ASKER
Where do I put that one? Sorry, I'm terrible at this.
Mike McCracken

In the suppression formula for the object

Right click the object on the report
Click FORMAT OBJECT
Click the COMMON TAB
Click the FORMULA button to the right of suppress

mlmcc
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Melisa B

ASKER
When I put it in the Suppress formula section, the entire column was blank. When I put it in the Suppress if Duplicated formula section, it suppressed the duplicates in each group.
SOLUTION
Mike McCracken

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Melisa B

ASKER
Ahhhhh! You're my new best friend. Thank you best friend!!!! xoxoxoxo