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

Select the Output Fields

The next step when using the INQUIRY LIST option is to determine which fields will be included in the list. This can be a selected subset, or all of the fields.

For this exercise choose the SELECTED fields option. A screen such as the following will appear. 


 
___________________________________________________________________________ 
|                                                                         |  
| Version 5.3-aa                   INQUIRY LIST              View: PRSPAY |       
|                                                                         |       
|   1 ________________________________                                    |       
|                                                                         |       
|                                                                         |       
|                                                                         |       
|                                                                         |       
|                                                                         |       
|                                                                         |       
|  List Fields: 0              LIST 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           |       
|                                                                         |      
| SELECT               <PF1> select   <PF2> help           <PF4> finished | 
|_________________________________________________________________________|                                                                                |

Press the [PF1] key to access the list of data fields. Use the arrow keys to highlight each of the following fields to appear on the inquiry. Press the [Return] key for each entry.

Select the following fields: SSN, LASTNAME, FIRSTNAME, ADDR1, CITY, ZIP, BRTHDATE, TITLE, MSTATUS, CUR_SALARY, FICA_BASE.

Press the [PF4] key when finished completing entries. A screen such as the following will appear. 


 
__________________________________________________________________________ 
|                                                                        | 
| Version 5.3-aa                   INQUIRY LIST             View: PRSPAY |       
|                                                                        |        
|   7 BRTHDATE                                                           |        
|   8 TITLE                                                              |        
|   9 MSTATUS                                                            |        
|  10 CUR_SALARY                                                         |        
|  11 FICA_BASE                                                          |        
|                                                                        |        
|                                                                        |        
|  List Fields: 11             LIST FIELD SELECTION                      |        
|     Data   Fields                     Record        DspLen Typ Key     |        
|                                                                        |        
|  25 CUR_SALARY                      : PAYMST            9  NU          |        
|  26 PAY_TYPE                        : PAYMST            1  NU          |        
|  27 CUR_HOURS                       : PAYMST            6  NU          |        
|  28 FICA_BASE                       : PAYMST            8  NU          |        
|  29 FICA_RATE                       : PAYMST            8  NU          |        
|                                                                        |        
| FIELD SELECT MENU                        <PF3> cancel  <PF4> finished  | 
|                                                                        |        
| ADD    a Field                REVIEW the Fields             CANCEL     |        
| INSERT a Field                CLEAR  all Fields             FINISHED   |        
| DELETE a Field                                                         |        
|________________________________________________________________________|

At this point you have the options to Add a field, Insert a field, Delete a field, Clear all fields and start over, Review the fields, or Cancel the whole thing and return to the main LIST Menu.

If the selections are correct, then press the [PF4] key to begin the search, and bring up the first page of the list. A sample screen follows: 


 
___________________________________________________________________________________ 
|                                                                                 | 
| Version 5.3-aa                   INQUIRY LIST              View: PRSPAY         | 
|                                                                                 | 
|SSN         LASTNAME        FIRSTNAME          ADDR1                          CI | 
|----------- --------------- ------------------ ------------------------------ -- | 
|514-77-6523 ANDERSON        WILLIAM A          7506 S TRENTON CT              MA | 
|234-99-2883 ROTH            PAUL G             7909 COLUMBINE AVE             TH | 
|213-76-9980 HASKINS         FRANK R            2183 CREIGHTON DR              BR | 
|202-10-8392 DAVIS           THOMAS R           5401 W CLINTON DR              TH | 
|373-67-3831 BUCHANAN        HAROLD H           5041 S PINEWOOD WY             LI | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
| LIST                                              <PF3> cancel                  | 
|                                                                                 | 
| NEXT   page                                                 CANCEL              | 
| REVIEW page                                                                     | 
|_________________________________________________________________________________|

In order to view the hidden part of the screen, press the [REVIEW Page] key. You will now be able to scroll to the Right and to the Left as shown in the next screen. 


 
___________________________________________________________________________________ 
|                                                                                 | 
| Version 5.3-aa                   INQUIRY LIST              View: PRSPAY         | 
|                                                                                 | 
|SSN         LASTNAME        FIRSTNAME          ADDR1                          CI | 
|----------- --------------- ------------------ ------------------------------ -- | 
|514-77-6523 ANDERSON        WILLIAM A          7506 S TRENTON CT              MA | 
|234-99-2883 ROTH            PAUL G             7909 COLUMBINE AVE             TH | 
|213-76-9980 HASKINS         FRANK R            2183 CREIGHTON DR              BR | 
|202-10-8392 DAVIS           THOMAS R           5401 W CLINTON DR              TH | 
|373-67-3831 BUCHANAN        HAROLD H           5041 S PINEWOOD WY             LI | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
| REVIEW               <PF1> home                        <PF4> finished           | 
|                                                                                 | 
| Scroll LEFT                                                 FINISHED            | 
| Scroll RIGHT                                                                    | 
|_________________________________________________________________________________|

Use the RIGHT and LEFT scroll keys to review the entire list.

When finished, press the [PF4] key to return to a previous menu. Then press the [NEXT Page] key.

