Crystalkeen logo; we offer Crystal reports viewers and schedulers
Crystalkeen header image 3
Crystalkeen header image 5

Crystal Reports Tools: Improve Performance While Saving Time and Money




CR Schedulers
CR Viewers
DataBase Tools
Mail UFLs


About us

Contact Us

on Steroids

Crystal Reports: Recognizing Nulls in Formulas

If you have a formula like this:

If {table.field}<value then "ResultA" else "ResultB"

and the field is Null ,you get neither result.

The only solution is to use the IsNull function as follows:

If IsNull({table.field}) then "NullResult" else

If {table.field}<value then "ResultA" else "ResultB"

Do you think maybe you have nulls or null-generating formulas you can't find, and worry they'll bite you some day? At the worst possible time (the day before your performance appraisal, for example)?

To see where these are, we have a great tool called Report Analyzer.

Report Analyzer for Crystal Reports Screenshot

Originally developed as a Crystal Reports tool only, with its version 5 release Report Analyzer became a powerful tool for analyzing any data source or repository.


This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.


Except where an author's name is given at the start of the article, all of these articles were written by Mo Naughton or Bruce Ferguson and edited by Mark Lamendola. Mo is a Crystal Reports consultant, trainer, and developer for Chelsea Technologies, Inc. Bruce Ferguson is a Crystal Reports consultant, trainer, and developer for CrystalKiwi, Inc. Mark Lamendola is a writer and editor with over 15 years experience in professional and trade publications.


  • Questions? Please write to We do want your business.
  • Do you have your own tips for Crystal Reports administrators and designers? Write to and we'll post your tips with a link to your Website (or with some other attribution if you choose).
  • Crystal Reports is a subsidiary of Business Objects, which is owned by SAP.