This simple technique can save hours of development time as the other option is to create two reports and merge them together.

There are just two basic things to remember:

1.  Crystal Reports formulas will not read the remainder of a control structure once a condition returns 'true'.

IsNull can be used to test links to child tables as well as the contents of fields.

About the Author

Jason Dove is the author of 'Crystal Reports Formulas Explained' a step by step guide to creating and using formulas, currently available with a free 70 page Crystal Reports XI tutorial: http://www.scry-business-intelligence.com/products/bookoffer.php.

He has provided BI consultancy for some of the largest companies in the UK, and is now working with Scry Business Intelligence. Subscribe to his FREE Career newsletter here: http://www.scry-business-intelligence.com/ScryCareerGuide.php