This article covers how to conditionally use different tables within the same report and how to avoid the common mistakes.

Reports of this type are normally the result of mixed rules being applied to the same area within a business.  Because the business area is one logical unit to report against, the client wants all the data measured together.  This includes the exceptions to the rules, which logically don't fit, but still need including.

I am going to use the free sample MS Access Database Xtreme, which ships with Crystal Reports.

The report requirement we are going to work towards is:

"A single report to show all the customers who have ordered under £500 items, including those that ordered nothing.”