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

For this lesson you will use the "Column Display".
Field Description
6. Public Report contains a Yes or No value. Y = report definition will be available to all users whose access level is the same as or greater than that of the author. N = report definition will be available to ONLY this user ID or to "THE" UDMS System Manager. A blank is the same as a "Y".
7. Access Level The ACCESS LEVEL indicates the level of user access necessary to SELECT the report definition. There are nine access levels available, 1 - 9, where 9 has the highest privilege.
8. Access Password To further restrict access into SELECTING a report definition, a password may be entered. Passwords may be up to 6 characters of any type and are case sensitive.

A user with an access level EQUAL TO that of the report definition must know the password to select the definition.

A user with an access level GREATER THAN that of the report definition will not be required to know the password to select the definition.

9. Definition Modify Level While a report definition may be available for selection, this value determines the user access level necessary to MODIFY it.

Enter Values for the Report Descriptor

For this lesson use the following values. Use the name, REPORTXX (where XX are your initials), and describe it as "Lesson 1 Report". Then accept the default values provided for the remaining fields.

The screen should look similar to the following: 


 
____________________________________________________________________________ 
|                                                                          | 
| UDMS-ReportWriter             REPORT DEFINITION            View: PRSPAY  |      
|                                                                          |      
|                     R E P O R T     D E S C R I P T O R                  |      
|                                                                          |      
|  1. Report Name             : REPORTXX                                   |      
|  2. Description             : Lesson 1 Report                            |      
|                                                                          |      
|  3. Page Width              :  80                                        |      
|  4. Default Page Header     :  Y                                         |       
|  5. Default Column Detail   :  Y                                         |       
|                                                                          |      
|  6. Public Report           :  N                                         |       
|  7. Access Level            :  3                                         |      
|  8. Access Password         :                                            |      
|                                                                          |      
|  9. Definition Modify Level :  3                                         |      
|                                                                          |      
|                                                                          |      
| CHANGE/STD           <PF1> opn              <PF3> cancel  <PF4> finished | 
|                                                                          |      
| Highlight the desired DETAIL by use of the <arrow> keys or by entering   |      
| the Detail-Number followed by <return>.                                  |      
|                                                                          |      
| Press <return> to open the Detail for CHANGE.                            |      
|__________________________________________________________________________|

Press [PF4] key to accept the defaults.

3.3.3 Select the Report Fields

After defining the report descriptor, the REPORT FIELD SELECTION menu, similar to the following screen will automatically appear. 


 
__________________________________________________________________________ 
|                                                                        | 
| Rpw: REPORTXX                REPORT DEFINITION            View: PRSPAY |       
|                                                                        |        
|                                                                        |        
|                                                                        |        
|                                                                        |        
|                                                                        |        
|                                                                        |        
| Report Fields:              REPORT FIELD SELECTION                     |        
|     Data   Fields                     Record        DspLen Typ Key     |        
|   1 EMPNO                           : PRSMST            5  NU  P       |        
|   2 SSN                             : PRSMST            9  NU  A1      |        
|   3 LASTNAME                        : PRSMST           15  AN  A2      |        
|   4 FIRSTNAME                       : PRSMST           18  AN          |        
|   5 ADDR1                           : PRSMST           30  AN          |        
|   6 ADDR2                           : PRSMST           30  AN          |        
|                                                                        |        
|                                                   <PF3> cancel         |   
|                                                                        |    
| Select the FIELDS to be included in the Report.                        |    
|                                                                        |    
|      SELECTED fields                                                   |    
|      ALL      fields                                                   |    
|________________________________________________________________________|

Notice that the top banner displays the name of your Report Definition and the current Data Definition with which your are working, "PRSPAY". The middle window displays the first six fields from the data definition.

The FIELD SELECTION MENU gives you the option of selecting certain fields, or all fields from the current data definition. You may include up to 256 fields in a report.

Selecting the Fields

The report definition you are to create will consist of the following fields:
EMPNO (employee number)
DEPTNO (department number)
WAGE_CLS (wage class)
CUR_SALARY (current salary)

