After previewing the report, you will be returned to the [TOP] RPW menu as shown next. You may have to press the <PF3> CANCEL key first.

_________________________________________________________________________________________ | | | Rpw: REPORT5 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |=======================================================================================| |HH:MN XM REPORT5 PAGE 9999 | | Lesson 5 Report | | MM/DD/YYYY | |=======================================================================================| |DEPT. #: 9999 | |EMPLOYEE # LASTNAME WAGE CLASS SALARY RAISE NEW SALARY | |********** *************** ********** *********** ********* *********** | | | | 00-000 XXXXXXXXXXXXXXX 9 $999,999.99 $9,999.99 $999,999.99 | | DEPT. TOTALS $999,999.99 $9,999.99 $999,999.99 | | $999,999.99 $9,999.99 $999,999.99| | | | | | | | | | REPORT MENU [TOP] <PF3> cancel | | | | SELECT Rpt Fields TOTAL this Rpt MODIFY Rpt Descriptor CANCEL | | DEFINE Input/Calc Flds FORMAT this Rpt CHANGE Submit Options SAVE as | | QUALIFY Data Records GENERATE this Rpt CATALOG | | SORT Rpt Data EXAMINE Format | |_______________________________________________________________________________________|

3.8.5 Format Report Trailer

The Page FOOTER allows you to define what will print on the last print line(s) of each page of the report. The Page FOOTER is defined exactly like the Report TRAILER, which is discussed below.

The Report TITLE serves as a "banner page", and allows you to specify what will print prior to page 1 of the report. A default title page can be captured which includes: report name and description, generation date, time and operator, and the data definition against which the report is defined. The formatting process for this page is identical to that of the page header.

The Report TRAILER allows you to specify what will print at the end of the report. When you used the "TOTAL this Rept" option, a report trailer was created containing totals for the three fields: CUR_SALARY, CA_RAISE, and CA_NEW_SALARY.

You should be at the [TOP] REPORT MENU screen. Do the following:

1. Select "FORMAT this Rpt" from the [TOP] Menu.
2. Select "Report TRAILER" from the FORMAT MENU.

The following screen should appear.

_________________________________________________________________________________________ | | | Rpw: REPORT5 REPORT DEFINITION MODIFICATION View: PRSPAY | |....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..| | 00-000 XXXXXXXXXXXXXXX 9 $999,999.99 $9,999.99 $999,999.99 | | $999,999.99 $9,999.99 $999,999.99| | | | | | | | | | Trailer Entries: 3 REPORT TRAILER FORMATTING | | Type Field Mask Text/Assign/Expr Lin Jst Col | | | | 1 TOT CUR_SALARY $999,999.99 1 RHT 61 | | 2 TOT CA_RAISE $9,999.99 1 RHT 72 | | 3 TOT CA_NEW_SALARY $999,999.99 1 RHT 87 | | | | | | | | REPORT TRAILER MENU <PF3> cancel <PF4> finished | | | | ADD an Entry REVIEW the Entries CANCEL | | INSERT an Entry CLEAR all Entries FINISHED | | CHANGE an Entry EXAMINE Format TOP | | DELETE an Entry | |_______________________________________________________________________________________|

Again, the top window is a template, displaying the default report trailer. This trailer contains place holders for the following field totals: CUR_SALARY, CA_RAISE, and CA_NEW_SALARY. These place holders will need to be adjusted in the same fashion as the report group totals.

The middle window displays the details associated with the default report trailer. The entries in this particular example give us the totals of all employee salaries, raises, and new salaries. However, you could easily change the data type in any of the fields to reflect a value (VAL), an average (AVE), count (CNT), count unique (CNQ), a minimum (MIN), or a maximum (MAX) value.

The individual item details are exactly the same as for the group trailer.

For this exercise you are to do the following modifications. Adjust the columns for the report TOTALS and add a text line.

Adjusting the TOTAL Fields

Currently the fields CUR_SALARY, CA_RAISE, and CA_NEW_SALARY are right justified at columns 52, 63, and 76 while the totals in the report trailer are right justified at columns 61, 72, and 87.

What you are to do next is to use the CHANGE option and change the column justifications for the totals to columns 52, 63, and 76. This is exactly the same procedure as you used for adjusting the totals for the group trailer.

Select the CHANGE option and set the column positions to 52, 63, and 76. The resulting screen should be similar to the following:

