How to: |
Most SET commands that change system defaults may be issued from within a report request. Many SET command parameters can be used to enhance the readability and usefulness of your reports. The SET command, when used in this manner, affects only the request in which it occurs. For a complete list of SET parameters and acceptable values, see the Developing Applications manual.
The syntax is:
ON TABLE SET parameter value [AND parameter value...]
where:
Is the SET command parameter that you wish to change.
Replaces the default value.
This request changes the NODATA character for missing data from a period (default) to the word NONE. No equal sign is allowed.
TABLE FILE EMPLOYEE PRINT CURR_SAL BY LAST_NAME BY FIRST_NAME ACROSS DEPARTMENT ON TABLE SET NODATA NONE END
This request produces the following report:
DEPARTMENT LAST_NAME FIRST_NAME MIS PRODUCTION ------------------------------------------------------- BANNING JOHN NONE $29,700.00 BLACKWOOD ROSEMARIE $21,780.00 NONE CROSS BARBARA $27,062.00 NONE GREENSPAN MARY $9,000.00 NONE IRVING JOAN NONE $26,862.00 JONES DIANE $18,480.00 NONE MCCOY JOHN $18,480.00 NONE MCKNIGHT ROGER NONE $16,100.00 ROMANS ANTHONY NONE $21,120.00 SMITH MARY $13,200.00 NONE RICHARD NONE $9,500.00 STEVENS ALFRED NONE $11,000.00
Information Builders |