Print Page | Close Window

Suppressing Duplicates Per Group

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22844
Printed Date: 02 May 2024 at 11:08pm


Topic: Suppressing Duplicates Per Group
Posted By: Tyson
Subject: Suppressing Duplicates Per Group
Date Posted: 02 Dec 2019 at 9:25am
I have a report for memorial gifts that contains the names of donors grouped by the names of the memorialized. To suppress duplicate donor names, I am using the formula: 

{GfCnAdrSal.GfCnAdrSal_Addressee}=previous({GfCnAdrSal.GfCnAdrSal_Addressee})


This works great except when the last donor in group 1 is the same name as the first donor in group 2. Then the matching name in group 2 gets removed. How can I prevent this and limit the matching to a per group basis?


Replies:
Posted By: kevlray
Date Posted: 02 Dec 2019 at 9:31am
Have a second criteria to check if the grouped name is the same (if not then suppress).

Posted By: Tyson
Date Posted: 03 Dec 2019 at 3:43am
Originally posted by kevlray

Have a second criteria to check if the grouped name is the same (if not then suppress).



Can you help me with how to form that? I'm not familiar with these formulas at all.

Posted By: kevlray
Date Posted: 03 Dec 2019 at 4:48am
Of course I do not know what field you are grouping on so I am just creating pseudo code.

{GfCnAdrSal.GfCnAdrSal_Addressee}=previous({GfCnAdrSal.GfCnAdrSal_Addressee})
and groupfield = previous(groupfield)

Posted By: Tyson
Date Posted: 03 Dec 2019 at 5:07am
Thank you. That works perfectly!


Print Page | Close Window