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

3.8.4.2 Format Group TRAILER

Accept the default group header by pressing the [PF4] key. This will bring up the GROUP MENU. This time select the "Format Group TRAILER" option.

The following GROUP TRAILER MENU screen should appear: 


_________________________________________________________________________________________ 
|                                                                                       | 
|                                                                                       | 
| Rpw: REPORT5               REPORT DEFINITION MODIFICATION      View: PRSPAY           | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..| 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99  $999,999.99           | 
|                                                  $999,999.99  $9,999.99    $999,999.99| 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
| Grp Trl Entries: 3             GROUP TRAILER FORMATTING                               | 
|      Break Field  Lin Type Field           Mask       Text/Assign/Expr  Jst Col       | 
|                                                                                       | 
|   1 DEPTNO          1 TOT  CUR_SALARY      $999,99...                   RHT  61       | 
|   2 DEPTNO          1 TOT  CA_RAISE        $9,999.99                    RHT  72       | 
|   3 DEPTNO          1 TOT  CA_NEW_SALARY   $999,99...                   RHT  87       | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
| GROUP TRAILER MENU                                <PF3> cancel  <PF4> finished        | 
|                                                                                       | 
| ADD    an Entry               REVIEW  the Entries              CANCEL                 | 
| INSERT an Entry               CLEAR   all Entries              FINISHED               | 
| CHANGE an Entry               EXAMINE Format                   TOP                    | 
| DELETE an Entry                                                                       | 
|_______________________________________________________________________________________|

The top window displays the default group trailer which was created. The default is generated for the primary sort (break) field, DEPTNO. When the value of the DEPTNO field changes, ReportWriter will print the subtotal for the department on the next line under each variable. However, the positions of these totals needs to be adjusted slightly.

The middle window displays the entries for the default group trailer. The entries in this section will give you a total of the current salaries, raises, and new salaries within each department.

The individual details associated with each entry are described in the following table:
Detail Description
Break Field The field for which a group will be formed. This field must be specified as a valid sort field. When the data in this field changes, blank lines are inserted, and appropriate group trailer information is printed.
Lin Identifies the line in the group trailer on which the data is to be placed.
Type Several types are available, identifying how the data will be processed:
VAL use the current value of this data.
TXT print out the text entered in the "Text/Assign/Expr" detail.
TOT compute the total value of the data for this group.
MIN identify the minimum value of the data for this group.
MAX identify the maximum value of the data for this group.
AVE compute the average value of the data for this group.
CNT count the number of times the data was found in the group.
CNQ count the number of unique occurances of data in the group.
EXP indicates that an expression is to be entered in the "Text/Assign/Expr" detail and to output the value derived from the expression.
ZRO indicates that the data should be zeroed prior to processing the next group. The only other details that are valid with "ZRO" include Break, Line, and Field.
Field If the type specified is not "TXT" or "EXP", then this detail is prompted. The valid entries include:
  • a field from the report field list
  • a function
  • a synonym
  • a user defined variable assignment within the current format section.
Mask This detail is used to format the data display to include a dollar sign, commas, slashes, etc.
Txt/Assign/Exp This detail has multiple purposes based on the "Type" entered:
Type Text/Assign/Expr Useage
TXT Alphanumeric text (up to 60 characters) may be entered.
TOT MIN MAX AVE CNT CNQ An ASSIGNED VARIABLE NAME may be entered to place the computation in a user-defined variable. The name may contain up to 32 characters, letters, numbers and/or underscores. This variable is then available for use in subsequent expressions. See the "Format Report TRAILER" section for an example.
EXP A constant or expression (up to 60 characters) may be entered in the form of a numeric string, time stamp value, elapsed time variable, or alphanumeric string (enclosed in single quotes). Any valid arithmetic expression is valid.
Jst This detail is optional and indicates that the value of the group trailer item is to be printed.
Col Indicates the column at which the data or text will be placed. The maximum column number available is 999 but is controlled by the currently assigned Page Width.

Note
If the "Jst" and "Col" details are left blank, the data for that entry will not be printed.

Adjusting the TOTAL Fields

Currently the fields CUR_SALARY, CA_RAISE, and CA_NEW_SALARY are right justified at columns 52, 63, and 76 while the totals in the group trailer are right justified at columns 61, 72, and 87.

What you are to do next is to use the CHANGE option and change the column justifications for the totals to columns 52, 63, and 76.

Select the CHANGE option and set the cursor on line 1 as shown next. Then press the [RETURN] to open the line. 


_________________________________________________________________________________________ 
|                                                                                       | 
|                                                                                       | 
| Rpw: REPORT5               REPORT DEFINITION MODIFICATION      View: PRSPAY           | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..| 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99  $999,999.99           | 
|                                                  $999,999.99  $9,999.99    $999,999.99| 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
| Grp Trl Entries: 3             GROUP TRAILER FORMATTING                               | 
|      Break Field  Lin Type Field           Mask       Text/Assign/Expr    Jst Col     | 
|                                                                                       | 
|===> 1 DEPTNO          1 TOT  CUR_SALARY      $999,99...                   RHT  61     | 
|     2 DEPTNO          1 TOT  CA_RAISE        $9,999.99                    RHT  72     | 
|     3 DEPTNO          1 TOT  CA_NEW_SALARY   $999,99...                   RHT  87     | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
| CHANGE/STD         <PF1> next                                   <PF4> finished        | 
|                                                                                       | 
|_______________________________________________________________________________________|

