How to: Reference: |
FOCUS automatically formats a page and uses common default values for determining column positions and spacing. You can override these defaults by specifying the absolute or relative column position where a data value is to appear on a report.
field IN {n|+n}
Valid values are:
Is the field (that is, the column) that you want to move.
Is a number indicating the absolute position of the column.
Is a number indicating the relative position of the column. That is, +n is the number of characters to the right of the last column.
The following request positions all of the report columns:
TABLE FILE EMPLOYEE PRINT BANK_NAME IN 1 BY HIGHEST BANK_ACCT IN 26 BY LAST_NAME IN 40 END
This request produces the following report. There is a blank line following Smith because LAST_NAME is a sort field and there are two employees named SMITH in the database.
BANK_NAME BANK_ACCT LAST_NAME
--------- --------- ---------
ASSOCIATED 819000702 IRVING
BANK ASSOCIATION 163800144 CROSS
ASSOCIATED 136500120 MCKNIGHT
ASSOCIATED 122850108 BLACKWOOD
STATE 40950036 JONES
BEST BANK 160633 BANNING
GREENSPAN
MCCOY
ROMANS
SMITH
STEVENS
The IN phrase can be used with ACROSS to specify both the starting column of the entire ACROSS set as well as the spacing between each column within the ACROSS, as shown in the following example:
TABLE FILE CAR SUM UNITS IN +1 ACROSS CAR IN 30 BY COUNTRY END
This places one extra space between the data columns in the matrix, and displays the ACROSS sets beginning in Position 30, as shown in the partial first page of the report below.
CAR
ALFA ROMEO AUDI BMW
COUNTRY
-----------------------------------------------------------------------------
ENGLAND . . .
FRANCE . . .
ITALY 30200 . .
JAPAN . . .
W GERMANY . 7800 80390
When one field is positioned over another (for example, when OVER or FOLD-LINE is used; see Reducing a Report's Width: FOLD-LINE and OVER), the positions apply to the line on which the referenced field occurs, as in the following example:
TABLE FILE CAR SUM RCOST BY CAR BY COUNTRY IN 25 ON COUNTRY FOLD-LINE END
which creates this report, in which COUNTRY starts in column 25 and RCOST appears on the second line.
CAR COUNTRY
--- -------
RETAIL_COST
-----------
ALFA ROMEO ITALY
19,565
AUDI W GERMANY
5,970
BMW W GERMANY
58,762
DATSUN JAPAN
3,139
JAGUAR ENGLAND
22,369
JENSEN ENGLAND
17,850
MASERATI ITALY
31,500
PEUGEOT FRANCE
5,610
The following report request stacks the SALES field over the RETAIL_COST field:
TABLE FILE CAR PRINT SALES IN 50 OVER RCOST IN 50 BY COUNTRY IN 10 BY MODEL END
The output is:
COUNTRY MODEL
------- -----
ENGLAND INTERCEPTOR III SALES 0
RETAIL_COST 17,850
TR7 SALES 0
RETAIL_COST 5,100
V12XKE AUTO SALES 0
RETAIL_COST 8,878
XJ12L AUTO SALES 12000
RETAIL_COST 13,491
FRANCE 504 4 DOOR SALES 0
RETAIL_COST 5,610
ITALY DORA 2 DOOR SALES 0
RETAIL_COST 31,500
2000 GT VELOCE SALES 12400
RETAIL_COST 6,820
2000 SPIDER VELOCE SALES 13000
RETAIL_COST 6,820
2000 4 DOOR BERLINA SALES 4800
| Information Builders |