Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions  
Message Icon Topic: Suppressing Duplicates Per Group Post Reply Post New Topic
Author Message
Tyson
Newbie
Newbie


Joined: 02 Dec 2019
Online Status: Offline
Posts: 3
Quote Tyson Replybullet Topic: Suppressing Duplicates Per Group
    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?
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1507
Quote kevlray Replybullet Posted: 02 Dec 2019 at 9:31am
Have a second criteria to check if the grouped name is the same (if not then suppress).
IP IP Logged
Tyson
Newbie
Newbie


Joined: 02 Dec 2019
Online Status: Offline
Posts: 3
Quote Tyson Replybullet 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.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1507
Quote kevlray Replybullet 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)


Edited by kevlray - 03 Dec 2019 at 4:48am
IP IP Logged
Tyson
Newbie
Newbie


Joined: 02 Dec 2019
Online Status: Offline
Posts: 3
Quote Tyson Replybullet Posted: 03 Dec 2019 at 5:07am
Thank you. That works perfectly!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.