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

Now use the DELETE option to remove the entry line which contains the text, "Data Definition (PRSPAY)".

Lastly, use the INSERT option to enter the date, $DATE with mask, "MM/DD/YYYY" on header line 4 and centered. The resulting screen should look similar to the following: 


_________________________________________________________________________________________________ 
|                                                                                               | 
| Rpw: REPORT5            REPORT DEFINITION MODIFICATION     View: PRSPAY                       |          
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:...90....:| 
|===============================================================================================| 
|HH:MN XM                                     REPORT5                                 PAGE 9999 | 
|                                         Lesson 5 Report                                       |                    
|                                           MM/DD/YYYY                                          |    
|===============================================================================================| 
|                                                                                               |   
|                                                                                               |  
| Pg Hdr Entries: 8           PAGE HEADER FORMATTING                                            |   
|               Text                    Field            Mask       Lin Jst  Col                |  
|                                                                                               | 
|   4  PAGE                                                          2  RHT  127                |  
|   5                                 $PAGE                          2  LFT  129                | 
|   6  Lesson 5 Report                                               3  CTR                     |  
|   7                                 $DATE          MM/DD/YYYY      4  CTR                     |  
|   8                                 $BAR                           5  LFT    1                |  
|                                                                                               | 
| PAGE 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                                                                               | 
|_______________________________________________________________________________________________|

3.8.3 Format Column DETAIL

The FORMAT MENU should be displayed on your screen. You may need to press the FINISH key [PF4] first.

In this section you will capture the default column detail display as shown on the next screen and make some minor changes: 


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

The column detail forms the body of the report, allowing you to print column headers and the contents of fields or text. There are two types of columnar reports that may be created. Those that:

  1. Print ALL the Detail Records
  2. SUMMARIZE the Detail Records

This means that you can either print all of the detail, or omit some of the detail and just print summary subtotals or totals for similar detail lines. The column format details, used in conjunction with an output parameter labeled "Summary Report", determine the type of column detail that will print.

First highlight and then select the "Column DETAIL" option. A screen similar to the following will appear. 


 
_________________________________________________________________________________________ 
|  Rpw: REPORT5              REPORT DEFINITION MODIFICATION          View: PRSPAY       | 
|                                                                                       | 
|=======================================================================================| 
|HH:MN XM                                     REPORT5                         PAGE 9999 | 
|                                         Lesson 5 Report                               |                    
|                                           MM/DD/YYYY                                  |  
|=======================================================================================| 
|EMPLOYEE #  LASTNAME         DEPT. #  WAGE CLASS       SALARY   CA_RAISE  CA_NEW_SALARY| 
|**********  ***************  *******  **********  ***********  *********  *************| 
|                                                                                       | 
|    00-000  XXXXXXXXXXXXXXX     9999           9  $999,999.99  $9,999.99    $999,999.99| 
|                                               9  $999,999.99  $9,999.99    $999,999.99| 
|                                               9  $999,999.99  $9,999.99    $999,999.99| 
|         мсссссссссссссссссссссссссссссссссссссссссссссссссссссссссссл                 | 
|         ш    Formatting the Column Detail through any of the menu   ш                 | 
|         ш    options below DISABLES automatic formatting in         ш                 | 
|         ш    Field Selection and Calculated Fields...               ш                 | 
|         нссссссссссссссссссссссссссссссссссссссссссссссссссссссссссск                 | 
|                                                                                       | 
| DEFINE COLUMN DET                                       <PF3> cancel                  | 
|                                                                                       | 
|     DEFAULT Column Detail                                       CANCEL                | 
|     USER-DEFINED Column Detail                                  TOP                   | 
|     LOAD Column Detail from existing Def                                              | 
|_______________________________________________________________________________________|

Note
If the Column Detail Menu has been accessed previously, the above warning will not appear and you will go directly to the menu shown below.

ReportWriter gives you the option of capturing the "DEFAULT" column detail, defining your own, or loading the column detail from an existing definition.

