Value if Null property
The Value if Null property specifies a value to be substituted for any null
values of the column. For example, if you enter X in this field for a character
type column, then an X will be displayed for null values fetched for the column.
If left blank, no substitution will be done for null values.
Applies to |
Columns |
Values |
Any valid value that conforms
to the column's Datatype, up to 1K in length. |
Default |
Blank |
Required/Optional |
Optional |
Restrictions
- For columns with a character datatype (for example, VARCHAR),
if the width of the string you enter for Value if Null exceeds the Width
of the column, the string is truncated.
- If a column is referenced with a lexical reference
in a query, that column's Value if Null is used to validate the query.
- The value entered for Value If Null must be the
same datatype as the column. For example, if the column's Datatype is
Number, you cannot specify "XX"
in Value If Null, you must specify a number.
- If you enter a date value in Value If Null, it
is validated against Reports Builder's internal mask for dates (that is,
DD-MON-YY). (Number and character values are not validated.)
Usage notes
- Entering a string for Value if Null on a break
column causes Reports Builder to prefetch all of the rows in the break
column's group. This could degrade performance when you run the report.
To avoid prefetching, use the NVL function in your query rather than setting
the Value if Null property to a string.
Copyright © 1984, 2005, Oracle. All rights reserved.