When you enter option 1 (Edit Lines and Columns for View and Print) on the Report Editing (Ruler) screen, the screen Figure 118 is displayed.
Figure 118 Edit Lines and Columns on the Report Editing (Ruler) Screen
----------------- CONTROL-D - EDIT REPORT LINES AND COLUMNS ----------(U.E.1)
COMMAND ===> SP CHAR SCROLL===> CRSR
USR PROD REP EMPLOYEES REPORT JB PREMPRS2 RULER DEFAULT TYPE VIEW
O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+-
1 E M P L O Y E E S R E P O R T ----- FOR PRODUCTION DE
EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLAS
NO. NAME NO. SAL SECURITY NO. DEPENDENTS CODE
-------- -------------- ------ ------ ------------ ---------- --------
66474 C. POHLHAMMER 23 39,500 XXX-YY-ZZZZ 2
66475 G. MEREDITH 09 40,000 XXX-YY-ZZZZ 3
66491 P. MILLER 12 31,500 XXX-YY-ZZZZ 1
66498 K. BOYLE 22 39,500 XXX-YY-ZZZZ 2
66501 R. BERLE 14 39,500 XXX-YY-ZZZZ 2
66513 C. KING 12 30,000 XXX-YY-ZZZZ 2
66519 G. BROWNE 02 36,500 XXX-YY-ZZZZ 2
66524 R. SOLOMON 04 35,000 XXX-YY-ZZZZ 3
66526 S. CUNNINGHAM 21 39,500 XXX-YY-ZZZZ 2
66529 M. TABER 22 39,500 XXX-YY-ZZZZ 2
66530 A. WINGER 23 39,500 XXX-YY-ZZZZ 2
66531 B. BOOKSPAN 05 47,000 XXX-YY-ZZZZ 4
66533 R. MULU 29 39,500 XXX-YY-ZZZZ 2
66539 E. SMART 02 29,000 XXX-YY-ZZZZ 4
66540 N. MATTOZZI 11 29,000 XXX-YY-ZZZZ 2
OPTIONS: H HEADER F FOOTER D DELETE C COLUMNS I INSERT B BEFORE 11.59.53
The screen contains one page of the report. This sample page is used to define the line and column editing criteria. You can use the scrolling conventions to scroll backward, forward, left and right on the page. If you enter this screen from the Active Report list, the first page of the report is displayed. If you enter this screen from the Report Viewing screen, the currently viewed page is displayed.
Each data line of the page is preceded by an option field. Valid options:
Table 108 Options for Edit Lines on the Report Editing (Ruler) Screen
Option |
Description |
---|---|
H (HEADER) |
This line of the report page is fixed as a header when scrolling. Normally, because of the difference between the number of lines in a report page and in a screen, the header of the report disappears when you scroll forward on a page. Lines marked as HEADER remain at the top of the screen when you scroll the report. When the beginning of the next report page is reached, the header of that report page becomes the header on the screen. Any number of lines can be marked as headers. Multiple header lines must be contiguous (except for lines marked D for Delete) and begin with the first line on the page. |
F (FOOTER) |
Similar to header line definition, footers begin at the bottom line of the report page. In all other respects, they operate like headers. |
I (INSERT) |
Insert a user-defined overlay line after the line in which the option has been specified. A new line is displayed on the screen. This line is marked O (Overlay). Information can be typed on this line. To fill in more than 77 columns, shift left and right. |
B (BEFORE) |
Same as INSERT, but inserts the overlay line before the line on which the option has been specified. |
D (DELETE) |
If this option is specified on an original page line (that is, any line other than an overlay line), the line does not appear on the screen when the report is viewed. The line identification is positional from the top of the page, unless the deleted line is part of the footer, in which case the identification is positional from the bottom of the page. |
C (COLUMNS) |
This option identifies the selected line as a "model" line to be used in a cut and paste operation that allows column reformatting. Details of column reformatting are discussed later in this chapter. This option causes the Column Editing screen to be displayed (discussed later in this chapter). |
Using the I (Insert) option, overlay lines can be periodically inserted between report detail lines to make the report easier to read (for example, a blank line can be inserted between every five records).
Used together, the D (Delete) and I (Insert) options enable you to rearrange header line information. By inserting overlay lines into which you can type header line information, and by deleting the original header lines, the following useful edits can be performed:
Example
Consider the following report page:
Figure 119 Edit Lines and Columns on the Report Editing (Ruler) Screen – Example
----------------- CONTROL-D - EDIT REPORT LINES AND COLUMNS ----------(U.E.1)
COMMAND ===> SP CHAR SCROLL===> CRSR
USER PROD JOB PREMPRS2 RULER DEFAULT TYPE VIEW
REPORT EMPLOYEES REPORT
O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+-
D 1 E M P L O Y E E S R E P O R T ----- FOR PRODUCTION DE
H EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLAS
H NO. NAME NO. SAL SECURITY NO. DEPENDENTS CODE
O ======== ============== ====== ====== ============ ========== ========
D -------- -------------- ------ ------ ------------ ---------- --------
66474 C. POHLHAMMER 23 39,500 XXX-YY-ZZZZ 2
66475 G. MEREDITH 09 40,000 XXX-YY-ZZZZ 3
66491 P. MILLER 12 31,500 XXX-YY-ZZZZ 1
66498 K. BOYLE 22 39,500 XXX-YY-ZZZZ 2
66501 R. BERLE 14 39,500 XXX-YY-ZZZZ 2
O ----------------------------------------------------------------------------
66513 C. KING 12 30,000 XXX-YY-ZZZZ 2
66519 G. BROWNE 02 36,500 XXX-YY-ZZZZ 2
66524 R. SOLOMON 04 35,000 XXX-YY-ZZZZ 3
66526 S. CUNNINGHAM 21 39,500 XXX-YY-ZZZZ 2
66529 M. TABER 22 39,500 XXX-YY-ZZZZ 2
O ----------------------------------------------------------------------------
66530 A. WINGER 23 39,500 XXX-YY-ZZZZ 2
66531 B. BOOKSPAN 05 47,000 XXX-YY-ZZZZ 4
OPTIONS: H HEADER F FOOTER D DELETE C COLUMNS I INSERT B BEFORE 12.06.26
The result is as follows:
Figure 120 Edit Lines and Columns on the Report Editing (Ruler) Screen – Example Results
----------------- CONTROL-D REPORT VIEWING -------------- PAGE 1 OF 3
COMMAND ===> SCROLL ===> CRSR
USER PROD JOBNAME PREMPRS2 JOBNUMB 0009812 DATA 080800 RULER DEFAULT
REPORT EMPLOYEES REPORT
---+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----
EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLASS
NO. NAME NO. SAL SECURITY NO. DEPENDENTS CODE
======== ============== ====== ====== ============ ========== ========
66474 C. POHLHAMMER 23 39,500 XXX-YY-ZZZZ 2
66475 G. MEREDITH 09 40,000 XXX-YY-ZZZZ 3
66491 P. MILLER 12 31,500 XXX-YY-ZZZZ 1
66498 K. BOYLE 22 39,500 XXX-YY-ZZZZ 2
66501 R. BERLE 14 39,500 XXX-YY-ZZZZ 2
----------------------------------------------------------------------------
66513 C. KING 12 30,000 XXX-YY-ZZZZ 2
66519 G. BROWNE 02 36,500 XXX-YY-ZZZZ 2
66524 R. SOLOMON 04 35,000 XXX-YY-ZZZZ 3
66526 S. CUNNINGHAM 21 39,500 XXX-YY-ZZZZ 2
66529 M. TABER 22 39,500 XXX-YY-ZZZZ 2
----------------------------------------------------------------------------
66530 A. WINGER 23 39,500 XXX-YY-ZZZZ 2
66531 B. BOOKSPAN 05 47,000 XXX-YY-ZZZZ 4
66533 R. MULU 29 39,500 XXX-YY-ZZZZ 2
66539 E. SMART 02 29,000 XXX-YY-ZZZZ 4
CMDS: FIND str, FIND str PREV, EDIT, RULER on/off/name, N n P n 12.06.51
Dynamic Extraction Parameters
Information that you retype into overlay lines remains constant, and is therefore useful only if the original information remains constant (such as a report title).
Report information that may change from day to day or even from page to page (for example, date, department number) can be rearranged using Dynamic Extraction parameters.
Dynamic Extraction parameters allow you to extract dynamically changing information from various locations in the report and place it into one or more header overlay lines.
Dynamic Extraction parameters make use of a special identifying character (of your choice), which you specify in the SP CHAR field (for example, the % character).
Dynamic Extraction parameters are defined in the overlay lines.
The basic format is:
dLnCn ...d
where
You simultaneously create the Dynamic Extraction parameter and identify where the value should be copied in an overlay line, as follows:
An additional format is:
dP1LnCn ...d
This parameter always extracts the value from the first page of the report and carries it forward to every page of the report. You must enter the ruler from the first page of the report (in the Report Viewing screen), or from the Report list, to use this format. This parameter functions when entering the Report Viewing screen with a ruler in effect, but not when deactivating and subsequently reactivating a ruler (using the RULER command) on a page other than the first page of the report.
As a variation to the two Dynamic Extraction parameter formats, you can specify that the line number is to be counted from the bottom of the page (instead of the top). To do this, format the line number in the parameter as LLn (Lower Line number), instead of Ln.
Thus, the parameters dLnCn and dP1LnCn would become dLLnCn and dP1LLnCn respectively, where LLn identifies the number of lines from the last line.
Note: The Dynamic Extraction parameters are supported during Online viewing only.
Example
The following report contains 11 header lines and only eight data lines. The information in the first seven lines can be condensed to one overlay line (and the seven lines deleted). This would almost double the number of data lines displayed.
Figure 121 Dynamic Extraction Parameter– Example
----------------- CONTROL-D REPORT VIEWING -------------- PAGE 1 OF 9
COMMAND ===> SCROLL ===> CRSR
USER DEMO JOBNAME REPORT1 JOOBNUMB 0004544 DATA 080800 RULER DEFAULT
REPORT INVENTORY REPORT
---+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----
1DATE: 08.08.00
UPDATE: 08.09.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, FIND str PREV, EDIT, RULER on/off/name, N n P n 10.07.03
In the Edit Report Lines and Columns screen:
----------------- CONTROL-D - EDIT REPORT LINES AND COLUMNS ----------(U.E.1)
COMMAND ===> SP CHAR % SCROLL===> CRSR
USER DEMO JOB JDEMO RULER DEFAULT TYPE VIEW
REPORT INVENTORY REPORT
O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+--
O ----+----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 QNTY
The results are as follows:
Figure 122 Dynamic Extraction Parameter– Example Results
----------------- CONTROL-D REPORT VIEWING -------------- PAGE 1 OF 9
COMMAND ===> SCROLL ===> CRSR
USR DEMO JOBNAME JDEMO JOBNUMB 0004544 DATA 080800 RULER ORDER1
REPORT INVENTORY REPORT
---+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----
INVENTORY REPORT - WRHS: 1001 DEPT: 100 DTE: 08.08.00 UPD: 08.08.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
2201-800-22 METAL O RING 2.2 NONE EA 20.00 30.00
2274-711-21 WASHER D. 0.1 NONE KG 10.50 10.50
2274-711-25 WASHER D. 0.5 NONE KG 450.00 400.00
2274-811-21 BOLT 1/8 NONE KG 50.00 25.00
2274-811-27 BOLT 1/32 NONE KG 55.00 50.00
2284-811-21 NUT 1/8 NONE KG 55.00 20.00
2284-811-27 NUT 1/32 NONE KG 55.00 50.00
CMDS: FIND str, FIND str PREV, EDIT, RULER on/off/name, N n P n 10.07.03
Parent Topic |