Defining Color and Defining Multiple Strings in the Include Screen

Each Include definition line contains fields that can be used to specify colors and highlights for included report lines. Specified colors and highlights are applied to the entire report line. Available color and highlight codes are the same as in the Color Lines Based on Strings screen and the Edit Report Columns screen.

You can now modify ruler OFN08 so that it contains multiple Include criteria and specifies color characteristics for included lines.

1. Press the QUICKVIEW key (PF04/PF16) to display the Report Editing screen.

   The RULER NAME field contains OFN08.

2. Type 2 (the Include lines based on option) in the COMMAND field and press Enter.

   The Include Lines Based on Strings screen, with the edits from ruler OFN08, is displayed.

   Figure 52 Include Lines Screen with Ruler OFN98

   ----------------  CONTROL-D - INCLUDE LINES BASED ON STRINGS  ----------(U.E.2)

   COMMAND ===>                                                  Apply on header  N

      

   STR 08                               COL 030 - 031 LINE     -     COLOR   HL

   STR                                  COL     -     LINE     -     COLOR   HL

   STR                                  COL     -     LINE     -     COLOR   HL

   STR                                  COL     -     LINE     -     COLOR   HL

   STR                                  COL     -     LINE     -     COLOR   HL

   STR                                  COL     -     LINE     -     COLOR   HL

   STR                                  COL     -     LINE     -     COLOR   HL

   STR                                  COL     -     LINE     -     COLOR   HL

   You can now change the Include criteria so that instead of including employees from Office 08, they include only those employees with a salary of 40,000 or more as follows:

   • Employees with a salary of 50,000 or more are to be displayed in red.
   • Employees with a salary from 40,000 to 49,999 are to be displayed in blue.

   Note: You should perform this exercise even if you are not working on a color monitor.

3. Typing over the 08 string entry, define your Include ruler to contain the string, column range and color definitions shown in the figure below:

   Figure 53 Redefining Ruler OFN98

   ----------------  CONTROL-D - INCLUDE LINES BASED ON STRINGS  ----------(U.E.2)

   COMMAND ===>                                                  Apply on header N

      

   STR .GE.50,000                       COL 036 - 041 LINE     -     COLOR R HL

   STR .GE.40,000                       COL 036 - 041 LINE     -     COLOR B HL

   STR                                  COL     -     LINE     -     COLOR   HL

   STR                                  COL     -     LINE     -     COLOR   HL

   STR                                  COL     -     LINE     -     COLOR   HL

   STR                                  COL     -     LINE     -     COLOR   HL

   STR                                  COL     -     LINE     -     COLOR   HL

   STR                                  COL     -     LINE     -     COLOR   HL

   Strings are checked using the following rules:

   • When multiple Include strings are specified, checking for strings in each record begins with the first Include definition in the Include screen and continues either until a match is found (and the record is included in the report) or until the last Include definition has been checked.
   • The order of Include string definitions may be significant.

   A record that matches several Include definitions is displayed with the color and highlight specified in the first matching Include definition.

   In the above example, a record with an annual salary of 50,000 or more is included in red before it gets a chance to be included in blue. If the order of the string entries had been reversed (that is, the .GE.40,000 definition had been placed before the .GE.50,000 definition), then records with a salary of 50,000 or more would have been included in blue.

4. Press the QUICKVIEW key (PF04/PF16) to check the results of the edit.

   The report looks as follows:

   Figure 54 Report Viewing Screen after Editing Ruler OFN98

   ------------- 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 OFN08

   ----+----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

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

     66126    D. HENRICH        02    70,000   XXX-YY-ZZZZ      5

     66127    S. LUGAR          28    42,000   XXX-YY-ZZZZ      4

     66132    L. LEVY           01    41,000   XXX-YY-ZZZZ      2

     66144    G. LYONS          28    45,000   XXX-YY-ZZZZ      2

     66154    S. LUTES          25    42,000   XXX-YY-ZZZZ      2

     66155    M. GOLIGER        08    50,000   XXX-YY-ZZZZ      2

     66156    L. WOHL           18    41,000   XXX-YY-ZZZZ      2

   ======= >>>>>>>>>>>>>> END OF SCROLLABLE DATA IN PAGE <<<<<<<<<<<<<<<<<<< =====

Records showing a salary of 50,000 or more appear in red. Other records (from 40,000) appear in blue.