Crystal Reports Null fields

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

Topic: Null fields

Author	Message
bturner Newbie Joined: 17 Jun 2010 Location: United States Online Status: Offline Posts: 28	Topic: Null fields Posted: 07 May 2018 at 8:12am
	Trying to create a formula that will not incorporate null fields.
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 08 May 2018 at 7:21am
	?!? You want to filter out all fields that are Null?
	IP Logged

bturner Newbie Joined: 17 Jun 2010 Location: United States Online Status: Offline Posts: 28	Posted: 08 May 2018 at 7:30am
	Yes.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 08 May 2018 at 8:01am
	NOT(isnull({table.field}))
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 09 May 2018 at 6:41am
	And of course, make sure the 'Default Values for Nulls' is selected in the formula editor. Also another note. If you are checking a string value for nulls, it is generally more reliable to check for zero length (i.e., len({table.field}) = 0)
	IP Logged

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.027 seconds.