Crystal Reports Conditionally supress text

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Conditionally supress text

Post Reply

Post New Topic

Author	Message
Dav1d Newbie Joined: 24 Sep 2010 Location: United Kingdom Online Status: Offline Posts: 5	Topic: Conditionally supress text Posted: 24 Sep 2010 at 8:06am
	Would be grateful for tip on how to supress text subject to condition of variable. e.g. I do not want to print a label such as "Fax." if there is no Fax number. Many thanks
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 24 Sep 2010 at 10:39am
	right click on the text field select the formula box for suppress and enter your condition there isnull(table.fax)
	IP Logged

Dav1d Newbie Joined: 24 Sep 2010 Location: United Kingdom Online Status: Offline Posts: 5	Posted: 24 Sep 2010 at 11:02am
	Many thanks But did not work. The variable is a parameter rather than from a table. Any difference Thanks
	IP Logged

Dav1d Newbie Joined: 24 Sep 2010 Location: United Kingdom Online Status: Offline Posts: 5	Posted: 24 Sep 2010 at 11:09am
	Have just tested on a variable that is from a table. Also did not work. If I just tick the supress box, it suppresses but if I enter isnull() with the variable the text still prints? Thanks Dav1d
	IP Logged

Dav1d Newbie Joined: 24 Sep 2010 Location: United Kingdom Online Status: Offline Posts: 5	Posted: 24 Sep 2010 at 11:33am
	OK Cracked it variable="" works Thanks for putting me on track Dav1d
	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