Ohio Educational Computer Network System (OECN)
UDMS Beginning Training Guide

Notice that the CA_NEW_SALARY field has been added to the default column detail display in the top window.

Also notice that there are no more columns available since the page width is set at 87. Should more columns be needed for additional fields, then the page width would have to be expanded. You have the option to expand to 132, 220, or dynamically to 999 columns.

You have finished defining calculated fields. Press the [PF4] to take you out of the DEFINE mode. The CALCULATED FIELD DEFINITION MENU is displayed next.

_________________________________________________________________________________________ | | | Rpw: REPORT2 REPORT DEFINITION MODIFICATION View: PRSPAY | |....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..| |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY| |********** *************** ******* ********** *********** ********* *************| | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 $9,999.99 $999,999.99| | | | | | | | Calc Fields: 2 CALCULATED FIELD DEFINITION Columns Avail: 0 | | Calc Field Name Typ Mask Field1 Opr Constant/Expr Field2 Cond | | | | 1 CA_RAISE NU $9,99... CUR_SALARY * .07 WHN | | 2 DEPTNO EQ 10 ELS | | 3 CUR_SALARY * .06 | | 4 CA_NEW_SALARY NU $999,... CUR_SALARY + CA_RAISE | | | | | | MENU <PF3> cancel <PF4> finished | | | | ADD an Entry REVIEW the Entries COPY to Paste Buffer CANCEL | | INSERT an Entry CLEAR all Entries CUT to Paste Buffer FINISHED | | CHANGE an Entry EXAMINE Format =====> TOP | | DELETE an Entry | |_______________________________________________________________________________________|

This menu allows you to ADD, INSERT, CHANGE, DELETE, REVIEW, or CLEAR the calculated field entries, as well as to EXAMINE the report layout. You can also COPY or CUT a calculation to the paste buffer. These options are used to duplicate existing calculations without having to re-type the entries. The other options allow you to CANCEL the calculation entries, FINISH editing calculation details, or to return to the [TOP] RPW menu.

Since you are finished with defining calculated fields, highlight the [TOP] option and press [Return]. You will see the following [TOP] RPW menu.

_________________________________________________________________________________________ | | | Rpw: REPORT2 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |=======================================================================================| |DD-MMM-YY HH:MN XM REPORT2 PAGE 9999| | Lesson 2 Report | | Data definition (PRSPAY) | |=======================================================================================| |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY| |********** *************** ******* ********** *********** ********* *************| | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $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.4.4 Generate the Report

Again, you are asked to PREVIEW the proposed report. This time when the report is generated, you will be prompted to "Enter the highest Department Number to process". The value you enter will be assigned as the current value of the Input variable, IN_DEPTNO. However, since this variable is not yet used in the report, the value you enter will actually not affect the report in any way. In the next lesson, you will use this variable to limit or select just those records whose DEPTNO value is equal to or less than the value you enter when generating the report.

In order to PREVIEW the updated report, type in the command, GEN, and press the [Return] key. The following REPORT GENERATION/ OUTPUT PARAMETERS screen will appear.

Highlight the "PREVIEW this Report" option and press the [Return] key.

Processsing will begin, and the following screen should appear which will ask you to enter some value for the "highest Department Number to Process".

_________________________________________________________________________________________ | | | Rpw: REPORT2 REPORT GENERATION View: PRSPAY | | | | Enter the highest Department Number to Process: 10 <==== | | | |_______________________________________________________________________________________|

Enter the value 10 and press the [Return] key. The first page of the report, similar to the following, should appear on your screen.

