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
MIS PRODUCTION
LAST_NAME FIRST_NAME
-----------------------------------------------------
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 |