Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: supressing duplicate values except on first record Post Reply Post New Topic
Author Message
jrs1234
Newbie
Newbie


Joined: 02 Mar 2009
Location: United States
Online Status: Offline
Posts: 37
Quote jrs1234 Replybullet Topic: supressing duplicate values except on first record
    Posted: 05 Aug 2009 at 7:12am
Hello,
 
I have a database of names/addresses which has a 'name id' field ... I am trying to create labels for these names - in this table there can be and are duplicate names/name id's since the person can be put into this table many times.
 
So I am using the crystal template for labels and I am choosing to supress the detail lines if : nameid = previous(nameid) - and this works except for the first record - the first record is always missing - so I am assuming  that because there is not a nameid to compare it to on the first record it is not showing it..
 
However if this is the case, I am not sure how to write the formula so the first record will show? any ideas?
 
Thanks
Jenn
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Aug 2009 at 7:28am
add
NOT onfirstrecord
to your formula for the suppression
IP IP Logged
jrs1234
Newbie
Newbie


Joined: 02 Mar 2009
Location: United States
Online Status: Offline
Posts: 37
Quote jrs1234 Replybullet Posted: 05 Aug 2009 at 7:38am
THANKS so much!!! It worked Big%20smile
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.031 seconds.