Advanced Report Editing (Ruler Capabilities)
This chapter includes the following topics:
Introduction
In Basic Report Viewing and Editing (Using Rulers), you were introduced to the use of rulers in online viewing. This chapter demonstrates additional ruler capabilities. In this chapter you will:
-
Observe the advantages provided by column reformatting.
-
Use the Edit Report Columns screen to reformat report columns by defining a "cut and paste" operation.
-
Use the Edit Report Lines and Columns screen to make your report easier to read by adding Overlay lines.
-
Use the Exclude screen to exclude undesired records from your report.
-
Learn to use the Apply on Header field in certain editing screens.
-
Use the Color Lines Based on Strings screen to specify color and highlight attributes for the report.
-
Use the Edit Report Lines and Columns screen to define Dynamic Extraction parameters that copy information from one location to another within your report.
-
Delete unnecessary report lines.
-
Define a Print ruler to reformat a report for printing.
-
Learn to use Global rulers.
-
Learn to use SHOWCC and SHOWPAGE commands.
Begin
-
Re-enter the Online Viewing facility and learn more about editing reports.
-
-
Type DEMO in the USER field and press Enter.
The Active User Report List screen is displayed.
Figure 67 Active User Report List Screen (Unedited)
CopyACTIVE LIST <D> JOB REP USR DEMO (U)
COMMAND ===> SCROLL===> CRSR
O USER REPORT ODATE PAGES LINES V N STATUS
DEMO EMPLOYEES-MANAGMENT 05/05/00 1 18 Decollated
DEMO EMPLOYEES-MARKETING 05/05/00 3 131 Decollated
DEMO EMPLOYEES-DEVELOPMEN 05/05/00 1 10 Decollated
DEMO EMPLOYEES-PRODUCTION 05/05/00 3 169 Decollated
DEMO BANKING REPORT 05/05/00 5 256 Decollated
====== >>>>>>>>>>>>>>> B O T T O M O F L I S T <<<<<<<<<<<<<<< ======
P PRINT V VIEW U UPDATE I INSERT A ADD INFO E EDIT
X INDEX N NOTE G GIVETO D DELETE Q QUICK ACCESS 10.24.32 -
Type V (View) in the OPTION field of the EMPLOYEES-MARKETING report, and press Enter.
The Report Viewing screen is displayed.
Figure 68 Report Viewing Screen Before Editing
Copy------------- CONTROL-D/V REPORT VIEWING NOTES 1 PAGE 1 OF 3
COMMAND ===> SCROLL ===> CRSR
USR DEMO REP EMPLOYEES-MARKETING JB JDEMO 04544 DT 050500 RUL DEFAULT
----+----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
66019 K. HARARI 16 35,500 XXX-YY-ZZZZ 3
66043 K. TURRO 02 29,000 XXX-YY-ZZZZ 1
66045 W. MAY 04 35,000 XXX-YY-ZZZZ 4
66047 A. FELSEN 08 27,500 XXX-YY-ZZZZ 2
66050 T. HUBERTY 08 27,500 XXX-YY-ZZZZ 2
66052 K. WOOD 08 26,000 XXX-YY-ZZZZ 2
66056 H. RUNDLE 08 26,000 XXX-YY-ZZZZ 2
66059 L. WEST 26 38,000 XXX-YY-ZZZZ 2
66078 N. LAMBERT 18 29,000 XXX-YY-ZZZZ 3
66093 J. SHARPTON 09 29,000 XXX-YY-ZZZZ 3
66112 K. BENNETT 04 29,000 XXX-YY-ZZZZ 3
66113 T. OGURA 03 28,000 XXX-YY-ZZZZ 4
66114 S. MCCLURE 02 37,500 XXX-YY-ZZZZ 2
66115 N. TRACEY 08 23,000 XXX-YY-ZZZZ 1
CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n 08.16.47The report is displayed using the DEFAULT ruler. When a report is requested for viewing, the report is displayed with its DEFAULT ruler if one has been defined.
Reformatting Report Columns
In Basic Report Viewing and Editing (Using Rulers), you used the Edit Report Columns screen to freeze columns in place so that they did not shift off the screen when you pressed the RIGHT or LEFT key.
In this chapter, you will see how to use the Edit Report Columns screen to reformat the report layout and hide fields that you do not want to see.
Cutting and Pasting
Assume that you want to see only the following fields, in the following order:
|
EMPLOYEE NO. |
EMPLOYEE NAME |
INSURANCE |
OFFICE NO. |
SOCIAL SECURITY NO. |
The Edit Report Columns screen can be used to create a ruler that reformats the report in this way.
Begin
-
Press the QUICKVIEW key (PF04/PF16) to display the Report Editing screen.
-
Choose Option 1 (Edit Report Lines and Columns) and press Enter to display the Edit Report Lines and Columns screen.
-
As with column freezing, column reformatting requires that a model line be selected by typing C (Column) in the OPTION field.
Type C in the Header line as shown in the figure below, and press Enter.
Figure 69 Selected Fields in the Edit Report Lines and Columns Screen
Copy----------------- CONTROL-D - EDIT REPORT LINES AND COLUMNS ----------(U.E.1)
COMMAND ===> SP CHAR SCROLL===> CRSR
USR DEMO REP EMPLOYEES-MARKETING JB JDEMO RULER DEFAULT TYPE VIEW
O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+--
H 1 E M P L O Y E E S R E P O R T ----- FOR MARKETING DE
C EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLAS
H NO. NAME NO. SAL SECURITY NO. DEPENDENTS CODE
H -------- -------------- ------ ------ ------------ ---------- --------
66002 A. HABER 07 31,000 XXX-YY-ZZZZ 2The Edit Report Columns screen is displayed.
Figure 70 Edit Report Columns Screen (Previously Frozen)
Copy------------------- CONTROL-D - EDIT REPORT COLUMNS ----------------(U.E.1.C)
COMMAND ===> LINES 002 - L01
USR DEMO REP EMPLOYEES-MARKETING JB JDEMO RULER DEFAULT TYPE VIEW
THE ORIGINAL LINE
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----
EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLASS
Use the following 5 lines to Cut & Paste, Color and Freeze columns
CUT :
PASTE :
COLOR :
HILITE:
FREEZE:
FFFFFFFFFFFFFFFFFFFFFFFFFFF
THE RESULTING LINE
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----
EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLASS
TO SHIFT, PLACE CRSR ON THE DESIRED LINE AND USE PF10-LEFT, PF11-RIGHT 16.47.13The freeze edits that you specified in Basic Report Viewing and Editing (Using Rulers) are shown. The line range displayed is 002 – L01. Line 001 is not within the displayed range because you specified different freeze edits for line 001. Because you do not want your reformatting edits to be applied to the first line, you will not change this line range.
Column reformatting is done by means of a "cut and paste" operation performed in the CUT and PASTE lines. The results may be seen under "The Resulting Line."
The first two fields in the ruler (Employee No. and Employee Name) were frozen by the Freezing Columns exercise in Basic Report Viewing and Editing (Using Rulers). They can be left frozen, or you can "unfreeze" them by erasing the Fs in the Freeze line. In either case, you must include these fields in the cut and paste if you want them to appear in the reformatted report.
-
You can now perform the cut and paste.
When moving the cursor along the Cut and the Paste lines, you must use the SPACEBAR, not the RIGHT ARROW key.
Defining the Cut
A column range is cut by marking it under the Cut line as follows:
Begin
-
Enter any alphabetic or numeric character (except E) in the first column of the range, to serve as an identifier of the beginning point of a range.
Do not use the same identifier to indicate the beginning of more than one range.
-
Use the E character to mark the end of each range by entering the letter E (END) in the last column of the range.
-
When Enter is pressed after the cut line has been marked, the blank spaces within column ranges are automatically filled with dashes, for easy reading.
-
Press NEWLINE to bring the cursor to the CUT line.
-
Type in beginning and ending identifiers as indicated in the figure below.
Remember to use the SPACEBAR and not the RIGHT ARROW key to move the cursor in the cut line.
Figure 71 Editing: Defining the Cut
CopyTHE ORIGINAL LINE
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----
EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLASS
Use the following 5 lines to Cut & Paste, Color and Freeze columns
CUT :
A EB EC E D E
PASTE : -
Press Enter.
Spaces between begin and end identifiers of fields are filled with dashes.
Figure 72 Editing: Spaces Filled with Dashes
CopyTHE ORIGINAL LINE
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----
EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLASS
Use the following 5 lines to Cut & Paste, Color and Freeze columns
CUT :
A-----------EB-----------EC------E D----------E
PASTE : -
Return the cursor to the beginning of the Cut line and press the RIGHT key (PF11/PF23).
The screen shifts to the right.
-
Use the SPACEBAR to move the cursor, and fill in the beginning and ending identifiers under the INSURANCE field.
Figure 73 Inserting Begin and End Identifiers
CopyTHE ORIGINAL LINE
8----+----9----+----10---+----11---+----12---+----13---+----14---+----15---+---
UNION INSURANCE SICK VAC
Use the following 5 lines to Cut & Paste, Color and Freeze columns
CUT :
F E
PASTE : -
Press Enter.
Spaces between the beginning and ending INSURANCE identifiers are filled with dashes.
Figure 74 Begin and End Identifiers: Spaces Filled with Dashes
CopyTHE ORIGINAL LINE
8----+----9----+----10---+----11---+----12---+----13---+----14---+----15---+---
UNION INSURANCE SICK VAC
Use the following 5 lines to Cut & Paste, Color and Freeze columns
CUT :
F---------E
PASTE : - Press the LEFT key (PF10/PF22) twice to shift the screen display left, to its original position.
Defining the Paste
A column range is pasted by typing its identifier in the PASTE line column where you want the column range to begin.
Begin
-
Set the cursor in the first column of the PASTE line.
-
Using the SPACEBAR, type in the identifiers as labeled below.
Figure 75 Pasting a Column Range
CopyTHE ORIGINAL LINE
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----
EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLASS
Use the following 5 lines to Cut & Paste, Color and Freeze columns
CUT :
A-----------EB-----------EC------E D----------E
PASTE :
A B F C D -
Press Enter
The changes you made appear in THE RESULTING LINE, as shown below.
Figure 76 After Pasting a Column Range
CopyTHE RESULTING LINE
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----
EMPLOYEE EMPLOYEE INSURANCE OFFICE SOCIALNote the following about the paste you just performed:
-
The INSURANCE field is placed before the OFFICE field.
-
The positioning of the identifiers provides for blank spaces between fields.
-
-
Press the QUICKVIEW key (PF04/PF16) to display the Report Viewing screen.
Figure 77 Report Viewing Screen after Cut and Paste
Copy------------- CONTROL-D/V REPORT VIEWING NOTES 1 PAGE 1 OF 3
COMMAND ===> SCROLL ===> CRSR
USR DEMO REP EMPLOYEES-MARKETING JB JDEMO 04544 DT 050500 RUL DEFAULT
----+----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 INSURANCE OFFICE SOCIAL
NO. NAME NO. SECURITY NO.
-------- -------------- --------- ------ ------------
66002 A. HABER 212.00 07 XXX-YY-ZZZZ
66019 K. HARARI 068.00 16 XXX-YY-ZZZZ
66043 K. TURRO 112.00 02 XXX-YY-ZZZZ
66045 W. MAY 114.00 04 XXX-YY-ZZZZ
66047 A. FELSEN 222.00 08 XXX-YY-ZZZZ
66050 T. HUBERTY 222.00 08 XXX-YY-ZZZZ
66052 K. WOOD 292.00 08 XXX-YY-ZZZZ
66056 H. RUNDLE 219.00 08 XXX-YY-ZZZZ
66059 L. WEST 222.00 26 XXX-YY-ZZZZ
66078 N. LAMBERT 200.00 18 XXX-YY-ZZZZ
66093 J. SHARPTON 222.00 09 XXX-YY-ZZZZ
66112 K. BENNETT 120.00 04 XXX-YY-ZZZZ
66113 T. OGURA 220.00 03 XXX-YY-ZZZZ
66114 S. MCCLURE 220.00 02 XXX-YY-ZZZZ
66115 N. TRACEY 120.00 08 XXX-YY-ZZZZ
CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n 08.16.47The fields are now arranged in the desired order, and the report is now narrow enough so that you no longer need to shift to the right or left to see all the required data. By not applying your edits to line 001, you have enabled the report title to appear in its original format.
Inserting Overlay Lines
You can make the report easier to read by inserting a blank line after every five records in the report.
Begin
-
Press the QUICKVIEW key (PF04/PF16) to display the Edit Report Columns.
-
Press the END key (PF03/PF15) to display the Edit Report Lines and Columns screen.
Figure 78 Edit Report LInes and Columns Screen (Unedited)
Copy----------------- CONTROL-D - EDIT REPORT LINES AND COLUMNS ----------(U.E.1)
COMMAND ===> SP CHAR SCROLL===> CRSR
USR DEMO REP EMPLOYEES-MARKETING JB JDEMO RULER DEFAULT TYPE VIEW
O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+--
H 1 E M P L O Y E E S R E P O R T ----- FOR MARKETING DE
H EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLAS
H NO. NAME NO. SAL SECURITY NO. DEPENDENTS CODE
H -------- -------------- ------ ------ ------------ ---------- --------
66002 A. HABER 07 31,000 XXX-YY-ZZZZ 2
66019 K. HARARI 16 35,500 XXX-YY-ZZZZ 3
66043 K. TURRO 02 29,000 XXX-YY-ZZZZ 1
66045 W. MAY 04 35,000 XXX-YY-ZZZZ 4
66047 A. FELSEN 08 27,500 XXX-YY-ZZZZ 2
66050 T. HUBERTY 08 27,500 XXX-YY-ZZZZ 2
66052 K. WOOD 08 26,000 XXX-YY-ZZZZ 2
66056 H. RUNDLE 08 26,000 XXX-YY-ZZZZ 2
66059 L. WEST 26 38,000 XXX-YY-ZZZZ 2
66078 N. LAMBERT 18 29,000 XXX-YY-ZZZZ 3
66093 J. SHARPTON 09 29,000 XXX-YY-ZZZZ 3
66112 K. BENNETT 04 29,000 XXX-YY-ZZZZ 3
66113 T. OGURA 03 28,000 XXX-YY-ZZZZ 4
66114 S. MCCLURE 02 37,500 XXX-YY-ZZZZ 2
66115 N. TRACEY 08 23,000 XXX-YY-ZZZZ 1
OPTIONS: H HEADER F FOOTER D DELETE C COLUMNS I INSERT B BEFORE 16.46.56Insertion of lines in your report is performed from the Edit Report Lines and Columns screen. Specifying I (Insert) in the OPTION field of a report line adds a blank line just below that report line. This blank line is called an Overlay line, and has an identifying character O in the OPTION field.
The Edit Report Lines and Columns screen contains a copy of one full print-page (the current page) of your report. This page serves as a "model" for all pages in your report. As in the Report Viewing screen, this print page is longer than your screen display (and can be scrolled).
To display a blank line after every five records in your report, you must insert an Overlay line after every five records in the entire report page (not just the current screen display) in the Edit Report Lines and Columns screen.
-
Place an I (Insert) in the OPTION field of every fifth record of Page 1 of the report (Felsen, Lambert, Tracey and so on).
You must use the DOWN key (PF08/PF20) to scroll down each screen in Page 1. You can quickly return to the top of the page by typing M in the COMMAND field and pressing the UP key (PF07/PF19)
Figure 79 Inserting Blank Lines
Copy----------------- CONTROL-D - EDIT REPORT LINES AND COLUMNS ----------(U.E.1)
COMMAND ===> SP CHAR SCROLL===> CRSR
USR DEMO REP EMPLOYEES-MARKETING JB JDEMO RULER DEFAULT TYPE VIEW
O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+--
H 1 E M P L O Y E E S R E P O R T ----- FOR MARKETING DE
H EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLAS
H NO. NAME NO. SAL SECURITY NO. DEPENDENTS CODE
H -------- -------------- ------ ------ ------------ ---------- --------
66002 A. HABER 07 31,000 XXX-YY-ZZZZ 2
66019 K. HARARI 16 35,500 XXX-YY-ZZZZ 3
66043 K. TURRO 02 29,000 XXX-YY-ZZZZ 1
66045 W. MAY 04 35,000 XXX-YY-ZZZZ 4
I 66047 A. FELSEN 08 27,500 XXX-YY-ZZZZ 2
66050 T. HUBERTY 08 27,500 XXX-YY-ZZZZ 2
66052 K. WOOD 08 26,000 XXX-YY-ZZZZ 2
66056 H. RUNDLE 08 26,000 XXX-YY-ZZZZ 2
66059 L. WEST 26 38,000 XXX-YY-ZZZZ 2
I 66078 N. LAMBERT 18 29,000 XXX-YY-ZZZZ 3
66093 J. SHARPTON 09 29,000 XXX-YY-ZZZZ 3
66112 K. BENNETT 04 29,000 XXX-YY-ZZZZ 3
66113 T. OGURA 03 28,000 XXX-YY-ZZZZ 4
66114 S. MCCLURE 02 37,500 XXX-YY-ZZZZ 2
I 66115 N. TRACEY 08 23,000 XXX-YY-ZZZZ 1
OPTIONS: H HEADER F FOOTER D DELETE C COLUMNS I INSERT B BEFORE 16.46.56 -
Press Enter to complete insert requests. Overlay lines are inserted after each insert request.
You can press Enter after you type each I or after typing I any number of times. Whenever you press Enter, blank overlay lines, marked O, are inserted below each line previously marked I, and the I markers are removed.
Figure 80 Effect of Inserting Blank Lines
Copy----------------- CONTROL-D - EDIT REPORT LINES AND COLUMNS ----------(U.E.1)
COMMAND ===> SP CHAR SCROLL===> CRSR
USR DEMO REP EMPLOYEES-MARKETING JB JDEMO RULER DEFAULT TYPE VIEW
O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+--
H 1 E M P L O Y E E S R E P O R T ----- FOR MARKETING DE
H EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLAS
H NO. NAME NO. SAL SECURITY NO. DEPENDENTS CODE
H -------- -------------- ------ ------ ------------ ---------- --------
66002 A. HABER 07 31,000 XXX-YY-ZZZZ 2
66019 K. HARARI 16 35,500 XXX-YY-ZZZZ 3
66043 K. TURRO 02 29,000 XXX-YY-ZZZZ 1
66045 W. MAY 04 35,000 XXX-YY-ZZZZ 4
66047 A. FELSEN 08 27,500 XXX-YY-ZZZZ 2
O
66050 T. HUBERTY 08 27,500 XXX-YY-ZZZZ 2
66052 K. WOOD 08 26,000 XXX-YY-ZZZZ 2
66056 H. RUNDLE 08 26,000 XXX-YY-ZZZZ 2
66059 L. WEST 26 38,000 XXX-YY-ZZZZ 2
66078 N. LAMBERT 18 29,000 XXX-YY-ZZZZ 3
O
66093 J. SHARPTON 09 29,000 XXX-YY-ZZZZ 3
66112 K. BENNETT 04 29,000 XXX-YY-ZZZZ 3
66113 T. OGURA 03 28,000 XXX-YY-ZZZZ 4
OPTIONS: H HEADER F FOOTER D DELETE C COLUMNS I INSERT B BEFORE 16.46.56If you make a mistake, you can delete unwanted overlay lines by typing D (Delete) in the OPTION field of the overlay line, and pressing Enter.
Overlay lines can also be inserted in the Edit Lines screen using Option B (Before). Option B inserts an overlay line before the report line, whereas Option I inserts an overlay line after the report line.
-
Press the QUICKVIEW key (PF04/PF16) to display the Report Viewing screen.
The report is reformatted as shown in Figure 81.
Figure 81 Reformatted Report Viewing Screen
Copy------------- CONTROL-D/V REPORT VIEWING NOTES 1 PAGE 1 OF 3
COMMAND ===> SCROLL ===> CRSR
USR DEMO REP EMPLOYEES-MARKETING JB JDEMO 04544 DT 050500 RUL DEFAULT
----+----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 INSURANCE OFFICE SOCIAL
NO. NAME NO. SECURITY NO.
-------- -------------- --------- ------ ------------
66002 A. HABER 212.00 07 XXX-YY-ZZZZ
66019 K. HARARI 068.00 16 XXX-YY-ZZZZ
66043 K. TURRO 112.00 02 XXX-YY-ZZZZ
66045 W. MAY 114.00 04 XXX-YY-ZZZZ
66047 A. FELSEN 222.00 08 XXX-YY-ZZZZ
66050 T. HUBERTY 222.00 08 XXX-YY-ZZZZ
66052 K. WOOD 292.00 08 XXX-YY-ZZZZ
66056 H. RUNDLE 219.00 08 XXX-YY-ZZZZ
66059 L. WEST 222.00 26 XXX-YY-ZZZZ
66078 N. LAMBERT 200.00 18 XXX-YY-ZZZZ
66093 J. SHARPTON 222.00 09 XXX-YY-ZZZZ
66112 K. BENNETT 120.00 04 XXX-YY-ZZZZ
66113 T. OGURA 220.00 03 XXX-YY-ZZZZ
CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n 08.16.47 -
Type N in the COMMAND field and press Enter to view the next report page.
Page 2 of the report also contains blank lines.
-
Press the DOWN key (PF08/PF20).
Blank lines are displayed as you scroll down the report.
-
Type M (Max) in the COMMAND field and press the UP key (PF07/PF19) to display the top of the report.
Adding Text to Overlay Lines
Text can be typed in overlay lines in the Edit Report Lines and Columns screen. Any text typed in an overlay line appears in the line inserted in the report.
In this exercise you will return to the Edit Report Lines and Columns screen and type dots in the overlay lines so that records are separated by a dotted line instead of a blank line.
Begin
-
Press the QUICKVIEW key (PF04/PF16) to display the Edit Report Lines and Columns screen.
-
Set the cursor in the first column of the overlay line under Felsen's record.
Figure 82 Edit Report Lines and Columns Screen with Blank Lines
Copy66045 W. MAY 04 35,000 XXX-YY-ZZZZ 4
66047 A. FELSEN 08 27,500 XXX-YY-ZZZZ 2
O
66050 T. HUBERTY 08 27,500 XXX-YY-ZZZZ 2
66052 K. WOOD 08 26,000 XXX-YY-ZZZZ 2 -
Use the period character (.) to type dots in the Overlay line from column 1 through column 109 (the length of your report data).
Use the RIGHT key (PF11/PF23) to shift the display right.
Figure 83 Filling Blank Lines in Edit Report Lines and Columns Screen
Copy156.00 114.00 01 06
154.00 222.00 01 07
O ...............................
157.00 222.00 01 07
158.00 292.00 01 07 -
Press the LEFT key (PF10/PF22) twice to shift the display back to its original position.
-
Set the cursor in the first column of the Overlay line under Lambert's record. Fill in the Overlay line with dots (as you did in the first Overlay line).
Figure 84 Repeating Blank Line Filling Operation
Copy66059 L. WEST 26 38,000 XXX-YY-ZZZZ 2
66078 N. LAMBERT 18 29,000 XXX-YY-ZZZZ 3
O
66093 J. SHARPTON 09 29,000 XXX-YY-ZZZZ 3
66112 K. BENNETT 04 29,000 XXX-YY-ZZZZ 3 -
Press the LEFT key (PF10/PF22) twice to shift the display back to its original position.
The screen looks as illustrated in Figure 85.
Figure 85 Effect of Inserting and Filling Blank Lines
Copy----------------- CONTROL-D - EDIT REPORT LINES AND COLUMNS ----------(U.E.1)
COMMAND ===> SP CHAR SCROLL===> CRSR
USR DEMO REP EMPLOYEES-MARKETING JB JDEMO RULER DEFAULT TYPE VIEW
O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+--
H 1 E M P L O Y E E S R E P O R T ----- FOR MARKETING DE
H EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLAS
H NO. NAME NO. SAL SECURITY NO. DEPENDENTS CODE
H -------- -------------- ------ ------ ------------ ---------- --------
66002 A. HABER 07 31,000 XXX-YY-ZZZZ 2
66019 K. HARARI 16 35,500 XXX-YY-ZZZZ 3
66043 K. TURRO 02 29,000 XXX-YY-ZZZZ 1.
66045 W. MAY 04 35,000 XXX-YY-ZZZZ 4
66047 A. FELSEN 08 27,500 XXX-YY-ZZZZ 2
O .............................................................................
66050 T. HUBERTY 08 27,500 XXX-YY-ZZZZ 2
66052 K. WOOD 08 26,000 XXX-YY-ZZZZ 2
66056 H. RUNDLE 08 26,000 XXX-YY-ZZZZ 2
66059 L. WEST 26 38,000 XXX-YY-ZZZZ 2
66078 N. LAMBERT 18 29,000 XXX-YY-ZZZZ 3
O .............................................................................
66093 J. SHARPTON 09 29,000 XXX-YY-ZZZZ 3
66112 K. BENNETT 04 29,000 XXX-YY-ZZZZ 3
66113 T. OGURA 03 28,000 XXX-YY-ZZZZ 4
OPTIONS: H HEADER F FOOTER D DELETE C COLUMNS I INSERT B BEFORE 16.46.56For purposes of this guide, you only filled in two Overlay lines with dots. In normal practice, if you want dotted lines between every five records, you must add dots to all the Overlay lines.
-
Press the QUICKVIEW key (PF04/PF16) to display the Report Viewing screen, where the results of the edits can be seen.
Figure 86 Report Viewing Screen after Editing
Copy------------- CONTROL-D/V REPORT VIEWING NOTES 1 PAGE 1 OF 3
COMMAND ===> SCROLL ===> CRSR
USR DEMO REP EMPLOYEES-MARKETING JB JDEMO 04544 DT 050500 RUL DEFAULT
----+----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 INSURANCE OFFICE SOCIAL
NO. NAME NO. SECURITY NO.
-------- -------------- --------- ------ ------------
66002 A. HABER 212.00 07 XXX-YY-ZZZZ
66019 K. HARARI 068.00 16 XXX-YY-ZZZZ
66043 K. TURRO 112.00 02 XXX-YY-ZZZZ
66045 W. MAY 114.00 04 XXX-YY-ZZZZ
66047 A. FELSEN 222.00 08 XXX-YY-ZZZZ
.........................................................
66050 T. HUBERTY 222.00 08 XXX-YY-ZZZZ
66052 K. WOOD 292.00 08 XXX-YY-ZZZZ
66056 H. RUNDLE 219.00 08 XXX-YY-ZZZZ
66059 L. WEST 222.00 26 XXX-YY-ZZZZ
66078 N. LAMBERT 200.00 18 XXX-YY-ZZZZ
.........................................................
66093 J. SHARPTON 222.00 09 XXX-YY-ZZZZ
66112 K. BENNETT 120.00 04 XXX-YY-ZZZZ
66113 T. OGURA 220.00 03 XXX-YY-ZZZZ
CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n 08.16.47
By typing dots in only the first two overlay lines in the Edit Report Lines and Columns screen, you actually added dots to the sixth line and the eleventh line of any report page. Therefore, the dotted lines will appear whenever you display the first screen of any report page in the Report Viewing screen, presuming the same ruler is applied.
As noted earlier, to display dotted lines in the remaining screens of each report page, you must add dots to the remaining overlay lines in the Edit Report Lines and Columns screen.
Exiting the Ruler
Follow these steps to name the ruler INSUR1 and save it for future use.
Begin
-
Press the QUICKVIEW key (PF04/PF16) to display the Edit Report Lines and Columns screen.
-
Press the END key (PF03/PF15)to display the Report Editing screen.
-
Press the END key (PF03/PF15) again to display the Exit option window.
-
Fill in the Exit option window as shown below and press Enter.
Figure 87 Saving Ruler INSUR1
Copy------------------------ CONTROL-D - REPORT EDITING --------------------(U.E)
COMMAND/OPT ===> +---------------------------------+
USER DEMO REPORT EMPLOYEES-MAR | |
| PLEASE SELECT EXIT OPTION |
| |
RULER NAME ===> DEFAULT | Exit option ===> 3 |
RULER TYPE ===> VIEW | |
REPORT NAME ===> | 1 KEEP ruler active |
JOB NAME ===> | 2 CLEAR (no ruler) |
USER NAME ===> | 3 SAVE ruler as: |
| |
| Ruler name ===> INSUR1 |
1 EDIT report lines and columns | Ruler type ===> VIEW |
| |
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.51.06
The Report Viewing screen is displayed using ruler INSUR1.
Excluding Report Lines
For this exercise, you will switch reports, using the following steps.
-
Press the END key (PF03/PF15) to display the Active User Report list.
-
Type V (View) in the OPTION field of the INVENTORY report and press Enter to display the Inventory report in the Report Viewing screen.
Figure 88 Active User Report List Viewing Screen (Unedited)
Copy------------- CONTROL-D/V REPORT VIEWING NOTES 0 PAGE 1 OF 9
COMMAND ===> SCROLL ===> CRSR
USR DEMO REP INVENTORY REPORT JB JDEMO 04544 DT 050500 RUL
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
1DATE: 05.05.00
UPDATE: 05.05.00
INVENTORY REPORT
----------------
WAREHOUSE NO: 1001 DEPARTMENT: 100 - FINAL ASSEMBLY SHOP
---- ---------------------------
SHELF QNTY QNTY QNTY QNTY IN
ITEM NO. DESCRIPTION LIFE UNIT AVAIL ORDER PROCESS
----------- ---------------- ----- ---- ------- ------- -------
1233-781-21 RIVET D. 0.1 ACR NONE KG 100.00 250.00
1233-781-25 RIVET D. 0.5 ACR NONE KG 500.00 500.00
1233-781-27 RIVET D. 0.7 ACR NONE KG 100.00 100.00
1234-781-21 RIVET D. 0.1 ACP NONE KG 100.00
CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n 11.41.08
Note that one of the Inventory report fields indicates the quantity of stock on order.
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.
Begin
-
Press the QUICKVIEW key (PF04/PF16) to display the Report Editing screen.
Figure 89 Report Editing Screen before Editing
Copy------------------------ 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 -
Choose Option 1 and press Enter to display the Edit Report Lines and Columns screen.
-
Fill in Hs next to the header lines (as shown below).
Figure 90 Fixing Header Lines
Copy----------------- 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 ----------- ---------------- ----- ---- ------- ------- ---- -
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
Copy------------------------ 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 -
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
Copy---------------- 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.09The 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.
-
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
Copy---------------- 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
Apply on Header Field (in the Include and Exclude Screens)
Before checking the results of your edits, look at the Apply on header field.
Figure 94 Apply on Header Field in 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 -
The Apply on header field has a default value of N. This field also appears on the Include screen.
In the Include and the Exclude screens, the Apply on Header field determines whether the specified include and exclude string criteria are applied to the header lines.
-
If you specify Y (Yes) on the Exclude screen, a header line is excluded if it contains even one of the specified Exclude values.
-
If you specify Y (Yes) on the Include screen, a header line is included only if it contains at least one of the specified Include values.
In most cases, you do not want to apply the criteria to a header line. Therefore, the default is N (No).
Begin
-
Press the QUICKVIEW key (PF04/PF16) to display the Report Viewing screen and check the results of the edits.
Figure 95 Report Viewing Screen after Editing
Copy------------- CONTROL-D/V REPORT VIEWING NOTES 0 PAGE 1 OF 9
COMMAND ===> SCROLL ===> CRSR
USR DEMO REP INVENTORY REPORT JB JDEMO 04544 DT 050500 RUL DEFAULT
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
1DATE: 05.05.00
UPDATE: 05.05.00
INVENTORY REPORT
----------------
WAREHOUSE NO: 1001 DEPARTMENT: 100 - FINAL ASSEMBLY SHOP
---- ---------------------------
SHELF QNTY QNTY QNTY QNTY IN
ITEM NO. DESCRIPTION LIFE UNIT AVAIL ORDER PROCESS
----------- ---------------- ----- ---- ------- ------- ------
1233-781-21 RIVET D. 0.1 ACR NONE KG 100.00 250.00
1233-781-25 RIVET D. 0.5 ACR NONE KG 500.00 500.00
1233-781-27 RIVET D. 0.7 ACR NONE KG 100.00 100.00
2200-700-22 RUBBER RING D. 2.2 1 MON EA 10.00 10.00
2200-700-27 RUBBER RING D. 2.7 1 MON EA 15.00 5.00
2201-750-00 MAIN WHEEL 8 MON EA 85.00 15.00
2201-751-00 NOSE WHEEL 8 MON EA 40.00 10.00
2201-800-22 METAL O RING 2.2 NONE EA 20.00 30.00
CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n 11.41.08By eliminating report lines that do not have a value in the Qnty Order field, you have eliminated blank lines as well.
If your ruler contains both Include and Exclude edits, the Include edits are performed first and the Exclude edits are performed afterward. Therefore, records that match both Include and Exclude criteria are excluded from the report.
If you are not using a color monitor, you can skip the next exercise, "Additional Color Screen Edits," and proceed directly to Dynamic Extraction Parameters.
Additional Color Screen Edits
-
If you are working in the Report Viewing screen, press PF04/PF16 to return to the Exclude Lines Based on Strings screen.
-
Press the END key (PF03/PF15) to display the Report Editing screen, in order to return to the Color Lines Based on Strings screen and perform more edits.
Choose Option 4 and press Enter to display the Color Lines Based on Strings screen.
Figure 96 Color Lines Based on Strings Screen
Copy------------------ CONTROL-D - COLOR LINES BASED ON STRINGS ----------(U.E.4)
COMMAND ===> Apply on header N
ON STR COL - LINE -
COLOR HILITE ON: STRING or LINE or COL - LINE -
ON STR COL - LINE -
COLOR HILITE ON: STRING or LINE or COL - LINE -
ON STR COL - LINE -
COLOR HILITE ON: STRING or LINE or COL - LINE -
ON STR COL - LINE -
COLOR HILITE ON: STRING or LINE or COL - LINE -
ON STR COL - LINE -
COLOR HILITE ON: STRING or LINE or COL - LINE -
ON STR COL - LINE -
COLOR HILITE ON: STRING or LINE or COL - LINE -
ON STR COL - LINE -
COLOR HILITE ON: STRING or LINE or COL - LINE -
ON STR COL - LINE -
COLOR HILITE ON: STRING or LINE or COL - LINE -
ON STR COL - LINE -
COLOR HILITE ON: STRING or LINE or COL - LINE -
ON STR COL - LINE -
COLOR HILITE ON: STRING or LINE or COL - LINE -
PLEASE FILL IN THE SELECTION STRINGS 16.52.18In Basic Report Viewing and Editing (Using Rulers), you learned that the Color Lines Based on Strings screen gives you the option of applying colors and highlights to the specified string, to the entire line, or to a "block" (a specified column and line range).
This exercise shows you how to apply the following color characteristics:
-
For all records whose Quantity Available is 15 or less, color the entire line red.
-
Color all other lines yellow.
-
If SHELF LIFE is one month, color the field green.
-
If SHELF LIFE is over one month, color the field blue.
When multiple ON STR criteria apply to a record, colors are applied in the order the definitions appear on the screen (that is, later color characteristics override earlier ones). Therefore, the order in which ON STR criteria are specified is significant.
-
-
Fill in the Color Lines Based on Strings screen as illustrated in the following figure:
Figure 97 Completing the Color Lines Based on Strings Screen
Copy------------------ CONTROL-D - COLOR LINES BASED ON STRINGS ----------(U.E.4)
COMMAND ===> Apply on header N
ON STR .GE.0 COL 002 - 002 LINE -
COLOR Y HILITE ON: STRING or LINE Y or COL - LINE -
ON STR .LE. 15 COL 053 - 055 LINE -
COLOR R HILITE ON: STRING or LINE Y or COL - LINE -
ON STR .NE.N COL 037 - 037 LINE -
COLOR B HILITE ON: STRING or LINE or COL 037 - 041 LINE -
ON STR 1 COL 037 - 037 LINE -
COLOR G HILITE ON: STRING or LINE or COL 037 - 041 LINE -
ON STR COL - LINE -
These settings produce the following colors:
-
First, all lines are colored yellow. Since every item has a numeric ITEM NO., yellow is requested by searching for any numeric digit in column 2 – the first ITEM NO. column.
-
Next, the color of a line is changed to red where appropriate.
An embedded space in .LE. 15 ensures that the line is not colored red for values of 100 or more (for example, 115).
-
Next, all SHELF LIFE fields with a value other than N in Col. 37 are colored blue.
-
Finally, SHELF LIFE fields with a value of 1 month (1 in Col. 37 and blank in Col. 38) are colored green.
Apply on Header Field (in the Color Screen)
Before checking the results of these edits, note the Apply on header field, which has a default value of N (No).
Figure 98 Apply on Header Field in the Color Screen
------------------ CONTROL-D - COLOR LINES BASED ON STRINGS ----------(U.E.4)
COMMAND ===> Apply on header N
ON STR .GE.0 COL 002 - 002 LINE -
COLOR Y HILITE ON: STRING or LINE Y or COL - LINE -In the Color Lines Based on Strings screen, this field determines whether to apply the specified color criteria if the string is found in the report Header lines.
You can now check the results of the edits.
Begin
-
Press the QUICKVIEW key (PF04/PF16) to display the report in the Report Viewing screen, so you can check the results of the edit.
Figure 99 Report Viewing Screen after Color Editing
Copy------------- CONTROL-D/V REPORT VIEWING NOTES 0 PAGE 1 OF 9
COMMAND ===> SCROLL ===> CRSR
USR DEMO REP INVENTORY REPORT JB JDEMO 04544 DT 050500 RUL DEFAULT
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
1DATE: 05.05.00
UPDATE: 05.05.00
INVENTORY REPORT
----------------
WAREHOUSE NO: 1001 DEPARTMENT: 100 - FINAL ASSEMBLY SHOP
---- ---------------------------
SHELF QNTY QNTY QNTY QNTY IN
ITEM NO. DESCRIPTION LIFE UNIT AVAIL ORDER PROCESS
----------- ---------------- ----- ---- ------- ------- ------
1233-781-21 RIVET D. 0.1 ACR NONE KG 100.00 250.00
1233-781-25 RIVET D. 0.5 ACR NONE KG 500.00 500.00
1233-781-27 RIVET D. 0.7 ACR NONE KG 100.00 100.00
2200-700-22 RUBBER RING D. 2.2 1 MON EA 10.00 10.00
2200-700-27 RUBBER RING D. 2.7 1 MON EA 15.00 5.00
2201-750-00 MAIN WHEEL 8 MON EA 85.00 15.00
2201-751-00 NOSE WHEEL 8 MON EA 40.00 10.00
2201-800-22 METAL O RING 2.2 NONE EA 20.00 30.00
CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n 11.41.08All report data is colored yellow, except the data indicated above.
Dynamic Extraction Parameters
Headers designed for print reports often do not allow you to view more than a few lines of data online when viewing the report online.
For example, since the headers of the current report occupy eleven lines, only eight lines of data can be displayed in each screen. Condensing information from many Header lines into one line would help solve this problem.
Figure 100 Report Viewing Screen before Condensing Header Lines
------------- CONTROL-D/V REPORT VIEWING NOTES 0 PAGE 1 OF 9
COMMAND ===> SCROLL ===> CRSR
USR DEMO REP INVENTORY REPORT JB JDEMO 04544 DT 050500 RUL DEFAULT
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
1DATE: 03.05.00
UPDATE: 03.05.00
INVENTORY REPORT
----------------
WAREHOUSE NO: 1001 DEPARTMENT: 100 - FINAL ASSEMBLY SHOP
SHELF QNTY QNTY QNTY QNTY IN
ITEM NO. DESCRIPTION LIFE UNIT AVAIL ORDER PROCESS
----------- ---------------- ----- ---- ------- ------- ------
1233-781-21 RIVET D. 0.1 ACR NONE KG 100.00 250.00
1233-781-25 RIVET D. 0.5 ACR NONE KG 500.00 500.00
1233-781-27 RIVET D. 0.7 ACR NONE KG 100.00 100.00
2200-700-22 RUBBER RING D. 2.2 1 MON EA 10.00 10.00
CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n 11.41.08
You have already seen that overlay lines can be used to insert lines of text in the report. If header line information never changes, you can type header information in a single overlay line, as follows:
INVENTORY REPORT - WRHS: 1001 DEPT: 100 DTE: 05.05.00 UPD: 05.05.00You can then delete the unnecessary header lines.
However, header line information is usually dynamic (that is, it does change). For example, the Department number (in the header line) may be 100 on report page 1, and 101 on report page 2. In this case, typing fixed text in an overlay line in the Edit Report Lines and Columns screen is not sufficient.
Special dynamic extraction parameters can be defined in the overlay line to extract variable information from specified report lines. When the overlay lines are inserted into the report display, the extracted information appears in place of the parameters (for example, 100 on page 1 and 101 on page 2).
The following steps will return you to the Edit Report Lines and Columns screen, where you can define dynamic extraction parameters to condense our header line information.
Begin
-
Press the QUICKVIEW key (PF04/PF16) to display the Color Lines Based on Strings screen.
-
Press the END key (PF03/PF15) to display the Report Editing screen.
-
Choose Option 1 and press Enter to display the Edit Report Lines and Columns screen.
Dynamic Extraction parameters require a special identifying character (of your choice) that you specify in the SP CHAR field on the command line of the Edit Report Lines and Columns screen. For this exercise, you will use the % character for the identifying character.
-
Type % in the SP CHAR field and press Enter.
Figure 101 Use of the % Character in SP CHAR Field
Copy----------------- 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
I ---- ---------------------------
H
H SHELF QNTY QNTY QNTY QNTY
H ITEM NO. DESCRIPTION LIFE UNIT AVAIL ORDER PROC
H ----------- ---------------- ----- ---- ------- ------- ----
1233-781-21 RIVET D. 0.1 ACR NONE KG 100.00 250.00 -
Type I (Insert) in the OPTION field of the line containing the warehouse and department number underlines (as shown in below) and press Enter. This will insert an overlay line in which you can define the dynamic extraction parameters.
Figure 102 Inserting a Line for Dynamic Extraction Parameters
Copy----------------- 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
I ---- ---------------------------
H
H SHELF QNTY QNTY QNTY QNTY
H ITEM NO. DESCRIPTION LIFE UNIT AVAIL ORDER PROC
H ----------- ---------------- ----- ---- ------- ------- ----An overlay line is inserted below the line containing the underlines.
Figure 103 Overlay Line Inserted
CopyH WAREHOUSE NO: 1001 DEPARTMENT: 100 - FINAL ASSEMBLY SHOP
H ---- ---------------------------
O
H
H SHELF QNTY QNTY QNTY QNTY
H ITEM NO. DESCRIPTION LIFE UNIT AVAIL ORDER PROC
H ----------- ---------------- ----- ---- ------- ------- ----
Dynamic extraction parameters determine what report data are to be extracted from the report as originally formatted. Column placement of these parameters in the overlay lines determines where the data will appear in the inserted report lines when the report is reformatted.
Basic %L Dynamic Extraction Parameters
The basic dynamic extraction parameter format is
-
%LlnCcn %
where
-
% represents the Special Character symbol specified in the SP CHAR field. This symbol appears at the beginning and end of the parameter.
For this exercise, you are using the % character as the actual Special Character symbol, but it can be a symbol of your choice other than %.
-
Lln specifies the report line from which you want to extract the string. ln represents the line number.
-
Ccn specifies the first column of the string that you want to extract. cn represents the column number.
The ending % symbol may be placed any distance from the rest of the parameter. The number of columns from the beginning % symbol through the ending % symbol of a dynamic extraction parameter defines the number of columns extracted from the header line.
The first character of the extracted information appears in the same column number containing the beginning % symbol in the parameter.
For example, the dynamic extraction parameter format DTE: %L1C10 % resolves as follows:
-
The special character is %.
-
The extract is taken from the 1st report line, beginning with the 10th character.
-
The length of the extract is 8 columns (the column range of the beginning % and ending % is 8).
-
If the value beginning with the 10th character of the 1st report line is 05.05.00, the overlay line inserted in the report displays:
CopyDTE: 05.05.00
-
Dynamic extraction parameters for this exercise can now be defined in the overlay line.
Fill in the overlay line as follows (using the column numbering line as a guide).
Figure 104 Filling the Overlay Line
CopyO ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+-
. . .
H ---- ---------------------------
O INVENTORY REPORT - WRHS: %L6C16% DEPT: %L6C38% DTE: %L1C10 % UPD: %L2C10 %
H
H SHELF QNTY QNTY QNTY QNTYThe dynamic extraction parameters you filled in produce the results described in the following table:
Table 10 Example Dynamic Extraction Parameters
Parameter
Description
%L6C16%
Copies the value beginning on Line 6, Column 16. The copied string is the length of the parameter from the beginning % to the ending % (7 characters).
%L6C38%
Copies the value beginning on Line 6, Column 38. The copied string is 7 characters in length.
%L1C10 %
Copies the value beginning on Line 1, Column 10. The copied string is 8 characters in length.
%L2C10 %
Copies the value beginning on Line 2, Column 10. The copied string is 8 characters in length.
-
Press the QUICKVIEW key (PF04/PF16) to display the Report Viewing screen, including the inserted line.
Figure 105 Report Viewing Screen with Overlay Line
Copy------------- CONTROL-D/V REPORT VIEWING NOTES 0 PAGE 1 OF 9
COMMAND ===> SCROLL ===> CRSR
USR DEMO REP INVENTORY REPORT JB JDEMO 04544 DT 050500 RUL DEFAULT
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
1DATE: 05.05.00
UPDATE: 05.05.00
INVENTORY REPORT
----------------
WAREHOUSE NO: 1001 DEPARTMENT: 100 - FINAL ASSEMBLY SHOP
---- ---------------------------
INVENTORY REPORT - WRHS: 1001 DEPT: 100 DTE: 05.05.00 UPD: 05.05.00
SHELF QNTY QNTY QNTY QNTY IN
ITEM NO. DESCRIPTION LIFE UNIT AVAIL ORDER PROCESS
----------- ---------------- ----- ---- ------- ------- ------
1233-781-21 RIVET D. 0.1 ACR NONE KG 100.00 250.00
1233-781-25 RIVET D. 0.5 ACR NONE KG 500.00 500.00
1233-781-27 RIVET D. 0.7 ACR NONE KG 100.00 100.00
2200-700-22 RUBBER RING D. 2.2 1 MON EA 10.00 10.00
CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n 11.41.08
All the desired header line information has been condensed into one line.
Other Dynamic Extraction Parameters
P1 - Extracting Values from the Current Page
There is another dynamic extraction parameter, with the format
%P1LnCn %.
Unlike %LlnCcn %, which always extracts the value from the current page, this parameter contains the symbol P1, which always extracts the value from the first page.
This parameter is useful when a header field or string only appears on the first page of a report, but you want to see it on every screen on every page.
For example, assume that the DATE field appears only on the first page of a report but you want its value to appear in the overlay line on every page of the report.
The DATE Dynamic Extraction parameter would then be defined as:
%P1L1C10%In this case, the overlay line in the ruler looks as follows (the change is bolded below for clarity).
Figure 106 Overlay Line in the Ruler
O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----O
INVENTORY REPORT - WRHS: %L6C16% DEPT: %L6C38% DTE: %P1L1C10% UPD: %P1L2C10%To use this format, you must enter the ruler Report Editing screen from the first report page in the Report Viewing screen. If you do not enter the ruler from the first page of the report (that is, if you scrolled down to a subsequent report page before editing the ruler), the dynamic extraction parameter will be blank.
Other Dynamic Extraction Parameters
Counting Lines from the Bottom of the Page
Another variation in the two dynamic extraction parameter formats is available. Normally, the line number (Lln) is counted from the top of the page. But if you want to count lines from the bottom of the page, you can format the line number in the parameter as:
LLln (Last Line number)The above parameters would then be formatted as:
%LLlnCcn % and %P1LLlnCcn %where LLln identifies the number of lines from the last line of the page.
Deleting Header Lines
Header line information was condensed by means of dynamic extraction parameters to allow deletion of a large number of header lines.
-
Press the QUICKVIEW key (PF04/PF16) to display the Edit Report Lines and Columns screen, where you can delete the unnecessary Header lines.
Note the D (Delete) option at the bottom of the screen.
-
Type D (Delete) in the Header lines as shown below and then press Enter.
Figure 107 Deleting Unnecessary Header Lines
Copy----------------- 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----+--
D 1DATE: 05.05.00
D UPDATE: 05.05.00
D INVENTORY REPORT
D ----------------
D
D WAREHOUSE NO: 1001 DEPARTMENT: 100 - FINAL ASSEMBLY SHOP
D ---- ---------------------------
O INVENTORY REPORT - WRHS: %L6C16% DEPT: %L6C38% DTE: %L1C10 % UPD: %L2C10 %
H
H SHELF QNTY QNTY QNTY QNTY
H ITEM NO. DESCRIPTION LIFE UNIT AVAIL ORDER PROC
H ----------- ---------------- ----- ---- ------- ------- ----
1233-781-21 RIVET D. 0.1 ACR NONE KG 100.00 250.00
1233-781-25 RIVET D. 0.5 ACR NONE KG 500.00 500.00
1233-781-27 RIVET D. 0.7 ACR NONE KG 100.00 100.00
OPTIONS: H HEADER F FOOTER D DELETE C COLUMNS I INSERT B BEFORE 16.46.56 -
Press the QUICKVIEW key (PF04/PF16) to display the Report Viewing screen, where you can check the results of the edits.
Figure 108 Report Viewing Screen after Deleting Header Lines
Copy------------- CONTROL-D/V REPORT VIEWING NOTES 0 PAGE 1 OF 9
COMMAND ===> SCROLL ===> CRSR
USR DEMO REP INVENTORY REPORT JB JDEMO 04544 DT 050500 RUL DEFAULT
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
INVENTORY REPORT - WRHS: 1001 DEPT: 100 DTE: 05.05.00 UPD: 05.05.00
SHELF QNTY QNTY QNTY QNTY IN
ITEM NO. DESCRIPTION LIFE UNIT AVAIL ORDER PROCESS
----------- ---------------- ----- ---- ------- ------- ------
1233-781-21 RIVET D. 0.1 ACR NONE KG 100.00 250.00
1233-781-25 RIVET D. 0.5 ACR NONE KG 500.00 500.00
1233-781-27 RIVET D. 0.7 ACR NONE KG 100.00 100.00
2200-700-22 RUBBER RING D. 2.2 1 MON EA 10.00 10.00
2200-700-27 RUBBER RING D. 2.7 1 MON EA 15.00 5.00
2201-750-00 MAIN WHEEL 8 MON EA 85.00 15.00
2201-751-00 NOSE WHEEL 8 MON EA 40.00 10.00
CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n 11.41.08There has been a net deletion of six Header lines, leaving more report lines visible.
-
Save the ruler by pressing the QUICKVIEW key (PF04/PF16) to display the Edit Report Lines and Columns screen.
-
Press the END key (PF03/PF15) to display the Report Editing screen.
-
Press the END key (PF03/PF15) again to display the Exit Option window.
-
Fill in the Exit Option window as shown below, and press Enter.
Figure 109 Report Editing Window with Exit Options
Copy------------------------ CONTROL-D - REPORT EDITING --------------------(U.E)
COMMAND/OPT ===> +---------------------------------+
USER DEMO REPORT INVENTORY REP | |
| PLEASE SELECT EXIT OPTION |
| |
RULER NAME ===> DEFAULT | Exit option ===> 3 |
RULER TYPE ===> VIEW | |
REPORT NAME ===> | 1 KEEP ruler active |
JOB NAME ===> | 2 CLEAR (no ruler) |
USER NAME ===> | 3 SAVE ruler as: |
| |
| Ruler name ===> ORDER1 |
1 EDIT report lines and columns | Ruler type ===> VIEW |
| |
2 INCLUDE lines based on strings +---------------------------------+The Report Viewing screen is displayed with ruler ORDER1.
Print Rulers
All the rulers developed so far have been intended for Online Report Viewing. When you exited these rulers, you defined them as View rulers. Additionally, rulers can be defined as Print rulers.
Print rulers are rulers that reformat a report for printing. You can eliminate unnecessary fields from a 132-column report in order to reduce its width to 80 columns (or less) for printing on an 80-column remote printer by using a Print ruler.
Print rulers may be designed "from scratch" or they may be modified or unmodified copies of existing Print or View rulers.
Follow these steps to save one of the existing View rulers as a Print ruler.
Begin
-
Press the END key (PF03/PF15) to exit to the Active User Report list.
-
Type V (View) in OPTION field of the Employees-Marketing report and press Enter.
-
Press the QUICKVIEW key (PF04/PF16) to display the Report Editing screen.
-
Request Option 1 for ruler INSUR1 (as shown in the figure below) and press Enter to display the Edit Report Lines and Columns screen for ruler INSUR1.
Figure 110 Report Editing Screen with Ruler INSUR1 before Editing
Copy------------------------ CONTROL-D - REPORT EDITING --------------------(U.E)
COMMAND/OPT ===>1
USER DEMO REPORT EMPLOYEES-MARKETING JOB JDEMO
RULER NAME ===> INSUR1 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
Saving View Rulers as Print Rulers
The following steps show how to exit a View ruler and save it as a Print ruler.
-
Press the END key (PF03/PF15) to exit the Edit Report Lines and Columns screen and display the Report Editing screen.
-
Press the END key again to exit the Report Editing screen.
-
The Exit Option window opens on the Report Editing screen.
-
Fill in the window as shown below and press Enter.
Figure 111 Report Editing Window with Exit Options on Saving Print Ruler
Copy------------------------ CONTROL-D - REPORT EDITING --------------------(U.E)
COMMAND/OPT ===> +---------------------------------+
USER DEMO REPORT EMPLOYEES-MAR | |
| PLEASE SELECT EXIT OPTION |
| |
RULER NAME ===> INSUR1 | Exit option ===> 3 |
RULER TYPE ===> VIEW | |
REPORT NAME ===> | 1 KEEP ruler active |
JOB NAME ===> | 2 CLEAR (no ruler) |
USER NAME ===> | 3 SAVE ruler as: |
| |
| Ruler name ===> INSUR1 |
1 EDIT report lines and columns | Ruler type ===> PRINT |
| |
2 INCLUDE lines based on strings +---------------------------------+The Report Viewing screen is now displayed.
-
Press the END key (PF03/PF15) to display the Active User Report list.
Printing a Report
In this exercise, you will print the Employees-Marketing report using the INSUR1 Print ruler.
-
Type P (Print) in OPTION field of the Employees-Marketing report and press Enter to display the Print Option window.
-
Specify in the Print Option window that you want the immediate printing of one complete copy at the desired printer.
-
Specify in the RULER field that you want to use the Print ruler INSUR1 (as shown in the figure below).
Figure 112 Printing Report INSUR1 after Editing
CopyACTIVE LIST <D> JOB REP USR DEMO (U)
COMMAND ===> +----------------------------------------------------------+
O USER REPOR | |
DEMO INVEN | PRINT OPTION ===> |
DEMO EMPLO | |
P DEMO EMPLO | 1 Immediate Printing |
DEMO EMPLO | 2 Deferred Printing (by Print Mission) |
DEMO EMPLO | X Exit (no action) |
DEMO BANKI | |
====== >>>>>>>>> | COPIES 001 FORM CLASS D |
| |
| DEST WTR |
| |
| FROM PAGE 00000001 TO PAGE 00000003 RULER INSUR1 |
| |
| PRINT MISSIONS |
| |
| USER DEMO REPORT EMPLOYEES-MARKETING JOB JDEMO |
| |
+----------------------------------------------------------+ -
Press Enter.
Message CTD947I is displayed:
CopyCTD947I REPORT EMPLOYEES - MARKETING / jobname / user id PRINTED OKThe report is sent to the printer formatted according to Print ruler INSUR1.
Note the following points about Print rulers:
-
Print rulers can only be selected when performing immediate printing from the Print Option window.
-
If a report has a Print ruler named DEFAULT, that ruler is automatically used for the Deferred Printing of the report.
-
Currently, Dynamic Extraction parameters are supported only in View rulers. In a future version, they will also be supported in Print rulers.
Global Rulers
Normally, rulers are defined for a specific user and job report. However, certain users can be authorized by the INCONTROL administrator to define global rulers. These are rulers that are not restricted to use with a specific user and job report.
While global rulers can only be created, modified or deleted by authorized users, all users may access and use them during report viewing.
A global ruler is identified by a $ (dollar sign) character at the beginning of its name (for example, $JOBCHK). The $ character is specified as part of the Ruler Name in the Exit Option window when the ruler is saved.
Your INCONTROL administrator can tell you if there are any global rulers that are available for your use.
SHOWCC and SHOWPAGE Commands
There are two additional commands related to report viewing: SHOWCC and SHOWPAGE.
Print reports contain various print control characters that give directions to the printer during report printing. Print control characters are not part of the actual report and do not appear on the printed report.
Because most users are not interested in seeing print control characters, they are generally hidden during report viewing. However, it is possible to display them by entering the command SHOWCC in the COMMAND field of the Report Viewing screen.
Page break indicators and page control characters are also not normally visible, but can be displayed by entering the command SHOWPAGE.
Re-entering the command hides the special characters.
Type =X in the COMMAND field and press Enter to exit the Online Viewing facility and return to your normal operating environment.
Communities
Support Center
YouTube
Twitter
Facebook
LinkedIn