Later you will add to the list. Highlight the SELECTED fields option, and press the [Return] key. A screen such as the following will appear: 


 
___________________________________________________________________________________ 
|                                                                                 | 
| Rpw: REPORTXX                REPORT DEFINITION            View: PRSPAY          | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80 | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|  Report Fields: 0           REPORT FIELD SELECTION         Columns Avail: 80    | 
|     Data   Fields                     Record        DspLen Typ Key              | 
|   1 EMPNO                           : PRSMST            5  NU  P                | 
|   2 SSN                             : PRSMST            9  NU  A1               | 
|   3 LASTNAME                        : PRSMST           15  AN  A2               | 
|   4 FIRSTNAME                       : PRSMST           18  AN                   | 
|   5 ADDR1                           : PRSMST           30  AN                   | 
|   6 ADDR2                           : PRSMST           30  AN                   | 
|                                                                                 | 
| SELECT               <PF1> next     <PF2> help                  <PF4> finished  | 
|_________________________________________________________________________________|

You will first need to highlight the desired field, and then press the [Return] key to include it in the report. To highlight a field do one of the following:

  • Type the field name.
  • Type the field number.
  • Use the [Arrow] keys to traverse the list of fields.
  • Use the [PF1] key to traverse the list of fields.

While the cursor is in the list of data fields, notice that next to each field name, there is additional information---the record definition associated with the field, the field length, the data type, and the key designation (if applicable).

You want the first field "EMPNO", which is highlighted, to be included in the report. Press the [Return] key while the cursor is on "EMPNO". A screen similar to the following will appear. 


 
___________________________________________________________________________________ 
|                                                                                 | 
| Rpw: REPORTXX                 REPORT DEFINITION            View: PRSPAY         | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80 | 
|EMPLOYEE #                                                                       | 
|**********                                                                       | 
|                                                                                 | 
|    00-000                                                                       | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|  Report Fields: 1           REPORT FIELD SELECTION         Columns Avail: 70    | 
|     Data   Fields                     Record        DspLen Typ Key              | 
|   1 EMPNO <====                     : PRSMST            5  NU  P                | 
|   2 SSN                             : PRSMST            9  NU  A1               | 
|   3 LASTNAME                        : PRSMST           15  AN  A2               | 
|   4 FIRSTNAME                       : PRSMST           18  AN                   | 
|   5 ADDR1                           : PRSMST           30  AN                   | 
|   6 ADDR2                           : PRSMST           30  AN                   | 
|                                                                                 | 
| SELECT               <PF1> next     <PF2> help                  <PF4> finished  | 
|_________________________________________________________________________________|

Notice that the ruler is displayed in the top window, and that the "EMPNO" field is automatically positioned at column 1. This top window will serve as a template for our default column detail, displaying a default column heading and a data place holder, 00-000 (indicating the format of the data field). The column length is determined by the longer of the column heading or the data.

Next move the cursor down to highlight line 17, "DEPTNO". Press the [Return] key to add this field to the report. The screen should like similar to the following: 


 
___________________________________________________________________________________ 
|                                                                                 | 
| Rpw: REPORTXX                 REPORT DEFINITION            View: PRSPAY         | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80 | 
|EMPLOYEE #  DEPT. #                                                              | 
|**********  *******                                                              | 
|                                                                                 | 
|    00-000     9999                                                              | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|  Report Fields: 2           REPORT FIELD SELECTION         Columns Avail: 61    | 
|     Data   Fields                     Record        DspLen Typ Key              | 
|  13 BRTHDATE                        : PRSMST            6  DT                   | 
|  14 HIREDATE                        : PRSMST            6  DT                   | 
|  15 TERMDATE                        : PRSMST            6  DT                   | 
|  16 CURRENT                         : PRSMST            1  AL                   | 
|  17 DEPTNO <====                    : PRSMST            4  NU                   | 
|  18 TITLE                           : PRSMST           10  AN                   | 
|                                                                                 | 
| SELECT               <PF1> next     <PF2> help                  <PF4> finished  | 
|_________________________________________________________________________________|

Again, notice that the field is automatically placed, displaying the default column heading and data representation. Also notice that the middle banner shows that there are 61 available columns remaining for an 80 column format.

