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

3.3.4 Generate the Report

You have completed all that is necessary in defining a report definition -- defining the report descriptor and selecting fields from the data definition. Reports may be generated either interactively or in batch.

Select the GENERATE option in order to begin the reporting process. This will display the following OUTPUT PARAMETERS screen. Some of the output parameters are assigned a default value while some are left blank (not set).

______________________________________________________________________________ | | | Rpw: REPORTXX REPORT GENERATION View: PRSPAY | | | | 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 : 80 15. Last page to print : | | 5. Report Spacing : SINGLE 16. Stop every page : N | | 6. Characters per inch : | | 7. Top Margin : 17. Read Limit : | | 8. Bottom Margin : 18. Qualify Limit : | | 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 RETURN without printing | |____________________________________________________________________________|

Note the following parameters:

# Parameter Explanation

1 Output Specification This may be set to the TERMINAL, a text file name, or a printer queue.

6 Characters per inch The choices are 10, 12, 16.5

11 Suppress Dupl Values If set to "Y", then duplicate values in the same column will not be printed until the value changes.

16 Stop Every Page If set to "Y", then the print process will stop at the end of each page. This is useful if printing to a terminal or feeding sheets of paper by hand.

17 Read Limit Causes the report generator to limit the number of records to be read.

18 Qualify Limit Causes the report generator to limit the number of qualified (selected) records to be read.

19 Extract Display Inc The increment (in number of reads processed) that will cause the status of qualifying records to be displayed. For example, if this value were set to 500, then after each set of 500 reads, the number of qualifying records and the total number of records read would be displayed.

The four menu options for this screen are explained below:

Menu Option Use

CONTINUE with Generate is used to begin the report generation process once the screen parameters are set as desired.

CHANGE an Output Parameter allows you to change any of the parameter values on the above screen.

PREVIEW this Report allows you see the report at your terminal. This option automatically overrides the following parameters with the indicated values:

Output Specification : TERMINAL

Page Length : 22

Stop Every Page : Y

RETURN Without Printing Returns you to the previous menu without printing the report.

For this lesson select the PREVIEW option.

The PREVIEW option outputs one page at a time to your terminal. A sample page of the report is displayed next.

================================================================================ 27-DEC-96 09:00 AM REPORTXX PAGE 1 Lesson 1 Report Data definition (PRSPAY) ================================================================================ EMPLOYEE # DEPT. # WAGE CLASS SALARY ********** ******* ********** *********** 00-105 20 1 $ 4,500.00 00-110 10 1 $ 3,000.00 00-120 10 1 $ 1,450.00 00-125 10 2 $ 13.50 00-135 30 1 $ 2,100.00 00-140 30 2 $ 8.50 00-145 10 1 $ 850.00 00-150 30 1 $ 800.00 00-156 10 2 $ 9.25 00-180 30 2 $ 12.00 00-203 30 1 $ 2,000.00 Press <RETURN> to continue or <PF3> to cancel....

Press the [Return] to see the remainder of the report and a second time to return to the REPORT GENERATION menu. This menu is shown next.

Select the option "RETURN Without Printing". The following screen should appear which is at the TOP Report Menu.

__________________________________________________________________________________ | | | 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 | |________________________________________________________________________________|

3.3.5 Select Additional Fields

In order to enhance the report you are asked to add the additional field, LASTNAME. You will then review the report again.

Choose the "SELECT Rpt Fields" option. A screen similar to the following will appear.

In order to add the LASTNAME field between the EMPNO and DEPTNO fields, you will need to use the "INSERT a Field" option.

Select the option to "INSERT a Field". A screen similar to the following will appear:

__________________________________________________________________________________ | | | 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 | | | | | | | | INSERT <PF1> next <PF2> help <PF4> finished | | | | Highlight the desired Field by use of the <arrow> keys or by entering the | | Field-Number followed by <return>. | | | | Press <return> to INSERT the new Field. | |________________________________________________________________________________|

Move the cursor to the field "DEPTNO" and press the [Return] key. A screen similar to the next should appear.

At this point you can either type in the desired field name (if you know it), or you can press the [PF1] key to open up a list of field names from the data definition and use the arrow keys to find the field.

For this lesson, press the [PF1] key to open us a list of field names. A screen similar to the following should appear.

Use the down arrow key to move the cursor to the field, LASTNAME, and press the [Return] key. The screen should look like the following:

__________________________________________________________________________________ | | | Rpw: REPORTXX REPORT DEFINITION MODIFICATION View: PRSPAY | |....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80| |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY | |********** *************** ******* ********** *********** | | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 | | | | | | | | Report Fields: 5 REPORT FIELD SELECTION Columns Avail: 19 | | Report Fields | | 2 LASTNAME | | 3 ________________________________ | | DEPTNO | | WAGE_CLS | | CUR_SALARY | | | | | | INSERT <PF1> select <PF2> help <PF4> finished | |________________________________________________________________________________|

Notice that the LASTNAME field now appears at the top of the screen between the original fields, EMPNO and DEPTNO, and with a predefind character length. Also notice that the fields have been renumbered in the middle window.

Press the [PF4] key to return to the Insert Mode Menu

If you wish, you could insert more new fields between other listed fields. Since you are finished with the Insert Mode, press the [PF4] key again to return to the Field Select Menu.

At this point you could add new fields to the end of the above list or delete any of the fields in the list. Since you are done with inserting or adding fields, press the [PF4] key one more time to return to the Top REPORT MENU.

Review the Report

You are now asked to preview the report with the new field added.

UDMS has the ability to "type ahead". By typing enough characters of the desired screen selections to uniquely identify them, and separating each by a space, you can bypass the display of the individual screens. This time type-in the command "GEN PRE" as shown in the screen below in order to use the PREVIEW option of the GENERATE option all in one command.

__________________________________________________________________________________ | | | Rpw: REPORTXX REPORT DEFINITION MODIFICATION View: PRSPAY | | | |================================================================================| |DD-MMM-YY HH:MN XM REPORTXX PAGE 9999| | Lesson 1 Report | | Data definition (PRSPAY) | |================================================================================| |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY | |********** *************** ******* ********** *********** | | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 | | | | | | | | | | | | | | REPORT MENU [TOP] <PF3> cancel | | | | GEN PRE <===== | | 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 report will be displayed on your screen, and should look similar to the following:

================================================================================ 27-DEC-96 08:57 AM REPORTXX PAGE 1 Lesson 1 Report Data definition (PRSPAY) ================================================================================ EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY ********** *************** ******* ********** *********** 00-105 NOLL 20 1 $ 4,500.00 00-110 MARVIN 10 1 $ 3,000.00 00-120 CUSHNER 10 1 $ 1,450.00 00-125 GARNER 10 2 $ 13.50 00-135 ANDERSON 30 1 $ 2,100.00 00-140 ROTH 30 2 $ 8.50 00-145 NORRIS 10 1 $ 850.00 00-150 HIRSCH 30 1 $ 800.00 00-156 HOBART 10 2 $ 9.25 00-180 HASKINS 30 2 $ 12.00 00-203 FOSTER 30 1 $ 2,000.00 Press <RETURN> to continue or <PF3> to cancel....

Finish previewing the report and press [Return] until the REPORT GENERATION MENU is displayed.

Then, choose the option, "RETURN without Printing". The [TOP] REPORT DEFINITION MENU will be displayed.

Contents

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

3.3.4 Generate the Report

3.3.5 Select Additional Fields

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