Null value problem

There can be problems with reports created in Crystal Reports from the SIS data warehouse regarding null values.

What is a null value?

A null value represents the lack of value. In the SIS data warehouse, fields with null values have no data. A null is NOT synonymous with zero.

What is the problem?

There are two potential problems.

  1. Incorrect numbers of rows returned from queries that use an 'OR'.

  2. Incorrect sums, totals, and averages when using the report option 'Convert NULL Field Value to Default'.

Back to top