Child pages
  • RPTGNR - Report Generator

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Panel
Table of Contents

RPTGNR (Report Generator) will generate a report or a spreadsheet from any list maker file. These are the data files that are created with such programs as: USPSLM, USASLM, EISRPT/EIS601, SECRPT/SECM30, CEULM, or EMIS/EMIS_LM. To find out more about the individual list maker programs and their capabilities, please refer to the appropriate Software User's Manual.

When you generate a file from one of the list maker programs, use an extension of .DAT. This data file is then used as input to RPTGNR. The output from RPTGNR is either a printable text file and optionally a form file that can be used with the LSTPRC program, or it is a spreadsheet file again with the option to save a form file that can be used with the LSTPRC program.

If the output of RPTGNR is a text file, the user has the options:

To sort the report based on any token.
To control the order in which the fields will be printed on the
report.
To change the column widths of the fields.
To change the column headings.
To trim leading spaces.
To remove fields from the report.
To determine the case of the text (upper or lower).
To select to do a page break on the main sort field.
To select control breaks (header, footer, or both) on any sort
field.
To produce totals and subtotals on up to 10 numeric fields.
To change the number of columns between tab stops.

If the output of RPTGNR is a spreadsheet file, the user has the options:

To sort the spreadsheet based on any token.
To control the order in which the fields will appear on the
spreadsheet.
To change the column widths of the fields.
To change the column headings.
To trim leading spaces.
To remove fields from the spreadsheet.
To determine the case of the text (upper or lower).
To select the output type as follows:

HTML Table
border3
width75%
Table Row (tr)
Table Cell (td)


Table Cell (td)

DTIF

Table Cell (td)

DIGITAL Table Interchange Format

Table Row (tr)
Table Cell (td)


Table Cell (td)

ASCII_TABULAR

Table Cell (td)

ASCII Tabular Files

Table Row (tr)
Table Cell (td)


Table Cell (td)

WK1

Table Cell (td)

Lotus 1-2-3 (Version 2.0 or 2.01)

Table Row (tr)
Table Cell (td)


Table Cell (td)

WK3

Table Cell (td)

Lotus 1-2-3 (Version 3.0)

A bonus feature of RPTGNR is that it will optionally create a form file which can be saved, edited, and re-used with LSTPRC. See Chapter 9 for information about form files and how to customize them.

Using RPTGNR with USPSLM/DEDLM Data File

Using the TEXT Option of RPTGNR

Suppose we used the deduction list maker option from USPS (USPSLM/DEDLM) to create a data file of all employees who pay the school district income tax (OSDI) at one of a set of school districts. We now want to change the format of this file (called OSDI_DED.DAT) before printing the report.

Ordered List (ol)
List Item (li)

Type: RUN OECN$:RPTGNR
The following screen will appear.

Code Block
borderStylenone

_____________________________________________________________________________
|                                                                           |
|   RPTGNR Utility -- Generates a detail report from list file              |
|   ----------------------------------------------------------------------  |
|                                                                           |
|   List data file name   ____________________________                      |
|   Report output type    TXT                                               |
|                                                                           |
|   Enter the filename of the list data file and press the 'Accept' key.    |
|   This file must have already been created by a 'List Maker' routine.     |
|                                                                           |
|   After you enter this file name, you will asked to enter specifications  |
|   for the report.                                                         |
|                                                                           |
|  RPTGNR - Report Generator                                                |
|  xx  Accept                                                               |
|  xx  Help                                                                 |
|  xx  Exit                                                                 |
|___________________________________________________________________________|


List Item (li)
Enter the list data file name. For this example, OSDI_DED.DAT.
List Item (li)

There are several options available for the Report Output Type. The default is TXT which will produce the usual text file. To see all of the options, press the [Help] key. A pop-up menu such as the following will appear. Use the up arrow and down arrow keys to select an option and then press the [Return] key to process the selection.

Code Block

            ------Output Types Available------

     TXT           -  Report Format
     DTIF          -  DIGITAL Table Interchange Format
     ASCII_TABULAR -  ASCII Tabular Files
     WK1           -  Lotus 1-2-3 (Version 2.0 or 2.01)
     WK3           -  Lotus 1-2-3 (Version 3.0)

Info

The output types: ASCII_TABULAR, WK1, and WK2 will be available on your system only if they have been installed by the A-site.

List Item (li)

For this example, use the default type, TXT. Then press the [Accept] key. The following screen will appear.

Code Block
borderStylenone

_____________________________________________________________________________
|  RPTGNR Utility -- Report Specifications                                  |
|   ----------------------------------------------------------------------  |
|                                                                           |
|      Heading                                                              |
|      Output Report    OSDI_DED.TXT                                        |
|      Saved Form File                                                      |
|      Page Width        80                                                 |
|      Lines/Page        66                                                 |
|      Spacing            1                                                 |
|      Tab Stop Spacing   4                                                 |
|                                                                           |
|                                                                           |
| Enter specifications for this report then press the 'Generate Report' key.|
|                                                                           |
| RPTGNR - Report Generator                                                 |    
|                                                                           |
| xx  Generate Report       xx  Specify Sort Criteria                       |
| xx  Help                  xx  Select/Modify Fields                        |
| xx  Exit                                                                  |
| xx  Cancel                                                                |
|___________________________________________________________________________|

List Item (li)
Enter the page heading for the report. For this example, OSDI DEDUCTIONS REPORT.
List Item (li)
Either accept the defaults or enter new values for: Page Width; Lines/Page; and Spacing. Enter 132 for the page width.
List Item (li)
The Tab Stop spacing is set (by default) to 4 columns between tab stops. You can enter a different value for this. The columns on the report are aligned on the tab stops. If the width of a field covers more than one tab stop, then the next token will start at the next available tab stop.
List Item (li)
The default output file name is OSDI_DED.TXT. You can accept this file name or delete it and enter a different name.
List Item (li)