Now move the cursor to select the field "WAG_CLS", and then to select the "CUR_SALARY" field. The screen should look similar to the following: 


 
___________________________________________________________________________________ 
|                                                                                 | 
| Rpw: REPORTXX                 REPORT DEFINITION            View: PRSPAY         | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80 | 
|EMPLOYEE #  DEPT. #  WAGE CLASS       SALARY                                     | 
|**********  *******  **********  ***********                                     | 
|                                                                                 | 
|    00-000     9999           9  $999,999.99                                     | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|  Report Fields: 4           REPORT FIELD SELECTION         Columns Avail: 36    | 
|     Data   Fields                     Record        DspLen Typ Key              | 
|  21 PAY_EMPNO                       : PAYMST            5  NU                   | 
|  22 R_BRANCH                        : PAYMST            2  NU                   | 
|  23 R_NUMBER                        : PAYMST            3  NU                   | 
|  24 WAGE_CLS  <====                 : PAYMST            1  NU                   | 
|  25 CUR_SALARY <====                : PAYMST            9  NU                   | 
|  26 PAY_TYPE                        : PAYMST            1  NU                   | 
|                                                                                 | 
| SELECT               <PF1> next     <PF2> help                  <PF4> finished  | 
|_________________________________________________________________________________|

Since you have finished adding fields to the report, press the [PF4] key to move out of the select mode. The following screen will appear which allows you to ADD, INSERT, DELETE, or REVIEW the fields. You have the option of adding more fields or deleting fields at a later time. 


 
__________________________________________________________________________________ 
|                                                                                | 
| Rpw: REPORTXX           REPORT DEFINITION MODIFICATION     View: PRSPAY        | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80| 
|EMPLOYEE #  DEPT. #  WAGE CLASS       SALARY                                    | 
|**********  *******  **********  ***********                                    | 
|                                                                                | 
|    00-000     9999           9  $999,999.99                                    | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
|  Report Fields: 4           REPORT FIELD SELECTION         Columns Avail: 36   | 
|     Report Fields                                                              | 
|   1 EMPNO                                                                      | 
|   2 DEPTNO                                                                     | 
|   3 WAGE_CLS                                                                   | 
|   4 CUR_SALARY                                                                 | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
| FIELD SELECT MENU                                 <PF3> cancel  <PF4> finished | 
|                                                                                | 
| ADD    a Field                REVIEW the Fields             CANCEL             | 
| INSERT a Field                EXAMINE format                FINISHED           | 
| DELETE a Field                                                                 | 
|________________________________________________________________________________|

Since you are finished for now, press the [PF4] key. You will be returned to the REPORT DEFINITION menu which looks like the following. 


 
__________________________________________________________________________________ 
|                                                                                | 
| Rpw: REPORTXX                 REPORT DEFINITION            View: PRSPAY        | 
|                                                                                | 
|================================================================================| 
|DD-MMM-YY  HH:MN XM                REPORTXX                            PAGE 9999| 
|                                Lesson 1 Report                                 | 
|                           Data definition (PRSPAY)                             | 
|================================================================================| 
|EMPLOYEE #  DEPT. #  WAGE CLASS       SALARY                                    | 
|**********  *******  **********  ***********                                    | 
|                                                                                | 
|    00-000     9999           9  $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                                      | 
|________________________________________________________________________________|

The cursor should be on the "DEFINE Input/Calc Flds" option. Notice that the columns of options are in a normal sequence of steps to create to a UDMS report. As you return from one option, the cursor will automatically be positioned at the next option.

A brief description of each of the options on this menu follow:
Option Explanation
SELECT Rpt Fields is used to select the fields which will appear on the report.
DEFINE Input/Calc Flds allows you to define a new field for input data or to define a new field based on calculations involving other fields.
QUALIFY Data Records is used to set up criteria to select just a subset of the records in the data base.
SORT Rpt Data allows you to specify the fields for sorting and the order of the sort.
FORMAT this Rpt allows you to group the report data and include subtotals and group headers and footers. It also allows you to print page headers and footers with subtotals and report summary.
GENERATE this Rpt allows you to preview the report or to generate it with the result sent to your terminal, a text file, or a printer.
EXAMINE Format allows you to look at the formats for all of the fields used in this report.
MODIFY Rpt Descriptor allows you to change any of the parameters for the current Report Descriptor.
CHANGE Submit Options allows you to change any of the parameters for submitting the report to batch printing.
CANCEL allows you to cancel all of the changes made so far to this report.
SAVE As allows you to save the current report definition under a new name. You do not leave the report by selecting this option and the current report definition is preserved.
CATALOG allows you to save the report definition under the current name. This option will replace the current report definition with the new version and will not exit from the report. It is a good idea to CATALOG (SAVE) the report fairly frequently in order not to lose your changes.

Previous Next Contents