Controlling Column Spacing: SET SPACES

How to:

By default, FOCUS puts one or two spaces between report columns, depending on the output width. The SET SPACES command enables you to control the number of spaces between columns in a report.

Syntax: How to Control Column Spacing 

SET SPACES = {n|AUTO}

Valid values are:

n

Is a number indicating from 1 to 8 spaces.

AUTO

Specifies that FOCUS automatically puts one or two spaces between columns depending on report output and available output length. AUTO is the default setting.

SET SPACES may also be issued from within a TABLE request.

For ACROSS phrases, SET SPACES n controls the distance between ACROSS sets. Within an ACROSS set, the distance between fields is always one space and cannot be changed.

Example: Controlling Column Spacing

The following example illustrates the use of ACROSS with SET SPACES: 

TABLE FILE CAR
SUM DEALER_COST RETAIL_COST ACROSS CAR BY COUNTRY
IF CAR EQ 'ALFA ROMEO' OR 'BMW'
ON TABLE SET SPACES 8
END

The ACROSS set consists of the fields DEALER_COST and RETAIL_COST. The distance between each set is eight spaces. 

                  CAR                                                   
                  ALFA ROMEO                     BMW                    
COUNTRY           DEALER_COST RETAIL_COST        DEALER_COST RETAIL_COST
------------------------------------------------------------------------
ITALY                  16,235      19,565                  .           .
W GERMANY                   .           .             49,500      58,762
 Information Builders