Displays a character string before the data columns in the report.
{ BEFORE "char" [ columnList ] }
| 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. |
The BEFORE command displays a designated character string before the 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.
The command { 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
|
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |