{BEFORE}

Command

The BEFORE command displays a character string before the data columns in the report.

Syntax

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

Description

Quotes without a character string clear the text displayed before data columns. For example, { BEFORE "" } turns off previously issued BEFORE commands.

Example

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

See Also

AFTER


Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.