The RPTGNR program creates a form file which can be saved, edited and re-used with LSTPRC at a later time. The user has the option of saving this file by entering a name with the extension .FRM. For this example, use OSDI_DED.FRM.

Code Block
borderStylenone

_____________________________________________________________________________
|  RPTGNR Utility -- Report Specifications                                  |
|   ----------------------------------------------------------------------  |
|                                                                           |
|      Heading          OSDI DEDUCTIONS REPORT                              |
|      Output Report    OSDI_DED.TXT                                        |
|      Saved Form File  OSDI_DED.FRM                                        |
|      Page Width       132                                                 |
|      Lines/Page        66                                                 |
|      Spacing            1                                                 |
|      Tab Stop Spacing   4                                                 |
|                                                                           |
|                                                                           |
| Enter specifications for this report then press the 'Generate Report' key.|
|                                                                           |
| RPTGNR - Report Generator                                                 |  
|                                                                           |
| xx  Generate Report       xx  Specify Sort Criteria                       |
| xx  Help                  xx  Select/Modify Fields                        |
| xx  Exit                                                                  |
| xx  Cancel                                                                |
|___________________________________________________________________________|

Info

At this point the user has the option of either generating the report as is (see step 19) or optionally changing the format and the sort order by pressing the [Select/Modify fields] key or the [Specify] sort criteria key. Steps 9 - 18 illustrate the use of these keys.

List Item (li)

Press the [Select/Modify Fields] key in order to change the format of the report. The following is a typical screen for this example.

Code Block
borderStylenone

_____________________________________________________________________________
|                                                                           |
| RPTGNR Utility -- Field Specifications                                    |
|  ----------------------------------------------------------------------   |
| Order Token                      Heading                       Len TL Case|
|  1   <SSN>                     _  SSN                             9  N    |
|  2   <LAST_NAME>               _  LAST_NAME                      12  N    |
|  3   <FIRST_NAME>              _  FIRST_NAME                      9  N    |
|  4   <INITIAL>                 _  INITIAL                         1  N    |
|  5   <DED_CODE>                _  DED_CODE                        3  N    |
|  6   <DEDAMT_QTD>              _  DEDAMT_QTD                     10  N    |
|  7   <GROSS_QTD>               _  GROSS_QTD                      10  N    |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
| [End of Tokens]                                                           |
| RPTGNR - Report Generator                                                 |
|                                                                           |
| xx  Accept                xx  Reorder Fields                              |
| xx  Top                   xx  Previous Tokens                             |
| xx  Help                  xx  Next Tokens                                 |
| xx  Exit                                                                  |
|___________________________________________________________________________|



List Item (li)

The user can change the format of the report by changing one or more of the following items:

HTML Table
border3
width75%
Table Row (tr)
Table Cell (td)

Order

Table Cell (td)

You can use this field to change the order that the fields will appear on the report. Enter any number here to indicate the field's relative position. Press the
[Reorder Fields] key to see the affect of your changes. Enter blanks in this field to prevent the item from appearing on the report.

Table Row (tr)
Table Cell (td)

Totals

Table Cell (td)

Enter a "Y" in the blank to the left of the heading for any numeric field for which you wish to have totals and subtotals accumulated and printed. (This is permitted for up to 10 numeric fields.)

Table Row (tr)
Table Cell (td)

Heading

Table Cell (td)

Enter the column heading that you want to appear for this token.The text that you type here will appear in the page headings above the field.

Table Row (tr)
Table Cell (td)

Len

Table Cell (td)

This is the length of the field as it will appear on the report. You may cause the field to use more or less space on the report by changing its length. Entering zero or blank here will prevent the field from appearing on the report.

Table Row (tr)
Table Cell (td)

TL

Table Cell (td)

Trim leadings spaces? Entering a "Y" in this field will cause leading spaces to be removed from the field before printing. If you are working with a data file that contains leading spaces in some fields, you may wish to remove them.

Table Row (tr)
Table Cell (td)

Case

Table Cell (td)

Case conversion:

U = Convert field to all uppercase


L = Convert field to all lowercase


C = Capitalize field (first letter of each word in
uppercase)

Leaving this field blank will leave field unchanged.

List Item (li)

For this example change the format by pressing the [Tab] key until the cursor is on the correct line under the heading column, and then type in a new heading. A sample result is displayed in the next screen.

Code Block
borderStylenone

______________________________________________________________________________
|                                                                            |
| RPTGNR Utility -- Field Specifications                                     |
|   -----------------------------------------------------------------------  |
| Order Token                       Heading                       Len TL Case|
|  1   <SSN>                      _  SSN                            9  N     |
|  2   <LAST_NAME>                _  LAST                          12  N     |
|  3   <FIRST_NAME>               _  FIRST                          9  N     |
|  4   <INITIAL>                  _  M                              1  N     |
|  5   <DED_CODE>                 _  DED CODE                       3  N     |
|  6   <DEDAMT_QTD>               _  DEDAMT QTD                    10  N     |
|  7   <GROSS_QTD>                _  GROSS QTD                     10  N     |
|                                                                            |
|                                                                            |
| [End of Tokens]                                                            |
|                                                                            |
|                                                                            |
|  RPTGNR - Report Generator                                                 |
| xx  Accept                xx  Reorder Fields                               |
| xx  Top                   xx  Previous Tokens                              |
| xx  Help                  xx  Next Tokens                                  |
| xx  Exit                                                                   |
|____________________________________________________________________________|


List Item (li)

Next change the order of the tokens so that they will be printed out in the following order:<DED_CODE>, <SSN>, <LAST_NAME>, <FIRST_NAME>, <INITIAL>, DEDAMT_QTD>, and <GROSS_QTD>. To do this, move the cursor to the field in front of each token and type in the "relative" order of the token.

