supressing duplicate values except on first record
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=7256
Printed Date: 02 May 2024 at 1:43am
Topic: supressing duplicate values except on first record
Posted By: jrs1234
Subject: supressing duplicate values except on first record
Date 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
|
Replies:
Posted By: DBlank
Date Posted: 05 Aug 2009 at 7:28am
|
add
NOT onfirstrecord
to your formula for the suppression
|
Posted By: jrs1234
Date Posted: 05 Aug 2009 at 7:38am
THANKS so much!!! It worked 
|