Replacing Missing Text or Zeros with Labels

When you run a report, there are often many empty data cells where no data was applicable to the retrieval, or cells where the value is zero.

The report displays the default #MISSING label in the data cell when no data values are found.

  To replace the #MISSING label with a text label, at the point in the script where you want to replace the #MISSING label with a text label, type:

{MISSINGTEXT ["text"]}

where text is the text string that to be displayed in the data cells.

You can place the MISSINGTEXT command at any point in the report script; the command applies throughout the script.

Note:

You can also suppress #MISSING labels from appearing in the report. See Suppressing Data Formatting for descriptions of SUPPRESS commands used to suppress labels.

  To replace zeros with a text label, at the point in the script where you want to replace zeros with a text label, type:

{ZEROTEXT ["text"]}

where text is the text string to be displayed in the data cells.

Note:

If a value is equal to #MISSING, any string inserted after that value using the AFTER command does not print. AFTER strings also do not print if you replace #MISSING with some other value (such as 0).