Info

The order numbers do not have to be numerically sequential. Any number will do as long as a token which is to follow another token has a number equal to or larger than the preceding token number. For example, the sequence 1, 2, 2, 10, 15 for token numbers is acceptable.

List Item (li)

Lastly, enter a "Y" to the left of the heading for <DEDAMT_QTD> and <GROSS_QTD> in order to produce totals and subtotals for each of these fields.
The following screen displays the results.

Code Block
borderStylenone

_____________________________________________________________________________
|                                                                           |
| RPTGNR Utility -- Field Specifications                                    |
| ------------------------------------------------------------------------- |
| Order Token                     Heading                      Len TL Case  |
|  2   <SSN>                      _  SSN                           9  N     |
|  3   <LAST_NAME>                _  LAST                         12  N     |
|  4   <FIRST_NAME>               _  FIRST                         9  N     |
|  5   <INITIAL>                  _  M                             1  N     |
|  1   <DED_CODE>                 _  DED CODE                      3  N     |
|  6   <DEDAMT_QTD>               Y  DEDAMT QTD                   10  N     |
|  7   <GROSS_QTD>                Y  GROSS QTD                    10  N     |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
| [End of Tokens]                                                           |
|                                                                           |
|                                                                           |
| RPTGNR - Report Generator                                                 |
|                                                                           |
| xx  Accept                xx  Reorder Fields                              |
| xx  Top                   xx  Previous Tokens                             |
| xx  Help                  xx  Next Tokens                                 |
| xx  Exit                                                                  |
|___________________________________________________________________________|

List Item (li)

In order to see the affect of the re-ording, press the [Reorder ] tokens key. The following screen displays the result.

Code Block
borderStylenone

_____________________________________________________________________________
|                                                                           |
| RPTGNR Utility -- Field Specifications                                    |
| ------------------------------------------------------------------------- |
| Order Token                     Heading                       Len TL Case |
|  1   <DED_CODE>                _  DED CODE                      3  N      |
|  2   <SSN>                     _  SSN                           9  N      |
|  3   <LAST_NAME>               _  LAST                         12  N      |
|  4   <FIRST_NAME>              _  FIRST                         9  N      |
|  5   <INITIAL>                 _  M                             1  N      |
|  6   <DEDAMT_QTD>              Y  DEDAMT QTD                   10  N      |
|  7   <GROSS_QTD>               Y  GROSS QTD                    10  N      |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
| [End of Tokens]                                                           |
|                                                                           |
|                                                                           |
| RPTGNR - Report Generator                                                 |
|                                                                           |
| xx  Accept                xx  Reorder Fields                              |
| xx  Top                   xx  Previous Tokens                             |
| xx  Help                  xx  Next Tokens                                 |
| xx  Exit                                                                  |  
|___________________________________________________________________________|

List Item (li)

Press the [Accept] key to return to the main screen. Next press the [Specify sort criteria] key to permit sorting on other fields. The following is a typical screen.

Code Block
borderStylenone

_____________________________________________________________________________
|                                                                           |
|  SRTPRC - Token Sort Selection                                            |
|  -----------------------------------------------------------------------  |
|   __  <SSN>                      _                                        |
|   __  <LAST_NAME>                _   To the left of each token you want   |
|   __  <FIRST_NAME>               _   to sort by, enter a number that      |
|   __  <INITIAL>                  _   represents the sort order.           |
|   __  <DED_CODE>                 _   The number must be between 1 and 10. |
|   __  <DEDAMT_QTD>               _                                        |
|   __  <GROSS_QTD>                _   To the right of each numeric sort    |
|                                      token, place an 'H', 'F', or 'B' if  |
|                                      you want to break when the value for |
|                                      that token changes.                  |
|                                                                           |
|                                      Press the 'Reorder Tokens' key       |
|                                      to see the effect of your changes.   |
|                                      The file will be sorted in the order |
|                                      that the tokens appear on the screen.|
|                                                                           |
|  [No more tokens]                                                         |
|  SRTSCN - Token Selection Screen                                          |
|  xx  Accept                xx  Reorder Tokens                             |
|  xx  Top                   xx  Prev tokens                                |
|  xx  Help                  xx  Next tokens                                |
|  xx  Exit                                                                 |
|___________________________________________________________________________|

List Item (li)

Move the cursor to the blank field in front of the desired token and type in the sort order. You can have primary and secondary sorting. For example, if you want to sort first by Deduction Code, next by Last Name and then by First Name, put a 1 in front of <DED_CODE>, a 2 in front of <LAST_NAME> and a 3 in front of <FIRST_NAME>. Now press the [Reorder tokens] key to see the result. The following display shows the resulting screen.

Code Block
borderStylenone

____________________________________________________________________________
|                                                                           |
|  SRTPRC - Token Sort Selection                                            |
|  -----------------------------------------------------------------------  |
|    1  <DED_CODE>                 _                                        |
|    2  <LAST_NAME>                _   To the left of each token you want   |
|    3  <FIRST_NAME>               _   to sort by, enter a number that      |
|       <INITIAL>                  _   represents the sort order.           |
|       <SSN>                      _   The number must be between 1 and 10. |
|       <DEDAMT_QTD>               _                                        |
|       <GROSS_QTD>                _   To the right of each numeric sort    |
|                                      token, place an 'H', 'F', or 'B' if  |
|                                      you want to break when the value for |
|                                      that token changes.                  |
|                                                                           |
|                                      Press the 'Reorder Tokens' key       |
|                                      to see the effect of your changes.   |
|                                      The file will be sorted in the order |
|                                      that the tokens appear on the screen.|
|                                                                           |
|  [No more tokens]                                                         |
|  SRTSCN - Token Selection Screen                                          |
|  xx  Accept                xx  Reorder Tokens                             |
|  xx  Top                   xx  Prev tokens                                |
|  xx  Help                  xx  Next tokens                                |
|  xx  Exit                                                                 |
|___________________________________________________________________________|