When you reach the end of the data, press the [PF4] key two times to return to main INQUIRY Menu as shown next. 


 
---------------------------------------------------------------------------- 
|                                                                          | 
| Version 5.3-aa                      Inquiry                View: PRSPAY  | 
|                                                                          |      
|   1 EMPNO                           : ______                             |     
|   2 SSN                             : ___________                        |     
|   3 LASTNAME                        : _______________                    |      
|   4 FIRSTNAME                       : __________________                 |      
|   5 ADDR1                           : ______________________________     |      
|   6 ADDR2                           : ______________________________     |      
|   7 CITY                            : _______________                    |      
|   8 STATE                           : __                                 |      
|   9 ZIP                             : __________                         |      
|  10 AREACODE                        : ___                                |      
|  11 PHONE                           : ________                           |      
|  12 GENDER                          : _                                  |      
|  13 BRTHDATE                        : ________                           |      
|  14 HIREDATE                        : ________                           |      
|  15 TERMDATE                        : ________                           |      
|                                                                          |      
| MENU                 <PF1> command                        <PF4> finished | 
|                                                                          |      
| SHOW  existing records        DATA  select a Data Definition    FINISHED |      
| LIST  existing records                                          EXIT     |      
| COUNT existing records                                                   |      
|__________________________________________________________________________|

SELECT COUNT OPTION

Now select the COUNT option. You will see a screen similar to the following: 


 
___________________________________________________________________________ 
|                                                                         | 
| Version 5.3-aa                  INQUIRY COUNT              View: PRSPAY |       
|                                                                         |       
|   1 EMPNO                           : ______                            |       
|   2 SSN                             : ___________                       |       
|   3 LASTNAME                        : _______________                   |       
|   4 FIRSTNAME                       : __________________                |       
|   5 ADDR1                           : ______________________________    |       
|   6 ADDR2                           : ______________________________    |       
|   7 CITY                            : _______________                   |       
|   8 STATE                           : __                                |       
|   9 ZIP                             : __________                        |      
|  10 AREACODE                        : ___                               |       
|  11 PHONE                           : ________                          |       
|  12 GENDER                          : _                                 |       
|  13 BRTHDATE                        : ________                          |       
|  14 HIREDATE                        : ________                          |       
|  15 TERMDATE                        : ________                          |       
|                                                                         |       
| MENU                                              <PF3> cancel          |       
|                                                                         |       
|     SELECTED records                                                    |       
|     BY       example                                                    |       
|     ALL      records                                                    |       
|_________________________________________________________________________|

For this exercise we want to obtain a count of the number of male employee records. To do this use the option to select BY example.

A screen similar to the following will appear. 


 
 
 Version 5.3-aa                  INQUIRY COUNT              View: PRSPAY        
____________________________________________________________________________ 
|                                                                          |                                                                
|   1 EMPNO                           : ______                             |      
|   2 SSN                             : ___________                        |      
|   3 LASTNAME                        : _______________                    |      
|   4 FIRSTNAME                       : __________________                 |      
|   5 ADDR1                           : ______________________________     |      
|   6 ADDR2                           : ______________________________     |      
|   7 CITY                            : _______________                    |      
|   8 STATE                           : __                                 |      
|   9 ZIP                             : __________                         |      
|  10 AREACODE                        : ___                                |      
|  11 PHONE                           : ________                           |      
|  12 GENDER                          : _                                  |      
|  13 BRTHDATE                        : ______                             |      
|  14 HIREDATE                        : ________                           |      
|  15 TERMDATE                        : ________                           |      
|                                                                          |      
| BY EXAMPLE     <PF1> clear    <PF2> help    <PF3> cancel  <PF4> finished | 
|__________________________________________________________________________|

Press the [PF1] key in order to clear any previous selections.

Use the arrow keys to move to the GENDER field and enter a capital M. Then press the [Return] key.

After making the selections, press [PF4] key to begin the counting process. The number of selected records will appear at the bottom of the screen as shown next. 


 
____________________________________________________________________________ 
|                                                                          | 
| Version 5.3-aa                  INQUIRY COUNT              View: PRSPAY  |      
|                                                                          |      
|   1 EMPNO                           : ______                             |      
|   2 SSN                             : ___________                        |      
|   3 LASTNAME                        : _______________                    |      
|   4 FIRSTNAME                       : __________________                 |      
|   5 ADDR1                           : ______________________________     |      
|   6 ADDR2                           : ______________________________     |      
|   7 CITY                            : _______________                    |      
|   8 STATE                           : __                                 |      
|   9 ZIP                             : __________                         |      
|  10 AREACODE                        : ___                                |      
|  11 PHONE                           : ________                           |      
|  12 GENDER                          : M                                  |      
|  13 BRTHDATE                        :                                    |      
|  14 HIREDATE                        : ________                           |      
|  15 TERMDATE                        : ________                           |      
|                                                                          |      
| BY EXAMPLE     <PF1> clear    <PF2> help    <PF3> cancel  <PF4> finished | 
|                                                                          |      
| 13 records QUALIFIED....                                                 |       
|                                                                          |      
|                                                                          |      
| Press <PF4> to continue....                                              |       
|__________________________________________________________________________|

