Updated: Wed, 10/02/2024 - 13:45

From Saturday, Oct. 5 through Monday, Oct. 7, the Downtown and Macdonald Campuses will be open only to McGill students, employees and essential visitors. Many classes will be held online. Remote work required where possible. See Campus Public Safety website for details.

Du samedi 5 octobre au lundi 7 octobre, le campus du centre-ville et le campus Macdonald ne seront accessibles qu’aux étudiants et aux membres du personnel de l’Université McGill, ainsi qu’aux visiteurs essentiels. De nombreux cours auront lieu en ligne. Le personnel devra travailler à distance, si possible. Voir le site Web de la Direction de la protection et de la prévention pour plus de détails.

McGill.CA / Enrolment Services / SIS Data Warehouse / Crystal Reports

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