Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: repeat field Post Reply Post New Topic
Author Message
kader
Newbie
Newbie
Avatar

Joined: 11 Jun 2012
Location: Qatar
Online Status: Offline
Posts: 18
Quote kader Replybullet Topic: repeat field
     Posted: 09 Dec 2012 at 8:50pm
Can anyone tell me how to avoid a record if a field is repeating ??
 
eg..
 
Field 1                         Field 2
Ord 1010                      INV1010
ORD1010                      inv1011
ord1022                         inv1012
ord1033                         inv1013
 
 
In the above I don't want to appear ORD1010 2 times eventhough invoice no. is not repeated.
 
thank you.Smile
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 09 Dec 2012 at 10:27pm
Hi
 
Go in Section expert and select the section where you have these details and click on Suppress formula editor and give the follwoing  condition :
 
 
{Field1}=Previous({Field1})
 
Note : Your previous and current row field values should be same, then only the above works.
 
Thanks,
Sastry
IP IP Logged
kader
Newbie
Newbie
Avatar

Joined: 11 Jun 2012
Location: Qatar
Online Status: Offline
Posts: 18
Quote kader Replybullet Posted: 12 Dec 2012 at 2:41am
Thank you sir, it is ok for suppress the record. can we omit those records.
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.