Press the [PF4] key to continue. Keep pressing [PF4] until you return to the main UDMS menu.

Chapter 3
Learning UDMS:ReportWriter

3.1 Overview

The material for this chapter is taken, with permission, from the "UDMS Getting Started Guide", distributed by Interactive Software Systems, Inc, Denver, Colorado.

This chapter leads you, step by step, through the many features offered by ReportWriter (RPW). As you complete the lessons provided, you will become very familiar with such options as:
o Choosing fields o Defining calculated fields
o Generating output o Identifying selection criteria
o Defining input fields o Formatting a report

ReportWriter offers a unique window based interface for generating
reports--- from a simple default report to a comprehensive user-defined matrix, detail, or summary report. This chapter will walk you through the steps from a simple default report to more complex reports using input values, calculated fields, subtotalling and formatting.

3.2 Steps to Create a Report

As you will see in lesson 1 which follows, very few steps are necessary to create a meaningful report. Once a data definition has been loaded, you use the following steps with ReportWriter:

  1. Define the report descriptor. Contains the name of the report, a description, the page width, default format options, and security information.
  2. Select the fields desired from the current data definition (view).
  3. View or print out the default report using the "GENERATE" OPTION, as illustrated next. 


     
__________________________________________________________________________________ 
|                                                                                | 
| Rpw: REPORTHD           REPORT DEFINITION MODIFICATION     View: PRSPAY        | 
|                                                                                | 
|================================================================================| 
|DD-MMM-YY  HH:MN XM                REPORTHD                            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                                      | 
|________________________________________________________________________________|

    Upon selecting "GENERATE", you may then choose output parameters for the report such as, output location, left and right margins, first and last page to print, characters per inch, numbers of copies, etc. Reports may be generated interactively or sent to batch.

    As an option, reports generated to a holding file may be REVIEWED on the screen by scrolling forward and backward, or by searching for a matching string.

  4. Optionally, customize your report through various format options as shown on the next screen: 


     
__________________________________________________________________________________ 
|                                                                                | 
| Rpw: REPORTHD           REPORT DEFINITION MODIFICATION     View: PRSPAY        | 
|                                                                                | 
|================================================================================| 
|DD-MMM-YY  HH:MN XM                REPORTHD                            PAGE 9999| 
|                                Lesson 1 Report                                 | 
|                           Data definition (PRSPAY)                             | 
|================================================================================| 
|EMPLOYEE #  DEPT. #  WAGE CLASS       SALARY                                    | 
|**********  *******  **********  ***********                                    | 
|                                                                                | 
|    00-000     9999           9  $999,999.99                                    | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
| FORMAT MENU                                                  <PF4> finished    | 
|                                                                                | 
| Page   HEADER           Page   FOOTER         EXAMINE Format        FINISHED   | 
| Column DETAIL           Report TITLE                                           | 
| Report GROUPS           Report TRAILER                                         | 
|________________________________________________________________________________|

    The format options - Page HEADER, Column DETAIL, Report GROUPS, Page FOOTER, Report TITLE, Report TRAILER - allow you to customize your report by identifying what will print at the top or bottom of each page, the information to be printed from each record, and/or the data to be totalled.

  5. As a final step, you may optionally enhance the report with any of the following sections: 


     
INPUT FIELDS---------------------------------------------------------- 
|                                                                    | 
| Input Fields: 1             INPUT FIELD DEFINITION                 |            
|     Input Field Name  Type          Prompting Text                 |            
|                                                                    |            
|   1 IN_USER            AN   Enter your LASTNAME in all CAPS:       |            
|                                                                    | 
|____________________________________________________________________|                                                                                



    CALCULATED FIELDS------------------------------------------------------------------ 
|                                                                                 | 
| Calc Fields: 2           CALCULATED FIELD DEFINITION       Columns Avail: 918   |                                                   
|   Calc Field Name Typ Mask      Field1         Opr Constant/Expr Field2    Cond |                                                   
|                                                                                 |                                                   
|   1 CA_RAISE       NU $99,999.99.  CUR_SALARY   *  .06                     WHN  |                                                 
|   2                                WAGE_CLS     EQ  1                           |                                                     
|   3 CA_PAY_DT      TS MM/DD/YY     HIRE_DATE    +   10                          |                                                                                                                 
|_________________________________________________________________________________|                                                                                                                                    



    RECORD QUALIFICATION--------------------------------------------------------------- 
|                                                                                 | 
| Qual Entries: 2           DATA RECORD QUALIFICATION                             |                                                   
|        Comparison    Comparison     ----- Compare to ----------          And/Or |                                                   
|           Field       Operator    Constant               Field                  |                                                   
|                                                                                 |                                                   
|   1  DEPTNO              GE   10                                           AND  |                                                   
|   2  DEPTNO              LE   30                                                |                                                   
|_________________________________________________________________________________|

    Previous Next Contents