Display Null On Top

The Display Null on Top VLDB property determines where NULL values appear when you sort data. The default is to display the NULL values at the bottom of a list of values when sorting.

Wherever NULL values occur in a report, they appear as user-defined strings. NULL values result from a variety of scenarios. NULL values can come from data retrieved from the database, from cross-tabulation on a report, or from data aggregation on a report. You can specify the characters or strings that appear for NULL values.