Type in the command, GEN PRE in order to see the results of totalling for a report group and the whole report.

Processsing will begin, and the following screen should appear which will ask you to enter some value for the "Highest Department Number to Process".

_________________________________________________________________________________________ | | | Rpw: REPORT5 REPORT GENERATION View: PRSPAY | | | | Enter the highest Department Number to Process: 40 <==== | | | |_______________________________________________________________________________________|

Enter the value 40 and press the [Return] key. A report, similar to the following, should appear on your screen.

======================================================================================= 16-APR-97 03:19 PM REPORT5 PAGE 1 Lesson 5 Report Data definition (PRSPAY) ======================================================================================= EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY ********** *************** ******* ********** *********** ********* ************* 00-120 CUSHNER 10 1 $ 1,450.00 $ 101.50 $ 1,551.50 00-110 MARVIN 10 1 $ 3,000.00 $ 210.00 $ 3,210.00 00-145 NORRIS 10 1 $ 850.00 $ 59.50 $ 909.50 $ 5,300.00 $ 371.00 $ 5,671.00 00-105 NOLL 20 1 $ 4,500.00 $ 270.00 $ 4,770.00 00-209 WESSELLER 20 1 $ 1,500.00 $ 90.00 $ 1,590.00 $ 6,000.00 $ 360.00 $ 6,360.00 00-135 ANDERSON 30 1 $ 2,100.00 $ 126.00 $ 2,226.00 00-245 BUCHANAN 30 1 $ 2,100.00 $ 126.00 $ 2,226.00 00-203 FOSTER 30 1 $ 2,000.00 $ 120.00 $ 2,120.00 00-150 HIRSCH 30 1 $ 800.00 $ 48.00 $ 848.00 00-235 WANDERSEEN 30 1 $ 1,000.00 $ 60.00 $ 1,060.00 $ 8,000.00 $ 480.00 $ 8,480.00 00-215 CONVEY 40 1 $ 1,250.00 $ 75.00 $ 1,325.00 00-205 GONZOLES 40 1 $ 1,250.00 $ 75.00 $ 1,325.00 $ 2,500.00 $ 150.00 $ 2,650.00 $ 21,800.00 $1,361.00 $ 23,161.00

3.7.5 Results of Using the TOTAL Option

Note that using the "TOTAL this Report" option has enhanced the report in the following ways.

1. Created a report group with DEPTNO as the break field and generated subtotals. However, no group header was added nor text for the subtotals.
2. Created totals at the end of the report for a group trailer. However no text for these totals was added.
3. If you had chosen the option for page totals, these would have appeared at the bottom of each page as a page footer, but again with no text.

In the next part you will learn how to use the Format Options to add text to the totals and much more.

3.8 Lesson 5 - PART II Formatting a Report

You will continue with REPORT5 for the formatting lesson as it exists after using the "TOTALS This Report" option.

You should be at the following menu.

========================================================================================== |DD-MMM-YY HH:MN XM REPORT5 PAGE 9999 | | Lesson 5 Report | | Data definition (PRSPAY) | |========================================================================================| |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 | | | | | | | | | | | | 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.8.1 Formatting Options

Highlight and select the "FORMAT this Rpt " option. This brings up the FORMAT MENU as shown next.

_________________________________________________________________________________________ | | | Rpw: REPORT5 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |=======================================================================================| |DD-MMM-YY HH:MN XM REPORT5 PAGE 9999| | Lesson 5 Report | | Data definition (PRSPAY) | |=======================================================================================| |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 format options - Page HEADER, Column DETAIL, Report GROUPS, Page FOOTER, Report TITLE, Report TRAILER - allow you to customize your report by identifying what will print at the top or bottom of each page, the information to be printed from each record or group records, the data to be totalled, and a report summary.

ReportWriter divides the report into a number of format sections. Within the format sections, ReportWriter provides several methods for defining your report layout. You may do any of the following:

• Accept the default provided for any section.
• Expand the default(s) by editing.
• Load and optionally edit any given format from another definition.
• Format any section from scratch.

The report can be divided into the following format sections:

Format Option	Description
Page HEADER	determines what is to be printed at the top of each page.
Column DETAIL	forms the body of the report and includes column headers and the contents of fields or a summary on designated fields. The format may be either of a columnar type (one line of data per record) or of a block type (several lines per record, with or without field names included.)
Report GROUPS	allow you to print GROUP HEADERS and TRAILERS (automatic sub-totals, averages, minimums, maximums as well as user defined calculations) on a pre-determined group of data.
Page FOOTER	determines what is to be printed at the bottom of each page. May include automatic totals, averages, counts, minimums, maximums, or field values.
Report TITLE	allows you to create a TITLE page that prints before the actual page 1 of the report.
Report TRAILER	determines what is to be printed at the end of the report and may include automatic totals, averages, counts, minimums, maximums, field values or text, in addition to user defined calculations.

The sample below shows the relationship between each format section and the report page.

