Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : 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: 1587
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: 1587
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.023 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.