Suppressing Duplicates Per Group
Printed From: Crystal Reports Book — Forum Name: Technical Questions
Posted By: Tyson — 2 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?
Posted By: kevlray — 2 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 — 3 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 — 3 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 — 3 Dec 2019 at 5:07am
Thank you. That works perfectly!
|
