The BEFORE command displays a character string before the data columns in the report.
{ BEFORE "char" [ columnList ] }
char | A single 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. |
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
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.