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.
-
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") -
Incorrect sums, totals, and averages when using the report option 'Convert NULL Field Value to Default'.