Using Rulers for Record Inclusion

In this exercise you will design a report with rulers that contains only the records of those employees from Office Number 08 (that is, with a value of 08 in the OFFICE NO. field).

1. First, use the Column Numbering line in the Report Viewing screen to determine the column numbers of the OFFICE NO. field.

   Office numbers appear in columns 30 and 31.

   Figure 45 Determining OFFICE NO. Column Numbers

   ------------- CONTROL-D/V REPORT VIEWING   NOTES    0   PAGE      1 OF        3

   COMMAND ===>                                                   SCROLL ===> CRSR

   USR DEMO     REP EMPLOYEES-MARKETING  JB JDEMO    04544 DT 050500 RUL COLOR40

   ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8

   1            E M P L O Y E E S     R E P O R T    -----    FOR MARKETING   DEPAR

   EMPLOYEE     EMPLOYEE     OFFICE  ANNUAL  SOCIAL        NO. OF      JOB CLASS

       NO.         NAME         NO.    SAL    SECURITY NO.  DEPENDENTS    CODE

   --------  --------------  ------  ------  ------------  ----------  ---------

     66002    A. HABER          07    31,000   XXX-YY-ZZZZ      2

2. Press the QUICKVIEW key (PF04/PF16).

   The Report Editing screen is displayed.

   Figure 46 Selecting a Ruler for Editing

   ------------------------  CONTROL-D - REPORT EDITING  --------------------(U.E)

   COMMAND/OPT ===>

   USER DEMO          REPORT EMPLOYEES-MARKETING         JOB JDEMO

      

      

      RULER NAME  ===> COLOR40              Name or blank for default ruler

      RULER TYPE  ===> VIEW                 View or Print

      REPORT NAME ===>                      To copy a ruler - full report name

      JOB NAME    ===>                      To copy a ruler - full job name

      USER NAME   ===>                      To copy a ruler - full user name

      

      

      1   EDIT    report lines and columns

      

      2   INCLUDE lines based on strings

      

      3   EXCLUDE lines based on strings

      

      4   COLOR   lines based on strings

      

      

      

      

   PLEASE SELECT OPTION, OR PRESS PF3 TO SAVE/EXIT THE RULER              16.46.36