_________________________________________________________________________________________ | | | | | Rpw: REPORT5 REPORT DEFINITION MODIFICATION View: PRSPAY | |....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..| | 00-000 XXXXXXXXXXXXXXX 9 $999,999.99 $9,999.99 $999,999.99 | | $999,999.99 $9,999.99 $999,999.99 | | | | | | | | | | | | Trailer Entries: 3 REPORT TRAILER FORMATTING | | Type Field Mask Text/Assign/Expr Lin Jst Col | | | | 1 TOT CUR_SALARY $999,999.99 1 RHT 52 | | 2 TOT CA_RAISE $9,999.99 1 RHT 63 | | 3 TOT CA_NEW_SALARY $999,999.99 1 RHT 76 | | | | | | | | CHANGE/STD <PF1> next <PF4> finished | | | | Highlight the desired ENTRY by use of the <arrow> keys or by entering the | | ENTRY-Number followed by <return>. | | | | Press <return> to select the ENTRY for CHANGE. | |_______________________________________________________________________________________|

Press the [PF4] key to finish out.

Enter Descriptive Text

The next step is to enhance the report by adding the descriptive text "REPORT TOTALS:" on the line which contains the totals.

You are to add the text "REPORT TOTALS:" to the Report Trailer.

1. Use the ADD option.
2. Place this text on the same physical line as the totals.
3. Left justify at column 25.

Once you have added the text, the screen should resemble the following.

__________________________________________________________________________________ | | | Rpw: REPORT5 REPORT DEFINITION MODIFICATION View: PRSPAY | |....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80| | 00-000 XXXXXXXXXXXXXXX 9 $999,999.99 $9,999.99 $999,999.99 | | REPORT TOTALS: $999,999.99 $9,999.99 $999,999.99 | | | | | | | | Trailer Entries: 4 REPORT TRAILER FORMATTING | | Type Field Mask Text/Assign/Expr Lin Jst Col | | | | 1 TOT CUR_SALARY $999,999.99 1 RHT 52 | | 2 TOT CA_RAISE $9,999.99 1 RHT 63 | | 3 TOT CA_NEW_SALARY $999,999.99 TOT_NEW_SAL 1 RHT 76 | | 4 TXT REPORT TOTALS: 1 LFT 25 | | 5 VAL | | | | ADD <PF2> help <PF4> finished | |________________________________________________________________________________|

If you pressed [PF4] after finishing with line 4, the screen will show the text, REPORT TOTALS:, in the top window as shown above.

3.8.6 Generate the Report

You are asked to again PREVIEW the report as it now stands. You can go straight to the PREVIEW and bypass the OUTPUT PARAMETERS screen by typing in the value, GEN PRE, and pressing the [Return] key. The report process will begin and will prompt you for the "highest Department Number to Process:". Enter the value 40 as shown next.

__________________________________________________________________________________ | | | | | Rpw: REPORT5 REPORT GENERATION View: PRSPAY | | | |Enter the highest Department Number to process: 40 | | | | | | | | | | | | | | | | GENERATE <PF3> cancel | |________________________________________________________________________________|

The first page of the report should be displayed on your terminal and should be similar to the following.

================================================================================ 04:05 PM REPORT5 PAGE 1 Lesson 5 Report 23-JAN-97 ================================================================================ EMPLOYEE # LASTNAME WAGE CLASS SALARY RAISE NEW SALARY ********** *************** ********** *********** ********* *********** DEPT. #: 10 00-120 CUSHNER 1 $ 1,450.00 $ 101.50 $ 1,551.50 00-110 MARVIN 1 $ 3,000.00 $ 210.00 $ 3,210.00 00-145 NORRIS 1 $ 850.00 $ 59.50 $ 909.50 DEPT. TOTALS $ 5,300.00 $ 371.00 $ 5,671.00 Press <RETURN> to continue or <PF3> to cancel....

The last page should look similar to the following. Notice the addition of the report trailer.

================================================================================ 04:05 PM REPORT5 PAGE 4 Lesson 5 Report 23-JAN-97 ================================================================================ EMPLOYEE # LASTNAME WAGE CLASS SALARY RAISE NEW SALARY ********** *************** ********** *********** ********* *********** DEPT. #: 40 00-215 CONVEY 1 $ 1,250.00 $ 75.00 $ 1,325.00 00-205 GONZOLES 1 $ 1,250.00 $ 75.00 $ 1,325.00 DEPT. TOTALS $ 2,500.00 $ 150.00 $ 2,650.00 REPORT TOTALS: $ 21,800.00 $1,361.00 $ 23,161.00 Press <RETURN> to continue....

You should be returned to the OUTPUT PARAMETERS screen. Press the CANCEL key [PF3]. You should now be returned to the [TOP] REPORT MENU.

At this point DO NOT CATALOG. Press the [PF3] key to Cancel, and accept "yes" to cancel. Now select the EXIT option to return to the OECN menu. At this point you can exit from the menu or re-enter UDMS by selecting the UDMS option.

