HOW CAN I GET THE REPORT TO SHOW JUST NULL FIELD VALUES? 2

[Nmartin95]

How can I run a report that shows me that a particular field is NULL or blank. For example, a report that shows me all trouble tickets that do not have a computer name in them. Note: ComputerName is a field in the database tables I am working with. Any help would be greatly appreciate. I am working with Crystal 7.01.
Thanks

 

[kenhamady]

If the field is truly null, use a selection formula like:

IsNull ( {ComputerNameField} ) Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[synapsevampire]

This formula would be placed in the record selection criteria, it checks for null or blank.

IsNull ( {ComputerNameField} )
or
trim({ComputerNameField}) = ""

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com