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!
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
Last Comment
Melisa B
ASKER CERTIFIED SOLUTION
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.
SOLUTION
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.
ASKER
Where do I put that one? Sorry, I'm terrible at this.
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
Right click the object on the report
Click FORMAT OBJECT
Click the COMMON TAB
Click the FORMULA button to the right of suppress
mlmcc
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
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.
ASKER
Ahhhhh! You're my new best friend. Thank you best friend!!!! xoxoxoxo
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.