The following sections present several scenarios for reports using some of the State Software packages. More will be added as time permits. All of these will use the ReportWriter tools just presented in the previous 5 lessons. The first report for each package will be very basic, while the next one will use more of the options such as formatting and subtotalling.

These exercises are to be run on the user's own data files. However, if this is not possible, the DAS may have test files available.

4.1 USPS Sample Reports

First you should log on to an account which contains USPS payroll files.

4.1.1 First Absence Detail Report

You are to create an absence detail report which lists all records not yet reported to USAS.

1. At the OECN Menu select UDMS, and then select the USPS Data Base.
2. Bring up the Main UDMS menu and select RPW.
3. Use the ATTENDANCE data definition from the USPS listing.
4. DEFINE a report descriptor giving a report name and description.
5. Select the fields: FULL_NAME, JOB_NO, TRANSACTION_TYPE, ABSENCE_CATEGORY, LENGTH_OF_ABSENCE, USAS_POSTING_INDICATOR (be sure to use the one for USAS).
6. Qualify the field, USAS_POSTING_INDICATOR so that the records selected are not equal to Y. That is, you want to select only those records which have not yet been posted.
7. Select to sort first on the field FULL_NAME (see note below) and next on the field JOB_NO.
8. Preview the report at your terminal (see note 2 below). As an alternative, print the report to a text file, and then print or view the text file.
9. Lastly, CATALOG the report so that it can used as a starting point for the next exercise.

Note 1: There is potentially a problem with the FULL_NAME field. You may have noticed that this field appears twice in the report field list. This is because the ATTENDANCE view was obtained by joining the Employee Record with the Absence Record and FULL_NAME is the common field used for the join. As a result, the FULL_NAME field that was originally selected is really, FULL_NAME:EMPLOYEES_REC.

Now when entering the primary sort field you can either type in a field name or press [PF1] and then highlight FULL_NAME and press [Return] to select it. If you use this second method, the sort field name will be: FULL_NAME:EMPLOYEES_REC.

A problem may occur during the next exercise when setting up the group trailer. When using the default trailer option, the default break field will be the name of the primary sort field. (So this name could either be FULL_NAME or FULL_NAME:EMPLOYEES_REC, depending on what was entered for the sort field name.) The point is that the sort field and the break field names must be the same. When entering more lines to the group trailer, you must use the same break field name as the sort name. Just recall this note in the next exercise.

Note 2: In order to limit the number of records shown on the report, you can set two parameters on the OUTPUT PARAMETERS MENU as show next. First select the GENERATE option. When the following screen appears, select the option to "CHANGE an Output Parameter", then set the READ LIMIT = 500 (This is just an estimate. You may need to either lower or raise this value.) and the QUALIFY LIMIT = 50.

_______________________________________________________________________________ | | | | | Rpw: DIEHL_ABSDET1 REPORT GENERATION View: ATTENDANCE | | | | O U T P U T P A R A M E T E R S | | | | 1. Output Specification : TERMINAL | | | | 2. Printer Type : 13. Number of copies : 1 | | 3. Page Length : 60 14. First page to print: 1 | | 4. Page Width : 109 15. Last page to print : | | 5. Report Spacing : SINGLE 16. Stop every page : N | | 6. Characters per inch : | | 7. Top Margin : 17. Read Limit : 500 | | 8. Bottom Margin : 18. Qualify Limit : 50 | | 9. Left Margin : 19. Extract Display Inc: 500 | |10. Page Break : N | |11 Suppress Dupl Values : N 20. 4GL Include File : | |12. Summary Report : N | | | | MENU <PF3> cancel | | | | CONTINUE with Generate PREVIEW this Report CANCEL | | CHANGE an Output Parameter | |_____________________________________________________________________________|

Sample ABSDET 1 Report

Your report should look similar to the following except for different data:

=============================================================================================== 29-JAN-97 01:41 PM DIEHL_ABSDET1 PAGE 1 Abs Rept 1 - Abs Not Reported USAS Data definition (ATTENDANCE) =============================================================================================== Job Trans Absence Length Of USAS Full Name Num Type Category Absence Post BROWN, SARA S 00 AC SI 1.2500 BROWN, SARA S 00 AC SI 1.2500 COOPER, GEORGE A 00 AC VA 20.0000 COOPER, GEORGE A 00 AB SI 1.0000 FARMER, WILLIAM E 01 AT SB 1.0000 HAMMER, MICHAEL M 03 AT SB 1.0000 MCINSTOSH, MAC B 00 AC SI 1.2500 MCINSTOSH, MAC B 00 AC SI 1.2500 MCINSTOSH, MAC B 00 AB SI 1.0000 MCINSTOSH, MAC B 00 AB SI 1.0000 MCINSTOSH, MAC B 00 AB SI 0.5000 Press <Return> to continue or <PF3) to cancel....