List Item (li)

Enter the letter "B" (Both) in the space to the right of the field <DED_CODE>. Since this is a sort field, this will cause a "break" to occur each time the value of the field changes and will cause the deduction code value to be printed at both the top and the bottom of each new list of deductions.
Enter the letter "F" on a sort field, if you wish a "break" to occur when the value of the field changes and the code value to be printed at the bottom (Foot) of the list.
Enter the letter "H" on a sort field, if you wish a "break" to occur when the value of the field changes and the code value to be printed at the top (Heading) of the list.
The final screen is displayed next.

Code Block
borderStylenone

____________________________________________________________________________
|                                                                           |
|  SRTPRC - Token Sort Selection                                            |
|  -----------------------------------------------------------------------  |
|    1  <DED_CODE>                 B                                        |
|    2  <LAST_NAME>                _   To the left of each token you want   |
|    3  <FIRST_NAME>               _   to sort by, enter a number that      |
|       <INITIAL>                  _   represents the sort order.           |
|       <SSN>                      _   The number must be between 1 and 10. |
|       <DEDAMT_QTD>               _                                        |
|       <GROSS_QTD>                _   To the right of each numeric sort    |
|                                      token, place an 'H', 'F', or 'B' if  |
|                                      you want to break when the value for |
|                                      that token changes.                  |
|                                                                           |
|                                      Press the 'Reorder Tokens' key       |
|                                      to see the effect of your changes.   |
|                                      The file will be sorted in the order |
|                                      that the tokens appear on the screen.|
|                                                                           |
|  [No more tokens]                                                         |
|  SRTSCN - Token Selection Screen                                          |
|  xx  Accept                xx  Reorder Tokens                             |
|  xx  Top                   xx  Prev tokens                                |
|  xx  Help                  xx  Next tokens                                |
|  xx  Exit                                                                 |
|___________________________________________________________________________|


List Item (li)

Now press the [Accept] key to return to the main screen as shown below. A prompt will appear to ask if you want to do a page break whenever the primary sort field changes value. Enter the value "Y" for the page break.

Code Block
borderStylenone

_____________________________________________________________________________
|                                                                           |
| RPTGNR Utility -- Report Specifications                                   |
|   ---------------------------------------------------------------------   |
|                                                                           |
|      Heading         OSDI DEDUCTIONS REPORT                               |
|      Page Width      132  Tab stop spacing    4                           |
|      Lines/Page       66                                                  |
|      Spacing           1                                                  |
|      Output Report   OSDI_DED.TXT                                         |
|      Saved Form File OSDI_DED.FRM                                         |
|                                                                           |
|      Do you want to page break on <DED_CODE>?  Y                          |
|                                                                           |
| Enter specifications for this report then press the 'Generate Report' key.|
|                                                                           |
|                                                                           |
|  Sort criteria set as requested.                                          |
|                                                                           |
|                                                                           |
| RPTGNR - Report Generator                                                 |
| xx  Generate Report       xx  Specify Sort Criteria                       |
| xx  Help                  xx  Select/Modify Fields                        |
| xx  Exit                                                                  |
| xx  Cancel                                                                |
|___________________________________________________________________________|

List Item (li)
Finally press the [Generate report] key to complete the process. The following lines will appear.

Preparing Report format.

Sorting. Please wait.

Processing. Please wait.

Output report is OSDI_DED.TXT.

Generated form file is OSDI_DED.FRM.

Printing the Report

Use a print command to print the text file: OSDI_DED.TXT. A sample output is shown below.

Code Block



Oct 09 92                          OSDI Deductions                         Page: 1
 9:06 am

   DED CODE   SSN         LAST            FIRST       M    DEDAMT QTD     GROSS QTD

 DED_CODE: 804

   804        301234567   APPLE           BILL        E         16.00      1,600.00
   804        298901234   BANANA          DEBBIE      J         10.00      1,000.00
   804        295678901   HAMBURGER       SUSAN       L         22.00      2,200.00
   804        282345678   HALLWAY         GEORGE      K         35.00      5,500.00
   804        279012345   ITEM            TRACEY      L         18.00      2,300.00
   804        296789012   JONES           DONNA       J         35.00      3,500.00
   804        293456789   STICK           THOMAS      S         20.00      2,000.00
   804        270123456   SUGAR           CHRIS       J         38.55      4,355.96
   804        287890123   SWIFT           JOE         M         12.00      2,200.00
   804        294567890   WINNER          BONNIE      S         12.00      2,000.00
   804        281234567   WINTER          KATHY       S         12.00      2,400.00
   804        288901234   ZEBRA           STEVEN      L         22.00      3,000.00

 DED_CODE: 804 subtotal.
                                                               252.55     32,055.96
Code Block

Oct 09 92                          OSDI Deductions                         Page: 2
 9:06 am

   DED CODE   SSN         LAST            FIRST       M    DEDAMT QTD     GROSS QTD

