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.
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.