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:
The syntax for changing default titles is:
field AS 'title1,title2,...'
where:
Can be a sort field, display field, column total, or row total.
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.
PRINT UNITS BY MONTH AS ' MONTH'
shifts the title for MONTH to the right and all other columns, in this case UNITS, shift to the right. For more information on changing the column position, see Reducing a Report's Width: FOLD-LINE and OVER.
PRINT LAST_NAME AS ''
To display underscores, enclose blanks in single quotation marks.
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 |