================================================================================ Page 16-DEC-96 10:09 AM SALARY BUDGET PROJECTIONS PAGE 1 Header ====> PER DEPARTMENT ================================================================================ Column Header EMPLOYEE # LASTNAME WAGE CLASS SALARY RAISE PROJ. SALARY ===> ********** *************** ********** *********** ********* ************ Group Header DEPT: 10 ===> Column 00-120 CUSHNER 1 $ 1,450.00 $ 101.50 $ 1,551.50 Detail 00-110 MARVIN 1 $ 3,000.00 $ 210.00 $ 3,210.00 ===> 00-145 NORRIS 1 $ 850.00 $ 59.50 $ 909.50 Group Trailer ===> DEPT. TOTALS: $ 5,300.00 $ 371.00 $ 5,671.00 DEPT: 20 00-105 NOLL 1 $ 4,500.00 $ 270.00 $ 4,770.00 00-209 WESSELLER 1 $ 1,500.00 $ 90.00 $ 1,590.00 DEPT. TOTALS: $ 6,000.00 $ 360.00 $ 6,360.00 Page Footer ===> PAGE TOTALS: $ 11,300.00 $ 731.00 $ 12,031.00 -------------------------------------------------------------------------------- Report Trailer ===> REPORT TOTALS: $ 27,900.00 $ 5,422.00 $ 33,322.00

Additionally, a report TITLE page may be formatted, causing a page to print at the beginning of the report prior to page 1. The default report TITLE is shown next:

lol ************************************************************ lol lol lol lol lol lol Report Name: EMPLST lol lol lol lol Report Description: List of Employees lol lol lol lol Date Generated: 30-Mar-1997 lol lol lol lol Time Generated: 10:20 AM lol lol lol lol Generated By: HHD lol lol lol lol Data Definition: PRSPAY lol lol lol lol ************************************************************ lol

3.8.2 Format Page HEADER

_________________________________________________________________________________________ | | | Rpw: REPORT5 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |=======================================================================================| |DD-MMM-YY HH:MN XM REPORT5 PAGE 9999| | Lesson 5 Report | | Data definition (PRSPAY) | |=======================================================================================| |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| | мсссссссссссссссссссссссссссссссссссссссссссссссссссссссссссл | | ш Formatting the Page Header through any of the menu ш | | ш options below DISABLES automatic Page Header ш | | ш reformatting. ш | | нссссссссссссссссссссссссссссссссссссссссссссссссссссссссссск | | | | DEFINE PAGE HEADER <PF3> cancel | | | | DEFAULT Page Header CANCEL | | USER-DEFINED Page Header TOP | | LOAD Page Header from existing Def | |_______________________________________________________________________________________|

Note the warning in the pop-out window. What this means is that if NONE of these options are chosen, ReportWriter will automatically adjust the page HEADER if/when changes in the page width occur. That is, if the page width is changed, then adjustments in the placing of items in the header (such as centering) will be made automatically. If you select any of the other options, then you will be responsible for making any necessary adjustments in the placement of header items if a change in page width occurs.

Select the DEFAULT Page Header option.

You should see a screen similar to the following:

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

The page header may include text, the contents of fields, internal functions (such as system date, time, page number, etc.) and/or synonyms (such as BAR_80 which creates an 80 character line of "=" at that point in the report). Synonyms are symbols which represent a more complex expression. They are defined at the system level by the Data Acquisition Site.

For your reference, a discussion of the page header details follows:

Detail	Description
Text	allows you to specify text to print in the page header.
Field	allows you to print the value of a field, an internal function or synonym in the page header. Internal functions used in the default header include the following: $BAR causes a pre-determined number of equal signs (=) to be printed across the page based on the current page width. $DATE causes the system date to be printed with a default mask of "DD-MMM-YY". $TIME causes the system time to be printed with a default mask of "HH:MN XM" $PAGE causes the page number to be printed with a default mask of "9999".
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.
Lin	indicates the page header line (1 thru 99) on which you want the text or field value to be placed.
Jst	indentifies how you would like the text of field value to be justified. The following justification 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 report width).
Col	identifies the column at which text or data will be placed.

Basically, the page HEADER entries define the placement of text and fields to be positioned at the top of every page.

Page Header Changes

For this section you are asked to make the following changes to the page header. First remove the Date from line 2 of the header by deleting header entry # 2. Next change the position of the Time field to column 1 of the same header line. Lastly, delete the entry "Data Definition (PRSPAY)" on header line 4, and replace it with the Date using the mask, MM/DD/YYYY on line 4, and center the date.

Note the page heading entries 1,2, and 3.

_________________________________________________________________________________________________ | | | Rpw: REPORT5 REPORT DEFINITION MODIFICATION View: PRSPAY | |....:...10....:...20....:...30....:...40....:...50....:...60....:...70....:...80....:...90....:| |===============================================================================================| |MM/DD/YY HH:MN XM REPORT5 PAGE 9999 | | Lesson 5 Report | | Data Definition (PRSPAY) | |===============================================================================================| | | | | | Pg Hdr Entries: 9 PAGE HEADER FORMATTING | | Text Field Mask Lin Jst Col | | | | 1 $BAR 1 LFT 1 | | 2 $DATE MM/DD/YY 2 LFT 1 | | 3 $TIME 2 LFT 12 | | 4 REPORT5 2 CTR | | 5 PAGE 2 RHT 127 | |_______________________________________________________________________________________________|

First select the DELETE option and remove the entry #2 which contains the $DATE value.

Next use the CHANGE option to change the position of $TIME to start in column 1 on header line 2. Your 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 | | Data Definition (PRSPAY) | |===============================================================================================| | | | | | Pg Hdr Entries: 8 PAGE HEADER FORMATTING | | Text Field Mask Lin Jst Col | | | | 1 $BAR 1 LFT 1 | | 2 $TIME 2 LFT 1 | | 3 REPORT5 2 CTR | | 4 PAGE 2 RHT 127 | | 5 $PAGE 2 LFT 129 | | | | INSERT <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 INSERT the new ENTRY. | |_______________________________________________________________________________________________|