Now use the right arrow key to move the cursor to the "Col" field, press the [RETURN] key to open the field, type the value 52, and then press [RETURN] again to close the field. Finally, press the [PF4] key to accept the change. The result should look similar to the following screen. 


_________________________________________________________________________________________ 
|                                                                                       | 
|                                                                                       | 
| Rpw: REPORT5               REPORT DEFINITION MODIFICATION      View: PRSPAY           | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..| 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99  $999,999.99           | 
|                                         $999,999.99           $9,999.99    $999,999.99| 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
| Grp Trl Entries: 3             GROUP TRAILER FORMATTING                               | 
|      Break Field  Lin Type Field           Mask       Text/Assign/Expr    Jst Col     | 
|                                                                                       | 
|     1 DEPTNO          1 TOT  CUR_SALARY      $999,99...                   RHT  52     | 
|     2 DEPTNO          1 TOT  CA_RAISE        $9,999.99                    RHT  72     | 
|     3 DEPTNO          1 TOT  CA_NEW_SALARY   $999,99...                   RHT  87     | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
| CHANGE/STD         <PF1> next                                   <PF4> finished        | 
|                                                                                       | 
|_______________________________________________________________________________________|

Now use the same procedure to change the column position for CA_RAISE to column 63 and for CA_NEW_SALARY to column 76. The resulting screen should be similar to the following. 


_________________________________________________________________________________________ 
|                                                                                       | 
|                                                                                       | 
| Rpw: REPORT5               REPORT DEFINITION MODIFICATION      View: PRSPAY           | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..| 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99  $999,999.99           | 
|                                         $999,999.99  $9,999.99  $999,999.99           | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
| Grp Trl Entries: 3             GROUP TRAILER FORMATTING                               | 
|      Break Field  Lin Type Field           Mask       Text/Assign/Expr    Jst Col     | 
|                                                                                       | 
|     1 DEPTNO          1 TOT  CUR_SALARY      $999,99...                   RHT  52     | 
|     2 DEPTNO          1 TOT  CA_RAISE        $9,999.99                    RHT  63     | 
|     3 DEPTNO          1 TOT  CA_NEW_SALARY   $999,99...                   RHT  76     | 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
| CHANGE/STD         <PF1> next                                   <PF4> finished        | 
|                                                                                       | 
|_______________________________________________________________________________________|

Press the [PF4] key to finish out.

Add Descriptive Text

To make the report more informative and to clarify the totals on the group trailer line, you are to add descriptive text to the group trailer. The text "DEPT. TOTALS" will be entered so that it is printed to the left of the subtotals on line 1 of the Group Trailer.

Select the "ADD an Entry" option on the GROUP TRAILER MENU. The following screen will appear with the cursor positioned in the middle window, prompting for the Break Field. 


 
__________________________________________________________________________________ 
|                                                                                | 
| Rpw: REPORT5            REPORT DEFINITION MODIFICATION     View: PRSPAY        | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80| 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99  $999,999.99    | 
|                                         $999,999.99  $9,999.99  $999,999.99    | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
| Grp Trl Entries: 3         GROUP TRAILER FORMATTING                            | 
|      Break Field  Lin Type Field           Mask       Text/Assign/Expr  Jst Col| 
|                                                                                | 
|   1 DEPTNO          1 TOT  CUR_SALARY      $999,99...                   RHT  52| 
|   2 DEPTNO          1 TOT  CA_RAISE        $9,999.99                    RHT  63| 
|   3 DEPTNO          1 TOT  CA_NEW_SALARY   $999,99...                   RHT  76| 
|   4 ___________... <=====                                                      | 
|                                                                                | 
|                                                                                | 
| ADD                                 <PF2> help                  <PF4> finished | 
|________________________________________________________________________________|

Enter DEPTNO for the Break Field value and press [Return] to advance to the next detail.

You will want the text to appear on the same physical line as the subtotals, so enter a 1 for the "Lin" detail. Then, since you are entering text, enter "TXT" as the type. The screen should be similar to the following: 


__________________________________________________________________________________ 
|                                                                                | 
| Grp Trl Entries: 3         GROUP TRAILER FORMATTING                            | 
|      Break Field  Lin Type Field           Mask       Text/Assign/Expr  Jst Col| 
|                                                                                | 
|   1 DEPTNO          1 TOT  CUR_SALARY      $999,99...                   RHT  52| 
|   2 DEPTNO          1 TOT  CA_RAISE        $9,999.99                    RHT  63| 
|   3 DEPTNO          1 TOT  CA_NEW_SALARY   $999,99...                   RHT  76| 
|   4 DEPTNO          1 TXT  <====                                               | 
|                                                                                | 
|                                                                                | 
| ADD                                 <PF2> help                  <PF4> finished | 
|________________________________________________________________________________|