DED_CODE: 807

   807        250987654   ABLE            ERNIE                 27.40      6,114.79
   807        253210987   APPLE           JOSEPH      A         10.00        200.00
   807        256543210   BEAR            BIG                   26.00      5,635.50
   807        269876543   BOTTLE          SMALL       A         30.00      1,500.00
   807        262109876   CLAUS           SANTA       K         20.25      4,719.77
   807        315432109   CRAFT           KRIS        L         24.80      6,004.53
   807        238765432   DIVER           HIGH        L         37.51      8,324.25
   807        311098765   ELEVATOR        LOW         L         22.00      4,400.00
   807        234321098   INCOME          LOWER       D         27.00      5,926.67
   807        247654321   INCOME          MIDDLE      A         22.25      5,092.53
   807        315432109   INCOME          UPPER       R          8.00      1,600.00
   807        208765432   MANAGEMENT      BOTTOM                25.50      5,518.83
   807        101987654   METRIC          FREE                  33.05      7,498.35
   807        233210987   OFFICE          OUTSIDE     L         27.00      5,923.46
   807        246543210   PRICED          OUT                   29.00      6,285.18
   807        359876543   RASKEL          FAT                   29.00      6,285.18
   807        262109876   RING            LARGE       A         23.80      5,221.76
   807        285432109   ROSS            HAPPY       I         27.80      6,060.88
   807        212345678   SACK            SAD         J         30.85      7,116.15
   807        229012345   SPRING          BLUE                  27.40      6,685.09
   807        236789012   TIME            JIFFY       K          8.96        932.00
   807        243456789   TIME            JIFFY       A         13.00      2,600.00
   807        250123456   TIME            OUTOF                 34.00      6,800.00
   807        367890123   WIN             FIRST       L         15.00      3,000.00
   807        234567890   WINNER          TOTAL                  9.00      1,943.97

  DED_CODE: 807 subtotal.
                                                               600.57    129,285.44

 GRAND TOTALS:
                                                               853.12    161,341.40

The OSDI_DED.FRM File

The following screen displays the OSDI_DED.FRM file which was created by RPTGNR in the preceding example. This file can be edited and used as a form file with the LSTPRC program.

Code Block


<$COMMENT> Created by RPTGNR on 10/09/92  9:06 am using DED800_807.DAT for DIEHL
<$COMMENT>
<$SETUP/PAGE=0066/WIDTH=0132/LIMIT=0061/BREAK="<DED_CODE>">
<$SORT> <DED_CODE> <LAST_NAME> <FIRST_NAME>
<$AT_TOP/BREAK ="<DED_CODE>">     DED_CODE: <DED_CODE>
<$AT_TOP/BREAK ="<DED_CODE>">
<$AT_BOTTOM/BREAK ="<DED_CODE>">
<$AT_BOTTOM/BREAK ="<DED_CODE>">     DED_CODE: <DED_CODE> subtotal.
<$AT_BOTTOM/BREAK ="<DED_CODE>"><DEDAMT_QTD/TOTAL/EDIT="-,---,---.99"/POS=0065>
<GROSS_QTD/TOTAL/EDIT="-,---,---.99"/POS=0081>
<$AT_BOTTOM/BREAK ="<DED_CODE>">
<$AT_BOTTOM/REPORT> GRAND TOTALS:
<$AT_BOTTOM/REPORT><DEDAMT_QTD/TOTAL/EDIT="-,---,---.99"/POS=0065>
<GROSS_QTD/TOTAL/EDIT="-,---,---.99"/POS=0081>
<$HEADING><$FF><$DATE> <_TITLE/FIXED=50/CENTER/POS=0042/VALUE="OSDI Deductions">
<_PAGE/VALUE="Page: "/POS=0116><$PAGE>
<$HEADING><$TIME>
<$HEADING>
<$HEADING>  DED CODE   SSN       LAST         FIRST    M  DEDAMT QTD   GROSS QTD
<$HEADING>
<DED_CODE/POS=9><SSN/POS=20><LAST_NAME/POS=32><FIRST_NAME/POS=48>
<INITIAL/POS=60><DEDAMT_QTD/POS=67><GROSS_QTD/POS=83>


Using the SPREADSHEET Option of RPTGNR

We will use the same data file as presented in the preceeding TEXT option. Only this time we will use RPTGNR to create a spreadsheet instead of a printable text file.

Suppose we used the deduction list maker option from USPS (USPSLM/DEDLM) to create a data file of all employees who pay the school district income tax (OSDI) at one of a set of school districts. We now want to change the format of this file (called OSDI_DED.DAT) and then generate a spreadsheet file.

Ordered List (ol)
List Item (li)

Type: RUN OECN$:RPTGNR
The following screen will appear.

Code Block
borderStylenone

_____________________________________________________________________________
|                                                                           |
|   RPTGNR Utility -- Generates a detail report from list file              |
|   ----------------------------------------------------------------------  |
|                                                                           |
|   List data file name   ____________________________                      |
|   Report output type    TXT                                               |
|                                                                           |
|                                                                           |
|   Enter the filename of the list data file and press the 'Accept' key.    |
|   This file must have already been created by a 'List Maker' routine.     |
|                                                                           |
|   After you enter this file name, you will asked to enter specifications  |
|   for the report.                                                         |
|                                                                           |
|  RPTGNR - Report Generator                                                |
|  xx  Accept                                                               |
|  xx  Help                                                                 |
|  xx  Exit                                                                 |
|___________________________________________________________________________|

List Item (li)
Enter the list data file name. For this example, OSDI_DED.DAT.
List Item (li)

There are several options available for the Report Output Type. The default is TXT which will produce the usual text file. To see all of the options, press the [Help] key. A pop-up menu such as the following will appear. Use the up arrow and down arrow keys to select an option and then press the [Return] key to process the selection.

Code Block

            ------Output Types Available------

     TXT           -  Report Format
     DTIF          -  DIGITAL Table Interchange Format
     ASCII_TABULAR -  ASCII Tabular Files
     WK1           -  Lotus 1-2-3 (Version 2.0 or 2.01)
     WK3           -  Lotus 1-2-3 (Version 3.0)

Info

The output types: ASCII_TABULAR, WK1, and WK2 will be available on your system only if they have been installed by the A-site.

List Item (li)

For this example, use the report output type, DTIF. Then press the [Accept] key. The following screen will appear.

