Displays a character string before data columns in the report.
Quotes without a character string clear the text displayed before data columns. For example, { BEFORE "" } turns off previously issued BEFORE commands.
Syntax
{ BEFORE "char" [ columnList ] }
Parameter | Description |
---|---|
char | A single-byte character enclosed in quotation marks. |
columnList | Optional. List of the column numbers, separated by spaces, that you want char to precede. Without columnList, char is displayed before all columns in the report. |
Notes
Double-byte characters are not supported.
Example
{ BEFORE "$" } displays the dollar sign before all the data values in the following report:
<PAGE Market, Accounts, Scenario) Chicago Sales Actual <COLUMN Year) <ICHILDREN Year <ROW (Product) { BEFORE "$" } <ICHILDREN Audio !
This example produces the following report:
Chicago Sales Actual Qtr1 Qtr2 Qtr3 Qtr4 Year ======= ====== ====== ====== ======= Stereo $2,591 $2,476 $2,567 $3,035 $10,669 Compact_Disc $3,150 $3,021 $3,032 $3,974 $13,177 Audio $5,741 $5,497 $5,599 $7,009 $23,846
See Also