• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 13244
  • Last Modified:

How can you add IS NOT NULL or IS NULL critieria in Crystal 8.5

Hello,

I'm new to Crystal, and in version 8.5, when I get to the portion of the Report Expert Wizard that lets me define my selection critieria, I can't seem to find how I can perform IS NULL or IS NOT NULL criteria.  I select a field, but the values that appear in the critieria box (is a value, is not equal to, is gretaer than, etc) does not include IS NULL or IS NOT NULL.  I know there has to be a way to do this, so maybe I am just missing it.

Thanks,
Chris
0
ccorrente
Asked:
ccorrente
  • 2
2 Solutions
 
peter57rCommented:
Hi ccorrente,

Show the selection formula and type directly into it.

isnull({mytable.myfield}


Pete
0
 
mlmccCommented:
For the negation

NOT IsNull({mytable.myfield})

mlmcc
0
 
bdreed35Commented:
You can also do it from the Report Expert, by choosing the last option, "Formula", in the drop down.
You can then enter the criteria such as what Pete as posted.  

BTW, I am sure it was a typo, but Pete's formula will need a closing parenthesis at the end.
0
 
mlmccCommented:
Glad i could help

mlmcc
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now