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.
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
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 ----------- ---------------- ----- ---- ------- ------- ----
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
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.
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
Parent Topic |