Code Block
borderStylenone

_____________________________________________________________________________
|  RPTGNR Utility -- Report Specifications                                  |
|   ----------------------------------------------------------------------  |
|                                                                           |
|      Heading                                                              |
|      Output Report    OSDI_DED.DTIF                                       |
|      Saved Form File                                                      |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
| Enter specifications for this report then press the 'Generate Report' key.|
|                                                                           |
| RPTGNR - Report Generator                                                 |   
|                                                                           |
| xx  Generate Report       xx  Specify Sort Criteria                       |
| xx  Help                  xx  Select/Modify Fields                        |
| xx  Exit                                                                  |
| xx  Cancel                                                                |
|___________________________________________________________________________|

List Item (li)
Enter the page heading for the report. For this example, OSDI DEDUCTIONS REPORT.
List Item (li)
The default output file name is OSDI_DED.DTIF. You can accept this file name or delete it and enter a different name.
List Item (li)

The RPTGNR program creates a form file which can be saved, edited and re-used with LSTPRC at a later time. The user has the option of saving this file by entering a name with the extension .FRM. For this example, use OSDI_DTIF.FRM.

Code Block
borderStylenone

_____________________________________________________________________________
|   RPTGNR Utility -- Report Specifications                                 |
|   ---------------------------------------------------------------------   |
|                                                                           |
|      Heading           OSDI DEDUCTIONS REPORT                             |
|      Output Report     OSDI_DED.DTIF                                      |
|      Saved Form File   OSDI_DTIF.FRM                                      |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
| Enter specifications for this report then press the 'Generate Report' key.|
|                                                                           |
| RPTGNR - Report Generator                                                 |
|                                                                           |
| xx  Generate Report       xx  Specify Sort Criteria                       |
| xx  Help                  xx  Select/Modify Fields                        |
| xx  Exit                                                                  |
| xx  Cancel                                                                |
|___________________________________________________________________________|

Info

At this point the user has the option of either generating the report as is (see step 14) or optionally changing the format and the sort order by pressing the [Select/Modify fields] key or the [Specify] sort criteria key. Steps 7 - 13 illustrate the use of these keys.

List Item (li)

Press the [Select/Modify Fields] key in order to change the format of the report. The following is a typical screen for this example.

Code Block
borderStylenone

_____________________________________________________________________________
|                                                                           |
| RPTGNR Utility -- Field Specifications                                    |
|  ----------------------------------------------------------------------   |
| Order Token                      Heading                       Len TL Case|
|  1   <SSN>                     _  SSN                             9  N    |
|  2   <LAST_NAME>               _  LAST_NAME                      12  N    |
|  3   <FIRST_NAME>              _  FIRST_NAME                      9  N    |
|  4   <INITIAL>                 _  INITIAL                         1  N    |
|  5   <DED_CODE>                _  DED_CODE                        3  N    |
|  6   <DEDAMT_QTD>              _  DEDAMT_QTD                     10  N    |
|  7   <GROSS_QTD>               _  GROSS_QTD                      10  N    |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
| [End of Tokens]                                                           |
|                                                                           |                                                                                                                       | RPTGNR - Report Generator                                                 |
|                                                                           |
| xx  Accept                xx  Reorder Fields                              |
| xx  Top                   xx  Previous Tokens                             |
| xx  Help                  xx  Next Tokens                                 |
| xx  Exit                                                                  |
|___________________________________________________________________________|



List Item (li)

For this example change the format by pressing the [Tab] key until the cursor is on the correct line under the heading column, and then type in a new heading. A sample result is displayed in the next screen.

Code Block
borderStylenone

______________________________________________________________________________
|                                                                            |
| RPTGNR Utility -- Field Specifications                                     |
|   -----------------------------------------------------------------------  |
| Order Token                       Heading                       Len TL Case|
|  1   <SSN>                      _  SSN                            9  N     |
|  2   <LAST_NAME>                _  LAST                          12  N     |
|  3   <FIRST_NAME>               _  FIRST                          9  N     |
|  4   <INITIAL>                  _  M                              1  N     |
|  5   <DED_CODE>                 _  DED CODE                       3  N     |
|  6   <DEDAMT_QTD>               _  DEDAMT QTD                    10  N     |
|  7   <GROSS_QTD>                _  GROSS QTD                     10  N     |
|                                                                            |
|                                                                            |
| [End of Tokens]                                                            |
|                                                                            |
|                                                                            |
|  RPTGNR - Report Generator                                                 |
| xx  Accept                xx  Reorder Fields                               |
| xx  Top                   xx  Previous Tokens                              |
| xx  Help                  xx  Next Tokens                                  |
| xx  Exit                                                                   |
|____________________________________________________________________________|


List Item (li)

Next change the order of the tokens so that they will be printed out in the following order:<DED_CODE>, <SSN>, <LAST_NAME>, <FIRST_NAME>, <INITIAL>, DEDAMT_QTD>, and <GROSS_QTD>. To do this, move the cursor to the field in front of each token and type in the "relative" order of the token.

Info

The order numbers do not have to be numerically sequential. Any number will do as long as a token which is to follow another token has a number equal to or larger than the preceding token number. For example, the sequence 1, 2, 2, 10, 15 for token numbers is acceptable.


The following screen displays the results.

Code Block
borderStylenone

