is not null
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20665
Printed Date: 01 May 2024 at 9:42pm
Topic: is not null
Posted By: smara90
Subject: is not null
Date 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 
|
Replies:
Posted By: kostya1122
Date 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" |
Posted By: smara90
Date Posted: 22 Apr 2014 at 7:15am
| awesome! It worked :D Thanks! |