Using the Exclude Lines Based on Strings Screen

To see report information for only those items that are on order, the report may be edited using either the Include screen or the Exclude screen. In this exercise, you will use the Exclude Lines Based on Strings screen.

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

   Figure 89 Report Editing Screen before Editing

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

   COMMAND/OPT ===>  

   USER DEMO          REPORT INVENTORY REPORT            JOB JDEMO

     RULER NAME   ===>                      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. Choose Option 1 and press Enter to display the Edit Report Lines and Columns screen.
3. Fill in Hs next to the header lines (as shown below).

   Figure 90 Fixing Header Lines

   -----------------  CONTROL-D - EDIT REPORT LINES AND COLUMNS  ----------(U.E.1)

   COMMAND ===>                                         SP CHAR    SCROLL===> CRSR

   USR DEMO     REP INVENTORY REPORT     JB JDEMO    RULER DEFAULT   TYPE VIEW

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

   H 1DATE:   05.05.00

   H  UPDATE: 05.05.00

   H                                   INVENTORY REPORT

   H                                   ----------------

   H

   H  WAREHOUSE NO: 1001       DEPARTMENT:  100  -  FINAL ASSEMBLY SHOP

   H                ----                    ---------------------------

   H

   H                                     SHELF   QNTY   QNTY       QNTY       QNTY

   H  ITEM NO.      DESCRIPTION          LIFE    UNIT   AVAIL      ORDER      PROC

   H  -----------   ----------------     -----   ----   -------    -------    ----

4. Press the END key (PF03/PF15) to exit the Edit Report Lines and Columns screen and display the Report Editing screen.

   Figure 91 Report Editing Screen

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

   COMMAND/OPT ===> 3

   USER DEMO          REPORT INVENTORY REPORT            JOB JDEMO

     RULER NAME  ===>                      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

5. Choose Option 3 (the EXCLUDE option) and press Enter to display the Exclude Lines Based on Strings screen.

   Figure 92 Exclude Lines Based on Strings Screen

   ----------------  CONTROL-D - EXCLUDE LINES BASED ON STRINGS  ----------(U.E.3)

   COMMAND ===>                                                  Apply on header N

     

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

   PLEASE FILL IN THE  SELECTION STRINGS                                   08.20.09

   The Exclude Lines Based on Strings screen excludes from a report those records that meet any of the string selection criteria.

   This screen is similar to the Include Lines Based on Strings screen except that it does not contain fields for color and highlights. These fields are unnecessary in the Exclude screen because records meeting string selection criteria do not appear in the report.

6. You will now edit the report to exclude all records showing no items on order in the Quantity on Order field (a blank in column 69). A completely blank string is indicated by enclosing the blanks within apostrophes (for example, '  ').

   Fill in the first string line of the Exclude screen as shown below.

   Figure 93 Completing the Exclude Screen

   ----------------  CONTROL-D - EXCLUDE LINES BASED ON STRINGS  ----------(U.E.3)

   COMMAND ===>                                                  Apply on header  N

     

   STR  '  '                            COL 069 - 069 LINE     -

   STR                                  COL     -     LINE     -

   STR                                  COL     -     LINE     -

     

            .                    .                         .

     

   PLEASE FILL IN THE  SELECTION STRINGS                                   08.20.09