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 '*'

I am understanding this as your select statement with a paramater

Edited by DBlank - 08 Jun 2011 at 10:12am