Customizing Reports With SET Parameters

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.


Top of page

x
Syntax: How to Use SET Parameters in Requests

The syntax is:

ON TABLE SET parameter value [AND parameter value...]

where:

parameter

Is the SET command parameter that you wish to change.

value

Replaces the default value.



Example: Setting Parameters in a Report Request

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