Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: supress a section if a value field is null Post Reply Post New Topic
Author Message
thunderball
Newbie
Newbie


Joined: 25 Jun 2010
Location: India
Online Status: Offline
Posts: 12
Quote thunderball Replybullet Topic: supress a section if a value field is null
     Posted: 04 Jul 2010 at 8:21am
Hi ,
 
If a particular field is null, then all the corresponding row should not be  displayed.However if that field is not null then all the corresponding rows need to be displayed.
Please let me know how to do this.


Edited by thunderball - 04 Jul 2010 at 8:32am
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 04 Jul 2010 at 9:45am
Hi
 
What you need to do is select the number fields in the row right click and select format field then in common tab click x+2 next to suppress and enter the code below
 
isnull({table.fieldname})
 
hope that works..
 
Cheers
Rahul


Edited by rahulwalawalkar - 04 Jul 2010 at 9:45am
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