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'.

   e.g.	({SR_ACADEMIC_FAC.PRIM_MINOR1_CODE}= "ECN8" or
   	{SR_ACADEMIC_FAC.PRIM_MINOR2_CODE}= "ECN8")

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