Formatting empty cells and null values

Some cells within the tables in your data source may be empty because the data was not available. This, along with other reasons, can cause cells in some reports to be empty. You can determine how these empty or null values are handled for display within a report. Determining a specific format for null values can be helpful for analysts who might otherwise be confused on seeing one or more blank cells in a report.

In Freeform SQL reports, null values can occur when the report references unavailable objects. For example, you map the attribute description and ID forms of the Region attribute, but you only include the ID in the SELECT clause. When the report is executed, the description cannot be displayed because it has not been retrieved from the data source.

For steps to format empty cells or null values, see Formatting null values and blank cells in Formatting a Report.

Analysts can apply formatting for null values to a given report, if they want to.