======================================================================================== 03-JAN-97 09:55 AM REPORT2 PAGE 1 Lesson 2 Report Data definition (PRSPAY) ======================================================================================== EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY ********** *************** ******* ********** *********** ********* ************* 00-105 NOLL 20 1 $ 4,500.00 $ 270.00 $ 4,770.00 00-110 MARVIN 10 1 $ 3,000.00 $ 210.00 $ 3,210.00 00-120 CUSHNER 10 1 $ 1,450.00 $ 101.50 $ 1,551.50 00-125 GARNER 10 2 $ 13.50 $ .95 $ 14.45 00-135 ANDERSON 30 1 $ 2,100.00 $ 126.00 $ 2,226.00 00-140 ROTH 30 2 $ 8.50 $ .51 $ 9.01 00-145 NORRIS 10 1 $ 850.00 $ 59.50 $ 909.50 00-150 HIRSCH 30 1 $ 800.00 $ 48.00 $ 848.00 00-156 HOBART 10 2 $ 9.25 $ .65 $ 9.90 00-180 HASKINS 30 2 $ 12.00 $ .72 $ 12.72 00-203 FOSTER 30 1 $ 2,000.00 $ 120.00 $ 2,120.00 Press <RETURN> to continue or <PF3> to cancel....

Notice the "DEPTNO" field in the report. Even though you entered 10 as the highest Department Number to process, other department numbers appear as well. In lesson 3 you will see how to use the INPUT field in a condition in order to select only a subset of the records.

Press the [Return] key several times until you return to the REPORT GENERATION/OUTPUT PARAMETERS Menu as shown below.

Choose the CANCEL option to return to the SERVICES MENU, (you may need to press CANCEL twice) and then select the MAIN option to return to the Main UDMS menu as shown next.

3.5 Lesson 3 - Qualifying Data Records

In this lesson you will use the "QUALIFY" option to select records for inclusion in your report. Qualifications may be based on the relationship of one field to another, of fields to constant values and/or of fields to functions. Multiple qualifying statements may be entered, connected with AND or OR, depending on the results you wish to achieve. Further, the order in which statements are evaluated may be controlled by the use of parentheses.

In this lesson, you will construct a simple qualification to include only records with a wage class of 1 (full-time, salaried employees) and the department range which is specified when the report is generated.

In lesson 3, you will complete the following steps:

(1) Load the report definition, "REPORT3".
(2) Bring up the RPW REPORT MENU [TOP].
(3) Select "QUALIFY Data Records".
(4) Enter Data Record Qualifications.
(5) GENERATE the report for the latest results.

You will start up with "REPORT3" which is included in the demo dictionary, and is an exact copy of the definition created in lesson 2. In other words, REPORT3 starts up where you left off in the previous lesson.

3.5.1 Load Report Definition - REPORT3

You should be at the UDMS main menu as shown below:

Proceed with the following steps on your own, as given in the next table:

MENU / SCREEN USER ENTRY / SELECTION

1. Main Menu If your top right banner displays: "View PRSPAY", skip to step 3.
Otherwise:
Highlight "DATA" option and press [Return].

2. Data Definition Screen Type PRSPAY and press [Return].

3. Main Menu Press [Return] on RPW option.

4. ReportWriter Menu Press [Return] on SELECT any RPW Def option.

5. Report Definition Screen Highlight REPORT3 and press [Return]. It will be necessary to press the [PF1] key several times to bring up the screen which contains the REPORT3 listing. Use the down arrow key to highlight this entry.

The above steps should bring up the following "REPORT DEFINITION SERVICES" screen:

_________________________________________________________________________________________ | | | Rpw: REPORT3 REPORT DEFINITION SERVICES View: PRSPAY | | | |=======================================================================================| |DD-MMM-YY HH:MN XM REPORT3 PAGE 9999| | Lesson 3 Report | | Data definition (PRSPAY) | |=======================================================================================| |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY| |********** *************** ******* ********** *********** ********* *************| | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 $9,999.99 $999,999.99| | | | | | | | | | SERVICES MENU <PF4> finished | | | | MODIFY this Def GENERATE Report SELECT another Def FINISHED | | COPY this Def SUBMIT Report to Batch DEFINE a new Def MAIN | | DELETE this Def EXAMINE Format EXIT | | DOCUMENT this Def REVIEW Report | |_______________________________________________________________________________________|

Contents

Ohio Educational Computer Network System (OECN)UDMS Beginning Training Guide

3.4.4 Generate the Report

3.5 Lesson 3 - Qualifying Data Records

3.5.1 Load Report Definition - REPORT3

Ohio Educational Computer Network System (OECN)
UDMS Beginning Training Guide