平特五不中

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

Back to top