|
|
|
|
Ohio Educational Computer Network System (OECN)
|
| Previous | Contents |
Once the desired details of the report definition have been created, the definition may be saved. There are two ways of saving a report---"CATALOG" and "SAVE As".
Use the CATALOG option to save your initial work or subsequent changes to a current report definition. The new definition replaces any previous report definition and does not leave the current menu.
Use the SAVE As option to save the report definition under a new name. This does not disturb the current report definition nor does it leave the current menu.
The CANCEL option is used to leave the current report definition intact and ignores any changes that may have been made.
For this lesson highlight the CATALOG option and press the [Return] key.
While the report is being cataloged, ReportWriter displays the message shown in the partial screen below, and prompts you to press [PF4].
_____________________________________________________________________________ | CATALOG | | | |Report Definition REPORTXX has been cataloged ! | | | | | |Press <PF4> to continue.... | |___________________________________________________________________________| |
Press the [PF4] key, and then highlight the MAIN option and press [Return] to return to the MAIN UDMS Menu as shown below.
______________________________________________________________________________ | | | Version 5.3-aa User Data Management System View: PRSPAY | | | | M A I N M E N U | | | | RPW ReportWriter INQ Inquiry | | EXP Export | | LBL Labels | | TXT Text/Merge | | | | MOD Select Defs by Module (RPW, EXP, FRM...) | | DATA Select a Data Def (Record/View/Alias) | | EXIT | | | | | | | | | | | | MENU <PF2> help <PF4> exit | | | | Copyright (C) 1987-1995 Interactive Software Systems Inc. | | Enabled until 11/18/01. | |____________________________________________________________________________| |
3.4 Lesson 2 - Defining Input/Calculated Fields
In this lesson you will expand on the report created in lesson 1 while
learning how to define:
| INPUT Fields | allows you to define fields and prompting text to be displayed upon generation. This provides dynamic processing; ie. every time the report is run, different data may be applied based upon the value(s) entered. | |
| CALCULATED Fields | allows you to perform calculations using fields, constants, and expressions. Calculations may be performed on every record, or conditionally, based on qualification data. |
In lesson 2 you will define both input and calculated fields. You will use these fields in the lessons which follow.
The following steps will be used in lesson 2:
You will start up with "REPORT2" which is included in the demo dictionary, and is an exact copy of the definition created in lesson 1. In other words, REPORT2 starts up where you left off in the previous lesson.
It is very important that you do NOT use the CATALOG option during lessons 2 - 5. This because these same beginning reports will be used by later users. If you need to save your work and return to it at a later time, you should use the SAVE AS option, and give the report a new name. Then when you return, use the new named report to continue. |
You should be at the UDMS main menu as shown below:
_____________________________________________________________________________ | | | Version 5.3-aa User Data Management System View: PRSPAY | | | | M A I N M E N U | | | | RPW ReportWriter INQ Inquiry | | EXP Export | | LBL Labels | | TXT Text/Merge | | | | MOD Select Defs by Module (RPW, EXP, FRM...) | | DATA Select a Data Def (Record/View/Alias) | | EXIT | | | | | | | | | | MENU <PF2> help <PF4> exit | | | | Copyright (C) 1987-1995 Interactive Software Systems Inc. | | Enabled until 11/18/01. | |___________________________________________________________________________| |
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 REPORT2 and press [Return]. It will be necessary to press the [PF1] key several times to bring up the screen which contains the REPORT2 listing. Use the down arrow key to highlight this entry. |
The above steps should bring up the following "REPORT DEFINITION SERVICES" screen:
_________________________________________________________________________________________ | | | Rpw: REPORT2 REPORT DEFINITION SERVICES View: PRSPAY | | | |=======================================================================================| |DD-MMM-YY HH:MN XM REPORT2 PAGE 9999| | Lesson 2 Report | | Data definition (PRSPAY) | |=======================================================================================| |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY | |********** *************** ******* ********** *********** | | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $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 | |_______________________________________________________________________________________| |
You will define the input field "IN_DEPTNO" which will allow you to specify a value for DEPTNO every time the report is run.
Select the MODIFY option in order to bring up the main REPORT MENU. The following screen should appear.
========================================================================================= |DD-MMM-YY HH:MN XM REPORT2 PAGE 9999| | Lesson 2 Report | | Data definition (PRSPAY) | |=======================================================================================| |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY | |********** *************** ******* ********** *********** | | | | 00-000 XXXXXXXXXXXXXXX 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 | |_______________________________________________________________________________________| |
Now highlight and select the "DEFINE Input/Calc Flds " option. This brings up the INPUT/CALC FIELD DEFINITION MENU.
Select the "Define an INPUT Field' option as indicated below.
______________________________________________________________________________ | | | INPUT/CALC MENU <PF4> finished | | | | Define an INPUT Field <==== EXAMINE Format FINISHED | | Define a CALCULATED Field | |____________________________________________________________________________| |
Next select the "USER-DEFINED Input Fields" option as indicated below.
______________________________________________________________________________ | | | DEFINE INPUT FIELDS <PF3> cancel | | | | USER-DEFINED Input Fields <==== CANCEL | | LOAD Input Fields from existing Def TOP | |____________________________________________________________________________| |
The following INPUT FIELD DEFINITION screen will be displayed next:
______________________________________________________________________________ | | | Rpw: REPORT2 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY | |********** *************** ******* ********** *********** | | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 | | | | | | | | Input Fields: 0 INPUT FIELD DEFINITION | | | Input Field Name Type Prompting Text | | | | 1 ___________... | | | | | | | | DEFINE <PF2> help <PF4> finished | | | | Enter a unique NAME up to 32 characters in length, that will contain an | | associated "input value". An Input Field is loaded with the "Input Value" | | entered during Generate. This Field may be used in other Report sections | | (ie. qualification, calculations, etc.), and will be substituted by the | | "Input Value". | |____________________________________________________________________________| |
In order to differentiate between fields selected from the data definition and input fields defined for the report, it is customary to use a prefix of "IN" to name the input fields. The "Input Field" name may contain up to 32 letters, numbers and/or underscores and may start with a letter or an underscore. No special characters, other than an underscore, may be used as part of an input field name.
Notice that input fields do NOT affect the column detail display as shown above, and therefore will NOT use any available columns, (note the absence of the ruler in the top window.)
Enter IN_DEPTNO as the Input Field Name and press the [Return] key. The following screen should be displayed.
______________________________________________________________________________ | | | Rpw: REPORT2 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY | |********** *************** ******* ********** *********** | | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 | | | | | | | | Input Fields: 0 INPUT FIELD DEFINITION | | | Input Field Name Type Prompting Text | | | | 1 IN_DEPTNO AN | | | | | | | | DEFINE <PF2> help <PF4> finished | | | |____________________________________________________________________________| |
The "Type" detail determines the type of data that will be accepted for the input value. You can specify one of the following types:
| Type | Input Value Requirements |
|---|---|
| AN | alphanumeric; any character is valid. |
| NU | numeric string; any numeric character is valid |
| ET | elapsed time, uses the format DDDDD_HR:MN:SS.CC. You may enter a portion of the format from left to right, on both sides of the underscore, eg., DD_HR:MN, such as: 20_10:15 (20 days, 10 hours, and 15 minutes have elapsed.) |
| TS | time stamp; includes date and/or time; uses the format YYYYMMDD_HR:MN:SS.CC. You may enter a portion of the format from left to right, eg., YYMMDD_HR, such as 960630_06 (for year 1996, month 06, day 30 and hour 06 am.) |
| FN | field name: allows a field name to be entered when the report is run. For example, this could be used to specify a particular sort field. |
If you pressed the [PF2] (HELP) key while the cursor is on the "Type" field, the following screen would appear listing the choices for the "Type" of field.
__________________________________________________________________________________ | | | Rpw: REPORT2 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY | |********** *************** ******* ********** *********** | | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 | | | | | | | | Input Fields: 0 INPUT FIELD DEFINITION | | | Input Field Name Type Prompting Text | | | | 1 IN_DEPTNO AN <==== | | | | | | | | DEFINE <PF2> help <PF4> finished | | | | Enter the DATA TYPE for | AN any character ET elapsed time (DDDDD_HH:MN:SS) | | this Input Field. | NU numeric string TS time stamp (date and/or time) | | | FN field name | | | | |________________________________________________________________________________| |
| Previous | Next | Contents |
