Crystal Reports Help with null values

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

Topic: Help with null values

Author	Message
crystalgal Groupie Joined: 20 Feb 2009 Location: United States Online Status: Offline Posts: 66	Topic: Help with null values Posted: 05 Nov 2009 at 6:39am
	I am having a problem with supressing a null value. My report has 9-10 columns and first 2 can be null. If the first 2 fields are null I want to supress the entire row. How can we do that in crystal? Thanks in advance.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 05 Nov 2009 at 7:12am
	Go into section expert select the detial section (asuming this is what you want to suppress) click on the formula fiel next to the SUppress (no Drill down) add your conditional formula here *isnull({table.field1}) and isnull({table.field2})*
	IP Logged

crystalgal Groupie Joined: 20 Feb 2009 Location: United States Online Status: Offline Posts: 66	Posted: 05 Nov 2009 at 7:26am
	Thank you, Thank you ,Thank you, DBlank Worked like a charm
	IP Logged

Post Reply

Post New Topic

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

This page was generated in 0.035 seconds.