Crystal Reports Convert 0 value to blank in field

Report Design

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

Topic: Convert 0 value to blank in field

Post Reply

Post New Topic

Author	Message
knovak Newbie Joined: 18 Mar 2009 Online Status: Offline Posts: 1	Topic: Convert 0 value to blank in field Posted: 18 Mar 2009 at 10:00am
	I have a value of zero in a dataset that is linked to my CR. If the value is 0, I want to display nothing for that field on the report. I've looked through the functions and done several google searches but have come up empty. Is there an easy way to do this? Thanks, Kyle
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 18 Mar 2009 at 11:42am
	Will conditionally suppressing suffice? Right click on the field and select Format Field and then the Common Tab. Next to the Suppress option clcik on the formula and enter: *{table.field}=0* If you want the whole row suppressed add that condtion into the Section Expert Suppress formula.
	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