Press [Return] to advance to the Text/Assign/Expr detail, and enter the text, justification and column values as shown in the next screen. 


___________________________________________________________________________________ 
|                                                                                 | 
| Grp Trl Entries: 3         GROUP TRAILER FORMATTING                             | 
|                                                                                 | 
|      Break Field  Lin Type Field           Mask       Text/Assign/Expr  Jst Col | 
|                                                                                 | 
|   1 DEPTNO          1 TOT  CUR_SALARY      $999,99...                   RHT  52 | 
|   2 DEPTNO          1 TOT  CA_RAISE        $9,999.99                    RHT  63 | 
|   3 DEPTNO          1 TOT  CA_NEW_SALARY   $999,99...                   RHT  76 | 
|   4 DEPTNO          1 TXT                             DEPT. TOTALS      LFT  25 | 
|                                                                                 | 
|                                                                                 | 
| ADD                                 <PF2> help    <PF3> cancel                  | 
|_________________________________________________________________________________|

Press the [Return] key to finish this entry line, and then press [PF4] to indicate that you have finished with the ADD option. This will bring up the following menu. Notice that the group trailer text, "DEPT. TOTALS" now appears in the top window. 


___________________________________________________________________________________ 
|                                                                                 | 
| Rpw: REPORT5            REPORT DEFINITION MODIFICATION     View: PRSPAY         | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80 | 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99  $999,999.99     | 
|                        DEPT. TOTALS     $999,999.99  $9,999.99  $999,999.99     | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
|                                                                                 | 
| Grp Trl Entries: 4         GROUP TRAILER FORMATTING                             | 
|      Break Field  Lin Type Field           Mask       Text/Assign/Expr  Jst Col | 
|                                                                                 | 
|   1 DEPTNO          1 TOT  CUR_SALARY      $999,99...                   RHT  52 | 
|   2 DEPTNO          1 TOT  CA_RAISE        $9,999.99                    RHT  63 | 
|   3 DEPTNO          1 TOT  CA_NEW_SALARY   $999,99...                   RHT  76 | 
|   4 DEPTNO          1 TXT                             DEPT. TOTALS      LFT  25 | 
|                                                                                 | 
|                                                                                 | 
| GROUP TRAILER MENU                                <PF3> cancel  <PF4> finished  | 
|                                                                                 | 
| ADD    an Entry               REVIEW  the Entries           CANCEL              | 
| INSERT an Entry               CLEAR   all Entries           FINISHED            | 
| CHANGE an Entry               EXAMINE Format                TOP                 | 
| DELETE an Entry                                                                 | 
|_________________________________________________________________________________|

Generate the Report

Select the [TOP] option to return to the TOP RPW MENU, as shown next. 


 
_________________________________________________________________________________________ 
|                                                                                       | 
| Rpw: REPORT5               REPORT DEFINITION MODIFICATION      View: PRSPAY           | 
|                                                                                       | 
|=======================================================================================| 
|HH:MN XM                                REPORT5                              PAGE 9999 | 
|                                    Lesson 5 Report                                    |                    
|                                       MM/DD/YYYY                                      |  
|=======================================================================================| 
|DEPT. #: 9999                                                                          | 
|EMPLOYEE #  LASTNAME         WAGE CLASS       SALARY      RAISE   NEW SALARY           | 
|**********  ***************  **********  ***********  *********  ***********           | 
|                                                                                       | 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99  $999,999.99           | 
|                        DEPT. TOTALS     $999,999.99  $9,999.99  $999,999.99           | 
|                                                  $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                                             | 
|_______________________________________________________________________________________|

At this point you are asked to PREVIEW the report as it now stands. You can go straight to the PREVIEW and bypass the OUTPUT PARAMETERS screen by typing in the value, GEN PRE, and pressing the [Return] key. The report process will begin and will prompt you for the "highest Department Number to Process:". Enter the value 40 as shown next. 


 
__________________________________________________________________________________ 
|                                                                                | 
|                                                                                | 
| Rpw: REPORT5                  REPORT GENERATION            View: PRSPAY        | 
|                                                                                | 
|Enter the highest Department Number to process: 40                              | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
| GENERATE                                          <PF3> cancel                 | 
|________________________________________________________________________________|

The first page of the report should be displayed on your terminal and should be similar to the following. Notice the addition of the group headers and group trailers. 


 
 
================================================================================ 
02:46 PM                            REPORT5                            PAGE    1 
                                Lesson 5 Report 
                                   15-JAN-97 
================================================================================ 
 
 
EMPLOYEE #  LASTNAME         WAGE CLASS       SALARY      RAISE   NEW SALARY 
**********  ***************  **********  ***********  *********  *********** 
 
 
DEPT. #:   10 
 
    00-120  CUSHNER                   1  $  1,450.00  $  101.50  $  1,551.50 
    00-110  MARVIN                    1  $  3,000.00  $  210.00  $  3,210.00 
    00-145  NORRIS                    1  $    850.00  $   59.50  $    909.50 
 
                        DEPT. TOTALS     $  5,300.00  $  371.00  $  5,671.00 
 
Press <RETURN> to continue or <PF3> to cancel...

Previous Next Contents