BEFORE

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 ] }

Parameters

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

The following report script is designed for the Demo Basic cube, available in the gallery. { BEFORE "$" } is used to display the dollar sign before all the data values.

<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