Crystal Reports is not null

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

Topic: is not null

Author	Message
smara90 Newbie Joined: 14 Apr 2014 Online Status: Offline Posts: 3	Topic: is not null Posted: 21 Apr 2014 at 12:09pm
	Hi everyone, I am totally new at crystal reports and I'm trying to select only the records that have one of the fields not null. I've tried {#field}<>'' and not(isnull({#field})) but it doesn't work, cat anyone give me an idea? It's driving me crazy
	IP Logged

kostya1122 Senior Member Joined: 13 Jun 2011 Online Status: Offline Posts: 475	Posted: 21 Apr 2014 at 2:04pm
	this should work not(isnull({#field})) you could also use {#field}<>'' but at the top change "exceptions for Nulls" to "default values for nulls"
	IP Logged

smara90 Newbie Joined: 14 Apr 2014 Online Status: Offline Posts: 3	Posted: 22 Apr 2014 at 7:15am
	awesome! It worked :D Thanks!
	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.032 seconds.