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

Change Column Headings

For the next part of this lesson you are to change the column headers for the two fields as follows:
Old Header New header
CA_RAISE RAISE
CA_NEW_SALARY NEW SALARY

Highlight and select the "CHANGE an Entry" option on the current screen. The following screen should appear with the cursor in the middle window prompting you to select an entry for CHANGE. 


 
__________________________________________________________________________________ 
|                                                                                | 
| Rpw: REPORT5            REPORT DEFINITION MODIFICATION     View: PRSPAY        | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80| 
|EMPLOYEE #  LASTNAME         WAGE CLASS       SALARY   CA_RAISE    CA_NEW_SALARY| 
|**********  ***************  **********  ***********  *********    *************| 
|                                                                                | 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99      $999,999.99| 
|                                                                                | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
| Detail Entries: 6          COLUMN DETAIL FORMATTING        Line: 1 Cols: 80    | 
|        Field       Typ   Mask        Text         Column Hdr    Lin Jst Col Wrp| 
|                                                                                | 
|   1 EMPNO          VAL 00-000                    EMPLOYEE #/*     1 RHT  10    | 
|   2 LASTNAME       VAL                           LASTNAME/*       1 LFT  13    | 
|   3 WAGE_CLS       VAL                           WAGE CLASS/*     1 RHT  39    | 
|   4 CUR_SALARY     TOT $999,999.99               SALARY/*         1 RHT  52    | 
|   5 CA_RAISE       TOT $9,999.99                 CA_RAISE/*       1 RHT  63    | 
|                                                                                | 
| CHANGE/STD           <PF1> next                                 <PF4> finished | 
|                                                                                | 
| Highlight the desired ENTRY by use of the <arrow> keys or by entering the      | 
| ENTRY-Number followed by <return>.                                             | 
|                                                                                | 
| Press <return> to select the ENTRY for CHANGE.                                 | 
|________________________________________________________________________________|

Move the cursor to the line with field CA_RAISE, and press the [Return] key to open this line. Then press the [Right Arrow] several times to move the cursor to the "Column Hdr" position as shown next. 


__________________________________________________________________________________ 
|                                                                                | 
| Rpw: REPORT5            REPORT DEFINITION MODIFICATION     View: PRSPAY        | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80| 
|EMPLOYEE #  LASTNAME         WAGE CLASS       SALARY   CA_RAISE    CA_NEW_SALARY| 
|**********  ***************  **********  ***********  *********    *************| 
|                                                                                | 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99      $999,999.99| 
|                                                                                | 
|                                                                                | 
|                                                                                | 
| Detail Entries: 6          COLUMN DETAIL FORMATTING        Line: 1 Cols: 80    | 
|        Field       Typ   Mask        Text         Column Hdr    Lin Jst Col Wrp| 
|                                                                                | 
|   2 LASTNAME       VAL                           LASTNAME/*       1 LFT  13    | 
|   3 WAGE_CLS       VAL                           WAGE CLASS/*     1 RHT  39    | 
|   4 CUR_SALARY     TOT $999,999.99               SALARY/*         1 RHT  52    | 
|   5 CA_RAISE   ====>    ====>              ====> CA_RAISE/*       1 RHT  63    | 
|   6 CA_NEW_SALARY  TOT $999,999.99               CA_NEW_SALA...   1 RHT  80    |  
|                                                                                | 
| CHANGE/STD                          <PF2> help    <PF3> cancel                 | 
|________________________________________________________________________________|

Press the [Return] key to open the "Column Hdr" detail. Then type in the following: RAISE/* , and then press [Return] to accept this change. The screen should look like the following. 


__________________________________________________________________________________ 
|                                                                                | 
| Rpw: REPORT5            REPORT DEFINITION MODIFICATION     View: PRSPAY        | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80| 
|EMPLOYEE #  LASTNAME         WAGE CLASS       SALARY   CA_RAISE    CA_NEW_SALARY| 
|**********  ***************  **********  ***********  *********    *************| 
|                                                                                | 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99      $999,999.99| 
|                                                                                | 
|                                                                                | 
|                                                                                | 
| Detail Entries: 6          COLUMN DETAIL FORMATTING        Line: 1 Cols: 80    | 
|        Field       Typ   Mask        Text         Column Hdr    Lin Jst Col Wrp| 
|                                                                                | 
|   2 LASTNAME       VAL                           LASTNAME/*       1 LFT  13    | 
|   3 WAGE_CLS       VAL                           WAGE CLASS/*     1 RHT  39    | 
|   4 CUR_SALARY     TOT $999,999.99               SALARY/*         1 RHT  52    | 
|   5 CA_RAISE       TOT $9,999.99                 RAISE/*          1 RHT  63    |  
|   6 CA_NEW_SALARY  TOT $999,999.99               CA_NEW_SALA...   1 RHT  80    |  
|                                                                                | 
| CHANGE/STD                          <PF2> help    <PF3> cancel                 | 
|________________________________________________________________________________|

Here is the sequence of steps to be used in making a change in any detail line:

  1. Select the CHANGE option.
  2. Move the cursor to the desired line.
  3. Press the [Return] key to "open" the line for change.
  4. Use the [Right Arrow] key to position the cursor on the correct detail element.
  5. Press the [Return] key to "open" the detail element for change.
  6. Enter the new value, and press the [Return] key to "close" the detail element.
  7. Press the [PF4] key when finished with the line.
  8. You are now in a position to either move to another line and repeat the above steps for another change, or to press the [PF4] key again to indicate that you have finished making changes for the time being.

These same steps will be used when making changes to detail lines in any of the ReportWriter modules.

Press the [PF4] key to indicate that you have finished with the current detail line. The following screen should appear. 


 
__________________________________________________________________________________ 
|                                                                                | 
| Rpw: REPORT5            REPORT DEFINITION MODIFICATION     View: PRSPAY        | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80| 
|EMPLOYEE #  LASTNAME         WAGE CLASS       SALARY      RAISE    CA_NEW_SALARY| 
|**********  ***************  **********  ***********  *********    *************| 
|                                                                                | 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99      $999,999.99| 
|                                                                                | 
|                                                                                | 
|                                                                                |  
| Detail Entries: 6          COLUMN DETAIL FORMATTING        Line: 1 Cols: 80    | 
|        Field       Typ   Mask        Text         Column Hdr    Lin Jst Col Wrp| 
|                                                                                |  
|   2 LASTNAME       VAL                           LASTNAME/*       1 LFT  13    | 
|   3 WAGE_CLS       VAL                           WAGE CLASS/*     1 RHT  39    | 
|   4 CUR_SALARY     TOT $999,999.99               SALARY/*         1 RHT  52    | 
|   5 CA_RAISE       TOT $9,999.99                 RAISE/*          1 RHT  63    | 
|   6 CA_NEW_SALARY  TOT $999,999.99               CA_NEW_SALA...   1 RHT  80    | 
|                                                                                | 
| CHANGE/STD           <PF1> next                                 <PF4> finished | 
|                                                                                | 
| Highlight the desired ENTRY by use of the <arrow> keys or by entering the      | 
| ENTRY-Number followed by <return>.                                             | 
|                                                                                | 
| Press <return> to select the ENTRY for CHANGE.                                 | 
|________________________________________________________________________________|

Notice that the top window now shows the new column header for the CA_RAISE field.

Using these same techniques, do the following steps in order to change the header for the field CA_NEW_SALARY. Note that you are still in the change mode.

  1. Change the header for the CA_NEW_SALARY field to resemble:
    NEW SALARY
    *************
  2. Change the "Col" detail value to 76.
  3. Press [PF4] to close the entry for CA_NEW_SALARY.

Your screen should look similar to the following: 


 
__________________________________________________________________________________ 
|                                                                                | 
| Rpw: REPORT5            REPORT DEFINITION MODIFICATION     View: PRSPAY        | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80| 
|EMPLOYEE #  LASTNAME         WAGE CLASS       SALARY      RAISE   NEW SALARY    |                                                
|**********  ***************  **********  ***********  *********  ***********    |                                                
|                                                                                | 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99  $999,999.99    | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
| Detail Entries: 6          COLUMN DETAIL FORMATTING        Line: 1 Cols: 76    | 
|        Field       Typ   Mask        Text         Column Hdr    Lin Jst Col Wrp| 
|                                                                                | 
|   2 LASTNAME       VAL                           LASTNAME/*       1 LFT  13    | 
|   3 WAGE_CLS       VAL                           WAGE CLASS/*     1 RHT  39    | 
|   4 CUR_SALARY     TOT $999,999.99               SALARY/*         1 RHT  52    | 
|   5 CA_RAISE       TOT $9,999.99                 RAISE/*          1 RHT  63    | 
|   6 CA_NEW_SALARY  TOT $999,999.99               NEW SALARY/*     1 RHT  76    | 
|                                                                                | 
| CHANGE/STD           <PF1> next                                 <PF4> finished | 
|                                                                                |  
| Highlight the desired ENTRY by use of the <arrow> keys or by entering the      |  
| ENTRY-Number followed by <return>.                                             | 
|                                                                                | 
| Press <return> to select the ENTRY for CHANGE.                                 | 
|________________________________________________________________________________|

Press the [PF4] to finish out and return to the FORMAT MENU screen. You will see a screen similar to the following. 


 
 
_________________________________________________________________________________________ 
|  Rpw: REPORT5              REPORT DEFINITION MODIFICATION          View: PRSPAY       | 
|                                                                                       | 
|=======================================================================================| 
|HH:MN XM                                     REPORT5                         PAGE 9999 | 
|                                         Lesson 5 Report                               |                    
|                                           MM/DD/YYYY                                  |  
|=======================================================================================| 
|EMPLOYEE #  LASTNAME         WAGE CLASS       SALARY      RAISE   NEW SALARY           |      
|**********  ***************  **********  ***********  *********  ***********           |      
|                                                                                       |     
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99  $999,999.99           |    
|                                                  $999,999.99  $9,999.99    $999,999.99|      
|                                                  $999,999.99  $9,999.99    $999,999.99|     
|                                                                                       |   
|                                                                                       |      
|                                                                                       |       
|                                                                                       | 
| FORMAT MENU                                                     <PF4> finished        |      
|                                                                                       |      
| Page   HEADER           Page   FOOTER         EXAMINE Format        FINISHED          |     
| Column DETAIL           Report TITLE                                                  |      
| Report GROUPS           Report TRAILER                                                |      
|_______________________________________________________________________________________|

Unfortunately you have created a small formatting problem when the field DEPTNO was deleted. Changes in each formatting section are independent of changes made in a different formatting section. As a result, the TOTAL's for the group trailer and the report trailer were not adjusted. This can be fixed when you access the group trailer formatting menu and the report trailer formatting menu.

3.8.4 Format Report GROUPS

In UDMS the grouping together of a set of records with a common field value is called a "Report GROUP". Report groups are permitted to have a Group HEADER and/or a Group FOOTER with a summary of field values in the FOOTER if desired.

This is one of the more interesting parts of this lesson, but also a bit more involved. Recall that the report was set up to sort first on the DEPTNO field, and second on the LASTNAME field. When you ran the "TOTAL this Rpt" option, UDMS automatically created a report group using the primary sort field, DEPTNO, as the break field.

What you want to do next is to create a header for this report group and then go to the report trailer to print some text indicating the subtotals for the three fields CUR_SALARY, CA_RAISE, and CA_NEW_SALARY each time the DEPTNO changes value.

3.8.4.1 Format Group Header


Instead of printing the DEPTNO with each detail record as was done in lesson 4, you will print it only once at the beginning of each new Department Number group. Select the option to format "Report Groups".

As shown on the GROUP MENU displayed next, there are two options: that of "Group HEADER" and "Group TRAILER". 


 
__________________________________________________________________________________ 
|                                                                                | 
|  GROUP MENU                                               <PF4>  finished      | 
|                                                                                | 
|     Format Group HEADER  <=====                           FINISHED             | 
|     Format Group TRAILER                                  TOP                  | 
|________________________________________________________________________________|

A group header is printed before a group begins and can include the contents of a field and/or text.

A group trailer may include the value, total, average, minimium, maximum, or count of a field and/or text. In addition, user-defined calculations can be printed, variable assignments defined, expressions entered and values zeroed. The trailer is printed at the end of a group.

Select the "Format Group HEADER" option.

ReportWriter gives you the option of capturing the DEFAULT Group Header, defining your own, or loading one from an existing definition as shown next. 


 
__________________________________________________________________________________ 
|                                                                                | 
| DEFINE GRP HEADER                                 <PF3> cancel                 | 
|                                                                                | 
|     DEFAULT Group Header  <====                           CANCEL               | 
|     USER-DEFINED Group Header                             TOP                  | 
|     LOAD Group Header from existing Def                                        | 
|                                                                                | 
|________________________________________________________________________________|

Select the "DEFAULT Group Header" option as indicated above. The following GROUP HEADER MENU screen will now appear. Notice that by selecting the DEFAULT Group Header option, ReportWriter has already put a default group header in place. RPW uses the primary sort field, DEPTNO, for the break field and will print the text, "DEPT #" followed by a department number value each time the DEPTNO value changes. This data will be printed as a heading before the rest of the data is printed. 


__________________________________________________________________________________ 
|                                                                                | 
| Rpw: REPORT5            REPORT DEFINITION MODIFICATION     View: PRSPAY        | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80| 
|DEPT. #: 9999                                                                   | 
|    00-000  XXXXXXXXXXXXXXX           9  $999,999.99  $9,999.99  $999,999.99    | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
| Grp Hdr Entries: 2         GROUP HEADER FORMATTING                             | 
|      Break Field    Lin  Field          Mask             Text           Jst Col| 
|                                                                                | 
|   1 DEPTNO           1                               DEPT. #:           LFT   1| 
|   2 DEPTNO           1  DEPTNO                                          LFT  10| 
|                                                                                | 
|                                                                                | 
|                                                                                | 
|                                                                                | 
| GROUP HEADER 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                                                                | 
|________________________________________________________________________________|

Notice that both of the group header entries defined above will be printed on the same group header line, even though it took two entry lines to define them. These entries were automatically created by UDMS when you selected to use the Default Group Header.

You have the option of modifying, deleting, or adding additional group headers. The following table gives more information about the various group header details.
Detail Description
Break Field defines which group of data is to be used as the basis for the group header. This must be one of the predefined sort fields.
Lin indicates the group header line on which you want the text or field referenced to be placed. Each section, such as page header, group header, group trailer, page footer, or report footer have a distinct numbering system which is independent of the report text line numbers. For example, the page header has lines 1,2,3,... while the group header also has lines 1,2,3,...
Field allows you to print the value of a field, an internal function or synonym in the group header.
Mask allows you to enter a mask which is used to format the data display to include special figures such as a dollar sign, commas, slashes, etc.
Text allows you to specify text to print in the group header.
Jst identifies how you would like the text of field to be justified.
Col identifies the columnar placement for text or data.

Note
Only designated sort fields may be used as "break" fields. If no sort fields have been chosen, ReportWriter would have given you the opportunity to define them at this point.

Previous Next Contents