The Include Lines Based On Strings screen limits the records included in a report to those records containing specified strings in specified locations.
This exercise shows you how to include records that contain the string 08 in columns 30 through 31 (the OFFICE NO. field).
The cursor is positioned in the first STR (string) field.
The cursor is positioned in the COL from field.
The cursor automatically tabs to the COL to field.
Your entry should look like the one displayed below:
Figure 49 Selecting Lines to Include
---------------- CONTROL-D - INCLUDE LINES BASED ON STRINGS ----------(U.E.2)
COMMAND ===> Apply on header N
STR 08 COL 030 - 031 LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
STR COL - LINE - COLOR HL
In this example, the report is limited to records containing a single specified string in a specified column range. However, the Include Lines Based on Strings screen contains twenty lines for string specification and a different string and column-range may be specified on each line of the screen. Records having at least one of the specified strings will be included in the report.
The Report Viewing screen is displayed.
Figure 50 Results of Include Edits
------------- CONTROL-D/V REPORT VIEWING NOTES 0 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
-------- -------------- ------ ------ ------------ ---------- ---------
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
66115 N. TRACEY 08 23,000 XXX-YY-ZZZZ 1
66133 J. BRENNAN 08 27,000 XXX-YY-ZZZZ 1
66155 M. GOLIGER 08 50,000 XXX-YY-ZZZZ 2
======= >>>>>>>>>>>>>> END OF SCROLLABLE DATA IN PAGE <<<<<<<<<<<<<<<<<<< =====
Only employees from Office Number 08 are included in the report.
The Include Lines Based on Strings screen is again displayed.
The Report Viewing screen is displayed with ruler OFN08 (for Office Number 08).
Figure 51 Saving New Ruler OFN08
------------- CONTROL-D/V REPORT VIEWING NOTES 0 PAGE 1 OF 3
COMMAND ===> SCROLL ===> CRSR
USR DEMO REP EMPLOYEES-MARKETING JB JDEMO 04544 DT 050500 RUL OFN08
----+----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
-------- -------------- ------ ------ ------------ ---------- ---------
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
66115 N. TRACEY 08 23,000 XXX-YY-ZZZZ 1
66133 J. BRENNAN 08 27,000 XXX-YY-ZZZZ 1
66155 M. GOLIGER 08 50,000 XXX-YY-ZZZZ 2
======= >>>>>>>>>>>>>> END OF SCROLLABLE DATA IN PAGE <<<<<<<<<<<<<<<<<<< =====
Parent Topic |