_____________________________________________________________________________
|                                                                           |
| RPTGNR Utility -- Field Specifications                                    |
| ------------------------------------------------------------------------- |
| Order Token                     Heading                      Len TL Case  |
|  2   <SSN>                      _  SSN                           9  N     |
|  3   <LAST_NAME>                _  LAST                         12  N     |
|  4   <FIRST_NAME>               _  FIRST                         9  N     |
|  5   <INITIAL>                  _  M                             1  N     |
|  1   <DED_CODE>                 _  DED CODE                      3  N     |
|  6   <DEDAMT_QTD>               _  DEDAMT QTD                   10  N     |
|  7   <GROSS_QTD>                _  GROSS QTD                    10  N     |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
| [End of Tokens]                                                           |
|                                                                           |
|                                                                           |
| RPTGNR - Report Generator                                                 |
|                                                                           |
| xx  Accept                xx  Reorder Fields                              |
| xx  Top                   xx  Previous Tokens                             |
| xx  Help                  xx  Next Tokens                                 |
| xx  Exit                                                                  |
|___________________________________________________________________________|

List Item (li)

In order to see the affect of the re-ording, press the [Reorder ] tokens key. The following screen displays the result.

Code Block
borderStylenone

_____________________________________________________________________________
|                                                                           |
| RPTGNR Utility -- Field Specifications                                    |
| ------------------------------------------------------------------------- |
| Order Token                     Heading                       Len TL Case |
|  1   <DED_CODE>                _  DED CODE                      3  N      |
|  2   <SSN>                     _  SSN                           9  N      |
|  3   <LAST_NAME>               _  LAST                         12  N      |
|  4   <FIRST_NAME>              _  FIRST                         9  N      |
|  5   <INITIAL>                 _  M                             1  N      |
|  6   <DEDAMT_QTD>              _  DEDAMT QTD                   10  N      |
|  7   <GROSS_QTD>               _  GROSS QTD                    10  N      |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
| [End of Tokens]                                                           |
|                                                                           |
|                                                                           |
| RPTGNR - Report Generator                                                 |
|                                                                           |
| xx  Accept                xx  Reorder Fields                              |
| xx  Top                   xx  Previous Tokens                             |
| xx  Help                  xx  Next Tokens                                 |
| xx  Exit                                                                  |    
|___________________________________________________________________________|

List Item (li)

Press the [Accept] key to return to the main screen. Next press the [Specify sort criteria] key to permit sorting on other fields. The following is a typical screen.

Code Block
borderStylenone

_____________________________________________________________________________
|                                                                           |
|  SRTPRC - Token Sort Selection                                            |
|  -----------------------------------------------------------------------  |
|   __  <SSN>                      _                                        |
|   __  <LAST_NAME>                _   To the left of each token you want   |
|   __  <FIRST_NAME>               _   to sort by, enter a number that      |
|   __  <INITIAL>                  _   represents the sort order.           |
|   __  <DED_CODE>                 _   The number must be between 1 and 10. |
|   __  <DEDAMT_QTD>               _                                        |
|   __  <GROSS_QTD>                _   To the right of each numeric sort    |
|                                      token, place an 'H', 'F', or 'B' if  |
|                                      you want to break when the value for |
|                                      that token changes.                  |
|                                                                           |
|                                      Press the 'Reorder Tokens' key       |
|                                      to see the effect of your changes.   |
|                                      The file will be sorted in the order |
|                                      that the tokens appear on the screen.|
|                                                                           |
|  [No more tokens]                                                         |
|  SRTSCN - Token Selection Screen                                          |
|  xx  Accept                xx  Reorder Tokens                             |
|  xx  Top                   xx  Prev tokens                                |
|  xx  Help                  xx  Next tokens                                |
|  xx  Exit                                                                 |
|___________________________________________________________________________|

List Item (li)

Move the cursor to the blank field in front of the desired token and type in the sort order. You can have primary and secondary sorting. For example, if you want to sort first by Deduction Code, next by Last Name and then by First Name, put a 1 in front of <DED_CODE>, a 2 in front of <LAST_NAME> and a 3 in front of <FIRST_NAME>. Now press the [Reorder tokens] key to see the result. The following display shows the resulting screen.

Code Block
borderStylenone

____________________________________________________________________________
|                                                                           |
|  SRTPRC - Token Sort Selection                                            |
|  -----------------------------------------------------------------------  |
|    1  <DED_CODE>                 _                                        |
|    2  <LAST_NAME>                _   To the left of each token you want   |
|    3  <FIRST_NAME>               _   to sort by, enter a number that      |
|       <INITIAL>                  _   represents the sort order.           |
|       <SSN>                      _   The number must be between 1 and 10. |
|       <DEDAMT_QTD>               _                                        |
|       <GROSS_QTD>                _   To the right of each numeric sort    |
|                                      token, place an 'H', 'F', or 'B' if  |
|                                      you want to break when the value for |
|                                      that token changes.                  |
|                                                                           |
|                                      Press the 'Reorder Tokens' key       |
|                                      to see the effect of your changes.   |
|                                      The file will be sorted in the order |
|                                      that the tokens appear on the screen.|
|                                                                           |
|  [No more tokens]                                                         |
|  SRTSCN - Token Selection Screen                                          |
|  xx  Accept                xx  Reorder Tokens                             |
|  xx  Top                   xx  Prev tokens                                |
|  xx  Help                  xx  Next tokens                                |
|  xx  Exit                                                                 |
|___________________________________________________________________________|


Info

Control breaks, subtotals and grand totals are not available when creating a spreadsheet. These would need to be manually inserted using a spreadsheet package such as 20/20 or Lotus 1-2-3.

List Item (li)

Now press the [Accept] key to return to the main screen as shown below.

Code Block
borderStylenone

_____________________________________________________________________________
|   RPTGNR Utility -- Report Specifications                                 |
|   ---------------------------------------------------------------------   |
|                                                                           |
|      Heading           OSDI DEDUCTIONS REPORT                             |
|      Output Report     OSDI_DED.DTIF                                      |
|      Saved Form File   OSDI_DTIF.FRM                                      |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
|                                                                           |
| Enter specifications for this report then press the 'Generate Report' key.|
|                                                                           |
| RPTGNR - Report Generator                                                 |
|                                                                           |
| xx  Generate Report       xx  Specify Sort Criteria                       |
| xx  Help                  xx  Select/Modify Fields                        |
| xx  Exit                                                                  |
| xx  Cancel                                                                |
|___________________________________________________________________________|

