Creating New Column Titles: AS

How to:

Reference:

Use the AS option to rename existing column titles in your reports. Any of the following titles can be changed with an AS phrase:


Top of page

x
Syntax: How to Create Column Titles

The syntax for changing default titles is:

field AS 'title1,title2,...'

where:

field

Can be a sort field, display field, column total, or row total.

title

Is the new column title enclosed in single quotation marks.

To specify multiple lines in a column title, separate each line's text with commas. Up to five lines are allowed.


Top of page

x
Reference: Usage Notes for New Column Titles


Example: Creating New Column Titles

The following example assigns new column titles for the LAST_NAME, FIRST_NAME, and EMP_ID fields:

TABLE FILE EMPLOYEE
PRINT FIRST_NAME AS 'NAME' AND LAST_NAME AS ''
BY DEPARTMENT
BY EMP_ID AS 'EMPLOYEE,NUMBER'
END

This request produces the following report:

            EMPLOYEE                        
DEPARTMENT  NUMBER     NAME                 
----------  --------   ----                 
MIS         112847612  MARY        SMITH    
            117593129  DIANE       JONES    
            219984371  JOHN        MCCOY    
            326179357  ROSEMARIE   BLACKWOOD
            543729165  MARY        GREENSPAN
            818692173  BARBARA     CROSS    
PRODUCTION  071382660  ALFRED      STEVENS  
            119265415  RICHARD     SMITH    
            119329144  JOHN        BANNING  
            123764317  JOAN        IRVING   
            126724188  ANTHONY     ROMANS   
            451123478  ROGER       MCKNIGHT 

Information Builders