<< Click to Display Table of Contents >>

Ignore Null Data

Indicates whether to ignore Null Data

Values

True

When the data type is a character type, it is handled as "". When it is a number type, it is handled as 0

False

Treated as Null data

Reference

In the Query Designer, as well as Report, to use null to the null data, sets the property value to False. To use null to the "" or 0, sets the property value to True.

To use null in Report, sets the "Ignore Null Data" of "OZ data tree" to False in Query Designer and sets the "Ignore Null Data" of "Data Tree" to False in Report Designer.