List Item (li)
Finally press the [Generate report] key to complete the process. The following lines will appear.

Preparing Report format.

Sorting. Please wait.

Processing. Please wait.

Output report is OSDI_DED.DTIF.

Generated form file is OSDI_DTIF.FRM.

Using the Spreadsheet

For this example 20/20 was used to load the file OSDI_DED.DTIF into a new spreadsheet. A typical result is shown below.

Code Block




      /..A./.....B..../......C....../.....D..../.E/.....F...../.....G......
   0
   1                  OSDI DEDUCTIONS REPORT
   2
   3
   4  DED CSSN        LAST          FIRST      M  DEDAMT QTD  GROSS QTD
   5
   6  804  301234567  APPLE         BILL       E         16.00     1,600.00
   7  804  298901234  BANANA        DEBBIE     J         10.00     1,000.00
   8  804  295678901  HAMBURGER     SUSAN      L         22.00     2,200.00
   9  804  282345678  HALLWAY       GEORGE     K         35.00     5,500.00
  10  804  279012345  ITEM          TRACEY     L         18.00     2,300.00
  11  804  296789012  JONES         DONNA      J         35.00     3,500.00
  12  804  293456789  STICK         THOMAS     S         20.00     2,000.00
  13  804  270123456  SUGAR         CHRIS      J         38.55     4,355.96
  14  804  287890123  SWIFT         JOE        M         12.00     2,200.00
  15  804  294567890  WINNER        BONNIE     S         12.00     2,000.00
  16  804  281234567  WINTER        KATHY      S         12.00     2,400.00
  17  804  288901234  ZEBRA         STEVEN     L         22.00     3,000.00
  18  807  250987654  ABLE          ERNIE                27.40     6,114.79
  19  807  253210987  APPLE         JOSEPH     A         10.00       200.00
  20  807  256543210  BEAR          BIG                  26.00     5,635.50
  21  807  269876543  BOTTLE        SMALL      A         30.00     1,500.00
  22  807  262109876  CLAUS         SANTA      K         20.25     4,719.77
  23  807  315432109  CRAFT         KRIS       L         24.80     6,004.53
  24  807  238765432  DIVER         HIGH       L         37.51     8,324.25
  25  807  311098765  ELEVATOR      LOW        L         22.00     4,400.00
  26  807  234321098  INCOME        LOWER      D         27.00     5,926.67
  27  807  247654321  INCOME        MIDDLE     A         22.25     5,092.53
  28  807  315432109  INCOME        UPPER      R          8.00     1,600.00
  29  807  208765432  MANAGEMENT    BOTTOM               25.50     5,518.83
  30  807  101987654  METRIC        FREE                 33.05     7,498.35
  31  807  233210987  OFFICE        OUTSIDE    L         27.00     5,923.46
  32  807  246543210  PRICED        OUT                  29.00     6,285.18
  33  807  359876543  RASKEL        FAT                  29.00     6,285.18
  34  807  262109876  RING          LARGE      A         23.80     5,221.76
  35  807  285432109  ROSS          HAPPY      I         27.80     6,060.88
  36  807  212345678  SACK          SAD        J         30.85     7,116.15
  37  807  229012345  SPRING        BLUE                 27.40     6,685.09
  38  807  236789012  TIME          JIFFY      K          8.96       932.00
  39  807  243456789  TIME          JIFFY      A         13.00     2,600.00
  40  807  250123456  TIME          OUTOF                34.00     6,800.00
  41  807  367890123  WIN           FIRST      L         15.00     3,000.00
  42  807  234567890  WINNER        TOTAL                 9.00     1,943.97

The OSDI_DTIF.FRM FILE

The following screen displays the OSDI_DTIF.FRM file which was created by RPTGNR in the preceeding example. This file can be edited and used as a form file with the LSTPRC program.

Code Block



<$COMMENT> Created by RPTGNR on 11/10/93  3:10 pm using OSDI_TEST.DAT for DIEHL
<$COMMENT>
<$SETUP/PAGE=0066/WIDTH=0256/LIMIT=0061>
<$SORT> <DED_CODE> <LAST_NAME> <FIRST_NAME>
<$SUPPRESS><_COL_1/VALUE="DED CODE                      ">
<$SUPPRESS><_COL_2/VALUE="SSN                           ">
<$SUPPRESS><_COL_3/VALUE="LAST                          ">
<$SUPPRESS><_COL_4/VALUE="FIRST                         ">
<$SUPPRESS><_COL_5/VALUE="M                             ">
<$SUPPRESS><_COL_6/VALUE="DEDAMT QTD                    ">
<$SUPPRESS><_COL_7/VALUE="GROSS QTD                     ">
<$HEADING><$FF><$DATE> <_TITLE/FIXED=50/CENTER/POS=0104/VALUE="OSDI DEDUCTIONS
  REPORT"><_PAGE/VALUE="Page: "/POS=0240><$PAGE>
<$HEADING><$TIME>
<$HEADING>
<$HEADING><_COL_1/POS=0001><_COL_2/POS=0010><_COL_3/POS=0020><_COL_4/POS=0033>
  <_COL_5/POS=0043><_COL_6/POS=0045><_COL_7/POS=0057>
<$HEADING>
<DED_CODE/POS=1><SSN/POS=10><LAST_NAME/POS=20><FIRST_NAME/POS=33><INITIAL/POS=43>
  <DEDAMT_QTD/POS=45>
<$POSITION/SKIP=-1><GROSS_QTD/POS=56>