WIDTH

Specifies the width of columns in a report.

Syntax

{ WIDTH number [ column1 [ column2 [ columnN ] ] ] }

number New column width in characters.
column1 column2 columnN Optional. Numbers designating the columns to resize, separated by spaces. Values: between 0 and 161, where 0 is the first row-name column. If column-numbers are not specified, all columns are resized to the width indicated by number.

Default Value

If the WIDTH command is not used, all columns are wide enough to fit the widest data value.

Description

If the WIDTH command is followed by number with no column selections, number sets the width for all data columns in the report. Otherwise, the width is set for each data column listed in the command. Column numbers are assigned starting at 0 for the first row-name column, incrementing by one for each row-name column, data column, and calculated column, in that order. The tilde character (~) follows member names or values that must be truncated to fit in the column to indicate part of the name or value is not displayed. If possible, space from adjacent columns is used to avoid truncating. The widths of names columns widths may be adjusted if their column numbers (0,1,...) are specifically included in the command. Alternatively, the NAMEWIDTH command may be used.

Notes

Example

The following example is based on Sample Basic.

<PAGE (Measures, Market)
Illinois Sales
<SYM
{WIDTH 7}
{WIDTH 20 0}
     <COLUMN (Scenario, Year)
     Actual Budget Scenario
     Jan Feb Mar
<DESCENDANTS "100"
     !

Which resizes all data columns to a WIDTH of seven and the row name label column (column 0) to a WIDTH of 20.


                                            Sales Illinois 

                           Actual               Budget              Scenario       
                       Jan    Feb    Mar    Jan    Feb    Mar    Jan    Feb    Mar 
                    ====== ====== ====== ====== ====== ====== ====== ====== ====== 

100-10                 345    354    367    360    370    380    345    354    367 
100-20                 234    254    267    240    260    280    234    254    267 
100-30              #Missi #Missi #Missi #Missi #Missi #Missi #Missi #Missi #Missi 

See Also

NAMEWIDTH

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com