For this section, you will capture and then modify the default column detail. Specifically, you will delete DEPT # from the detail display (as you will move it to the Group Header later) and change several column headings.

Note that for the field, CUR_SALARY, the type value is "TOT". This value was set when you used the "TOTAL this Report" option in Part I.

Select the "DEFAULT Column Detail" option. The following, COLUMN DETAIL FORMATTING screen will appear. 


 
_________________________________________________________________________________________ 
|                                                                                       | 
| Rpw: REPORT5            REPORT DEFINITION MODIFICATION     View: PRSPAY               | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..| 
|EMPLOYEE #  LASTNAME         DEPT. #  WAGE CLASS       SALARY   CA_RAISE  CA_NEW_SALARY| 
|**********  ***************  *******  **********  ***********  *********  *************| 
|                                                                                       | 
|    00-000  XXXXXXXXXXXXXXX     9999           9  $999,999.99  $9,999.99    $999,999.99| 
|                                                                                       | 
| Detail Entries: 7          COLUMN DETAIL FORMATTING        Line: 1 Cols: 87           | 
|        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 DEPTNO         VAL                           DEPT. #/*        1 RHT  36           | 
|   4 WAGE_CLS       VAL                           WAGE CLASS/*     1 RHT  48           | 
|   5 CUR_SALARY     TOT $999,999.99               SALARY/*         1 RHT  61           | 
|                                                                                       | 
| COLUMN DETAIL 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                                                                       | 
|_______________________________________________________________________________________|

Note that the top window displays the default column format. The middle window contains the individual details associated with each column detail entry. These are explained next:
Detail Description
Field allows you to specify a field, an internal function or a synonym for which a value will be printed in the column detail section.
Typ determines how the field identified is to be printed; ie. as its current value (VAL), a total (TOT), an average (AVE), a count (CNT), the minimum value (MIN), or the maximum value (MAX).
Mask allows you to enter a mask which is used to format the data display to include special characters such as a dollar sign, commas, slashes, etc.
Text allows you to specify text to be printed.
Column Hdr allows you to enter a header for the field being formatted.
Lin indicates the column detail line (1 thur 99) on which you want the text or field referenced to be placed.
Jst indentifies how you would like the text of field referenced to be justified. The following options are available:
LFT (left) Causes the data to START at a given column.
RHT (right) Causes the data to STOP at a given column.
CTR (center) Causes the data to be CENTERED on the line (based on the width of the report).
WRP (wrap) Causes the data to be WRAPPED. The column at which the wrap will occur is indicated by the number entered at the "Wrap" prompt.
Col identifies the column at which the text or data will print.
Wrp indicates the column at which the data will be wrapped.

Note from the above screen the current details for field 1, EMPNO. The current value of this field will be printed in the format of 00-000. The column heading, EMPLOYEE #/* indicates that the field heading will be EMPLOYEE # underlined with a line of "*"'s. This field value will be placed on detail line 1 with the value ending in column 10.

Also, note the use of the "/" symbol in the column heading lines. Suppose you wanted a column heading to be: "Appropriation Account", but with "Appropriation" on one line and "Account" below it on the next line. In RPW you would enter the header: Appropriation/Account - to achieve this.

If you wanted to place a header (such as "Amount") on line two and leave the space above it blank, you would use the following: /Amount.

Sample Masks

You may need to enter or to change a mask for some of the reports you create. When defining calculated fields, you will be required to enter a mask. As noted earlier, the type of mask depends on the type of field being used. The following gives some examples:

NUMERIC:
Data Mask Output
155 999.99 155.00
1.5 990.00 1.50
555 00000 00555
123.95 $***99V99 $**123.95
4184.16 $9,999,999.99 $ 4,184.16
4184.16 $$,$$$,$$9.99 $4,184.16
123003216 000--00--0000 123--00--3216
303 \(000\) (303)
NEGATIVES
-48.54 -48.54
-48.54 99.99- 48.54-
-48.54 <99.99> <48.54>
-48.54 (99.99) (48.54)
48.54 (99.99) 48.54
ROUNDING
12345 9999/ 1235 (round up)
12345 9999^ 12350 (round up to 0)
123.45 999.9^ 123.50 (round up to 0)

Note that a "\" in a mask means that the next character is to be taken literally.

Also note that using a 0, means that something will be printed for that position. If there is no data, then a 0 will be printed. This is useful for printing numeric fields which might contain no data for some of the records. For example, suppose that the mask is $99,990.00. For a record with no data in that field, the following would still be printed: $ 0.00

ALPHA:
Data Mask Output
03321 XXXXX 03321
ABCDEFG XXX/XX-XX ABC/DE-FG
Nov 1990 E\XPIRED:XXXXXXXXX EXPIRED:Nov 1990
GA0123AB [3:6] 0123

Note that the mask characters, "/" and "-" are printed as a part of the data. Again, the "\" character indicates that the following character is to be considered a literal. In the mask, "E\XPIRED:XXXXXXXXX" used above, the "\X" indicates that this is the letter X, and not the mask for an alphanumeric character. Also, the alphanumeric mask character "X" must be capitalized.

The mask [#:#] indicates the first and last characters to be printed from a string. So in the above example for [3:6], the third through the sixth character will be printed.

DATES:
Data Mask Output
061596 MM 06
061596 MMM JUN
061596 MON June
061596 DD 15
061596 YY 96
061596 YYYY 1996
061596 DD-MMM-YY 15-JUN-96
061596 MON DD,YYYY June 15,1996
061596 MM/DD/YY 06/15/96

Output Error Symbols
??? Missing data; no data.
<<< Mask too small; inappropriate for datatype specified.
!!!! Illegal mask; incorrect syntax.
%%% Exceeded specified page width.
@@@ Bad data.
**** Negative value in a positive mask.

Delete the Field DEPTNO

You are to start the formatting by deleting the field DEPTNO from the report. Select the "DELETE an Entry" option in the current screen. A screen similar to the following will appear. 


 
_________________________________________________________________________________________ 
|                                                                                       | 
| Rpw: REPORT5           REPORT DEFINITION MODIFICATION     View: PRSPAY                | 
|....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:..| 
|EMPLOYEE #  LASTNAME         DEPT. #  WAGE CLASS       SALARY   CA_RAISE  CA_NEW_SALARY| 
|**********  ***************  *******  **********  ***********  *********  *************| 
|                                                                                       | 
|    00-000  XXXXXXXXXXXXXXX     9999           9  $999,999.99  $9,999.99    $999,999.99| 
|                                                                                       | 
|                                                                                       | 
|                                                                                       | 
| Detail Entries: 7          COLUMN DETAIL FORMATTING        Line: 1 Cols: 89           | 
|        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 DEPTNO <=====  VAL                           DEPT. #/*        1 RHT  36           | 
|   4 WAGE_CLS       VAL                           WAGE CLASS/*     1 RHT  48           | 
|   5 CUR_SALARY     TOT $999,999.99               SALARY/*         1 RHT  61           | 
|                                                                                       | 
| DELETE               <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 DELETION.                                      | 
|_______________________________________________________________________________________|

The cursor should now be in the middle window, prompting you to select an entry for deletion. Use the [Down Arrorw] key to move the cursor to the line for DEPTNO, the press the [Return] key to select it for deletion. You will be asked to confirm your selection for deletion. Highlight the "YES" prompt and press RETURN to accept it.

ReportWriter will now return with the prompt, "Do you want to AUTOMATICALLY adjust the columns?" Highlight and select the "YES" option. This will cause ReportWriter to shift the remaining formatted columns to the left. The screen should now 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| 
|                                                                                | 
|   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    | 
|                                                                                | 
| DELETE               <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 DELETION.                               | 
|________________________________________________________________________________|

Since you are finished with deleting fields, press the [PF4] key. This will take you out of the DELETE mode and return you to the COLUMN DETAIL MENU 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| 
|                                                                                | 
|   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    | 
|                                                                                | 
| COLUMN DETAIL 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                                                                | 
|________________________________________________________________________________|

Previous Next Contents