Positioning Columns: IN

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.


Top of page

x
Syntax: How to Position Columns
 
field IN {n|+n}

Valid values are:

field

Is the field (that is, the column) that you want to move.

n

Is a number indicating the absolute position of the column.

+n

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.


Top of page

x
Reference: Usage Notes for Positioning Columns


Example: Positioning Columns

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  


Example: Positioning Columns With ACROSS

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        


Example: Positioning Columns With FOLD-LINE

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                     


Example: Positioning Columns With OVER

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