Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Issue: How to display is not null records Post Reply Post New Topic
Author Message
HHGregg
Newbie
Newbie


Joined: 08 Jun 2011
Location: United States
Online Status: Offline
Posts: 2
Quote HHGregg Replybullet Topic: Issue: How to display is not null records
    Posted: 08 Jun 2011 at 8:10am
Hey All,

Crystal Report and syntax noobie here. 

Issue:  I'm trying to create a parameter that if it is equal to "Is Not Null" then it will return all customers where the customers.code field is not null.  I will default the value to "Show All" so the report will show all records no matter if the code value is null or not.

I've tried the below in the Selection Expert, but it isn't doing what I'm wanting to do.  Thanks for your help.

If [{?Code Not Null}] = "Is Not Null"
Then isNULL({CUSTOMER.CODE) = False
Else If [{?Code Not Null}] = "Show ALL"
Then {CUSTOMER.CODE} like '*'
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 08 Jun 2011 at 9:36am
I either use len({#field})<1 or
not(isnull({#field}))
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 08 Jun 2011 at 10:11am
I am understanding this as your select statement with a paramater
 
(NOT(ISNULL({CUSTOMER.CODE)) and {?Code Not Null} = "Is Not Null")
or 
({?Code Not Null}] = "Show ALL")


Edited by DBlank - 08 Jun 2011 at 10:12am
IP IP Logged
HHGregg
Newbie
Newbie


Joined: 08 Jun 2011
Location: United States
Online Status: Offline
Posts: 2
Quote HHGregg Replybullet Posted: 09 Jun 2011 at 8:41am
I tried DBlank's suggestion and it worked!  Thanks so much!
IP 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.016 seconds.