Including Lines Based on Strings

Because annual salary is of interest in the report, you should INCLUDE only those employees that have a salary of $36,000 or more.

1. Press PF03/PF15 to exit the EDIT Option. The Report Editing screen is displayed.
2. Position the cursor in the COMMAND field, type 2 and press Enter. The Include Lines Based on Strings screen is displayed.
3. Position the cursor in the first field on the first STR line.
   1. Type .GE.36,000 and press Tab.

      Note: .GE. stands for greater than or equal to. You can see all other logical comparison operators by using the HELP facility (press PF01/PF13).

   2. In the first COL field, type 036 and press Tab.
   3. In the - field, type 041.

   Figure 35 Include Lines Based on Strings Screen

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

   COMMAND ===>                                                  Apply on header  N

      

   STR .GE.36,000                       COL 036 - 041 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

   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

   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

   PLEASE FILL IN THE  SELECTION STRINGS                                   15.31.54

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

4. Press PF04/PF16 to review the results of the "include" in the report.
5. Press PF04/PF16 to return to the Report Editing screen.