Programmer 7500

home *** CD-ROM | disk | FTP | other *** search

/ Programmer 7500 / MAX_PROGRAMMERS.iso / CLIPPER / MISC / BLDR10B.ZIP / BREPORT.DOC < prev next >

Wrap

Text File | 1993-03-19 | 81.1 KB | 2,243 lines

Aeolus Software BREPORT REFERENCE GUIDE COPYRIGHT (c) 1992 by Aeolus Software All rights reserved TABLE OF CONTENTS Introduction................................................1 Main Menu...................................................2 File Menu...................................................4 Loading/Creating a Report (.RPT) File.....................5 Select Database(s)........................................12 Generate Source Code......................................14 Format Menu.................................................15 Subtotal Entry............................................16 Modify Page Layout........................................18 Change a Report Field.......................................21 Add a Field to the Report...................................24 Delete a Report Field.......................................29 Move a Report Field.........................................32 Report Column Maintenance...................................33 About the Source Code Created...............................35 The Aeolus BREPORT User Manual INTRODUCTION BREPORT.EXE the BUILDER Report Generator. The Aeolus Report Generator creates report source code for the Clipper programmer to complete. This is similar to the way the BUILDER.EXE program operates, however, the BREPORT.EXE program differs in that each report generates a seperate .PR1 (.PRG) source code file. The BRE- PORT.EXE program, like BUILDER.EXE, allows the programmer to create the basic report format easily, which the programmer can then finish. This makes creating reports that cannot be done in REPORT FORM programmable quickly and easily. The source code created by the Aeolus Report Generator is designed to be incorporated into a large PROCEDURE file containing many or all the reports for the system you are writing. This is only a suggestion and the source code is quite flexible on this point. To execute the Report Generator type BREPORT, making certain that the BREPORT.EXE program is in the default directory or found in the DOS PATH. READ THE BOTTOM LINE OF THE SCREEN TO DETERMINE WHAT KEYS TO PRESS. ESC EXITS. <1> The Aeolus BREPORT User Manual MAIN MENU After executing the BREPORT program the following screen should appear. [BREPORT Main Menu] █File█ Format Change Add Delete Move About ╔════════╦═════════════════════════════════════════════════════════════════════╗ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Right/Left-Move Pointer ▓ ENTER-Select ▓ ESC-Exit ▓ At this point no report is loaded and the report view area is empty. You must load a database or report at this time, all other functions are unavailable until a report is loaded or started. Understanding the screen: The screen is divided in to three main sections, the main menu, the report layout view area, and the key assistance line. The main menu occupies the topmost line of the screen and is used for most user interaction. Screen sections: The report layout view area comprises all the boxed in screen area below the main menu and contains four sections 1-the report line type area in the upper left; 2-the report layout display area in the upper right; 3-the scale line type displayed in the lower left; 4-and the scale itself displayed in the lower right. View area sections: <2> The Aeolus BREPORT User Manual 1. The report line type area displays the type of report line dis- played on the screen line to the right and can be 'PgHdr#', 'Body#', or 'Subttl#'. These are for information only and the programs deals with them automatically. There is no work to perform in this screen area. 2. The report layout area, the largest boxed area, displays the report layout page header, body, and subtotal lines the report will contain. 3. The scale line type is always displays in the lower left box and is there only to note the scale to the right. 4. The scale will automatically scroll right or left with the report layour and is a display only area to assist in report design. To load a report move the highlight bar over the 'File' main menu option and press ENTER, this will present the File Submenu. <3> The Aeolus BREPORT User Manual MAIN MENU FILE OPTION [BREPORT File Sub-Menu] █File█ Format Change Add Delete Move About ╔═════════════════╗════════════════════════════════════════════════════════════╗ ║█Load Report█████║ ║ ║ Select Database ║ ║ ║ Generate Source ║ ║ ╚═════════════════╝ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Up/Down-Move Pointer ▓ ENTER-Select ▓ ESC-Exit ▓ The File Submenu has three options. 1. Load an existing report or create a new report. 2. Load a .DBF database fields for selection when entering expres- sions. 3. Create source code for the currently loaded report. <4> The Aeolus BREPORT User Manual MAIN MENU FILE OPTION - Load Report To load an existing report or create a new report use the up and down arrow keys and move the highlight bar over the 'Load Report' option and press ENTER. This will display the following screen. [BREPORT File/Load Report - Entry Window] █File█ Format Change Add Delete Move About ╔═════════════════╗════════════════════════════════════════════════════════════╗ ║█Load Report█████║ ║ ║ Select╔═══════════════════════════════╗ ║ ║ Genera║ Report: ████████████████████ ║ ║ ╚═══════║ ║ ║ ║ ╚═══════════════════════════════╝ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter Report Name ▓ ESC-Exit ▓ Type the name of the report you wish to load or create. If the report already exists it will be loaded, if not found it will be created. If you press ENTER with the field empty and there are .RPT files in the default directory a pick-list box will be displayed from which you may select a report to load. Press ESC to exit and remove the Report Dialog box from the screen. <5> The Aeolus BREPORT User Manual MAIN MENU FILE OPTION - Load Report If you are creating a new report or loading an uninitialized report a menu will be presented as follows. [BREPORT File/Load Report - New Report Type Selection] █File█ Format Change Add Delete Move About ╔═════════════════╗════════════════════════════════════════════════════════════╗ ║█Load Report█████║ ║ ║ Select╔═══════════════════════════════╗ ║ ║ Genera║ Report: DUMMY███████████████ ║ ║ ╚═══════║ ╔══════════╗ ║ ║ ╚═════════════════════║█Columns██║ ║ ║ ║ ║ Labels ║ ║ ║ ║ ║ Freeform ║ ║ ║ ║ ╚══════════╝ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Up/Down-Move Pointer ▓ ENTER-Select ▓ ESC-Exit ▓ From here you must select a report type to create. Pressing ESC from here exits and leaves an uninitialized report file on the disk. Select a Column report for reports with page and column headings and data that is placed under the appropriate columns. This will create a report similar to one created with REPORT FORM. Select a Labels report for printing mailing labels. Freeform reports a for creating anything else. When a report type is selected one of three dialogs will be presented, each report type has a different dialog. See the following screens. <6> The Aeolus BREPORT User Manual MAIN MENU FILE OPTION - Load Report Column report initialization dialog. [BREPORT File/Load Report - Column Report Initialization] █File█ Format Change Add Delete Move About ╔═════════════════╗════════════════════════════════════════════════════════════╗ ║█Load Report█████║ ║ ║ Select╔═══════════════════════════════╗ ║ ║ Genera║ Report: DUMMY███████████████ ║ ║ ╚═══════║ ╔══════════╗ ║ ║ ╚═════════════════════║█Columns██║ ║ ║ ║ ║ Lab╔══════════════════════════════════╗ ║ ║ ║ ║ Fre║ COLUMN REPORT OPTIONS- ║ ║ ║ ║ ╚════║ ║ ║ ║ ║ ║ Page Width: █80 ║ ║ ║ ║ ║ Lines per Page: █58 ║ ║ ║ ║ ║ Spaces Between Columns: █2 ║ ║ ║ ║ ║ Database Select: ████████ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Page Heading: ║ ║ ║ ║ ║ ████████████████████████████████ ║ ║ ║ ║ ║ ████████████████████████████████ ║ ║ ║ ║ ║ ████████████████████████████████ ║ ║ ║ ║ ║ ████████████████████████████████ ║ ║ ╠════════╬═════════════════════════║ ║════════╣ ║Scale1 ║ 1 2 ╚══════════════════════════════════╝ ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter Page Layout Information ▓ ESC-Abort ▓ Fill in the report initialization and press ENTER in the last field of the dialog to complete. Field descriptions: Page Width: The maximum number of characters that can be printed across your print- ers page. Lines per Page: The maximum number of lines you want on your report, including page and column heading lines. Spaces Between Columns: The number of empty spaces placed between each column of data on your report. Database Select: Enter the name of the database you want SELECTed when the source code is created. This is optional and you may want to code some of the <7> The Aeolus BREPORT User Manual database set up yourself. Page Heading: Up to four lines of page heading may be entered. Maximum width is 80 characters. The headings will be automatically centered on the page. <8> The Aeolus BREPORT User Manual MAIN MENU FILE OPTION - Load Report Label Report Initialization Options. [BREPORT File/Load Report - Label Report Initialization] █File█ Format Change Add Delete Move About ╔═════════════════╗════════════════════════════════════════════════════════════╗ ║█Load Report█████║ ║ ║ Select╔═══════════════════════════════╗ ║ ║ Genera║ Report: DUMMY███████████████ ║ ║ ╚═══════║ ╔══════════╗ ║ ║ ╚═════════════════════║ Columns ║ ║ ║ ║ ║█Labels███║ ║ ║ ║ ║ Fre╔══════════════════════════════════╗ ║ ║ ║ ╚════║ MAILING LABEL OPTIONS- ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Label Width: ██0 ║ ║ ║ ║ ║ Lines per Label: ██0 ║ ║ ║ ║ ║ Labels Across: 0 ║ ║ ║ ║ ║ Database Select: ████████ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════════════════════╝ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter Page Layout Information ▓ ESC-Abort ▓ Fill in the report initialization and press ENTER in the last field of the dialog to complete. Field descriptions: Label Width: If more than one label across enter the number of character from the beginning of the first label to the beginning of the one to the right. If only one label across enter the character width of the label. Lines per Label: Enter the number of lines from the top the one label to the top of the next. Labels Across: Enter the number of labels across the page that will be printed. Database Select: Enter the name of the database you want SELECTed when the source code is created. This is optional and you may want to code some of the <9> The Aeolus BREPORT User Manual database set up yourself. MAIN MENU FILE OPTION - Load Report Freeform report initialization dialog. [BREPORT File/Load Report - Free From Initialization] █File█ Format Change Add Delete Move About ╔═════════════════╗════════════════════════════════════════════════════════════╗ ║█Load Report█████║ ║ ║ Select╔═══════════════════════════════╗ ║ ║ Genera║ Report: DUMMY███████████████ ║ ║ ╚═══════║ ╔══════════╗ ║ ║ ╚═════════════════════║ Columns ║ ║ ║ ║ ║ Labels ║ ║ ║ ║ ║█Fre╔══════════════════════════════════╗ ║ ║ ║ ╚════║ FREE FORM OPTIONS- ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Page Width: █80 ║ ║ ║ ║ ║ Lines per Page: █58 ║ ║ ║ ║ ║ Database Select: ████████ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════════════════════╝ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter Page Layout Information ▓ ESC-Abort ▓ Fill in the report initialization and press ENTER in the last field of the dialog to complete. Field descriptions: Page Width: The maximum number of characters that can be printed across your print- ers page. Lines per Page: The maximum number of lines you want on your report, including page and column heading lines. Database Select: Enter the name of the database you want SELECTed when the source code is created. This is optional and you may want to code some of the database set up yourself. After the initialization options have been successfully entered, report <10> The Aeolus BREPORT User Manual text and expressions will be displayed in the report view area of the screen (large boxed in area above the 'Scale'). At first this will be underneath the File Submenu and Load Report dialog. For a further description of the report view area see the General Information section at the end of this chapter. Press ESC to remove the Report dialog. <11> The Aeolus BREPORT User Manual MAIN MENU FILE OPTION - Select Database Once the report is initialized you may optionally load a databases fields using the Select Database option of the File Submenu. Using up and down arrow keys position the highlight bar over the Select Database menu option and press Enter. The Database dialog will be presented, enter the name of a .DBF database you may use an extension, however, if you don't .DBF will be assumed. Press Enter with the field empty and a pick-list will be presented of all the .DBF databases in the current DOS default directory. Th following sample screen shows the Select Database dialog. [BREPORT File/Selct File - Entry Window] █File█ Format Change Add Delete Move About ╔═════════════════╗════════════════════════════════════════════════════════════╗ ║ Load Report ║ ║ ║█Select╔═════════════════════════════════╗ ║ ║ Genera║ Database: ████████████████████ ║ ║ ╚═══════║ ║ ║ ║ ╚═════════════════════════════════╝ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter Database Name ▓ ESC-Exit ▓ Once a valid database name is entered the following information window is displayed. <12> The Aeolus BREPORT User Manual MAIN MENU FILE OPTION - Select Database [BREPORT File/Select File - Fields Loaded Information Window] █File█ Format Change Add Delete Move About ╔═════════════════╗════════════════════════════════════════════════════════════╗ ║ Load Report ║ ║ ║█Select╔═════════════════════════════════╗ ║ ║ Genera║ Database: OPTIONS.DBF█████████ ║ ║ ╚═══════║ ╔════════════════════════════════╗ ║ ║ ╚════════════════║ ║ ║ ║ ║ ║ Fields Loaded for Selection ║ ║ ║ ║ ║ Any Key... ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════╝ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Press Any Key to Remove Box ▓ This indicates that the databases fields have been loaded into BREPORTs internal memory table, and when when the cursor is positioned on a report expression field the message 'F10 for Field List' will be dis- played and the F10 key will pop-up a pick-list of the fields in that database. Up to ten databases may be loaded for selection at a time. To load another, just type type .DBF name in the load database dialog. Press any key to remove the 'Fields Loaded' information box, then ESC at the Select Database dialog to return to the File Submenu. <13> The Aeolus BREPORT User Manual MAIN MENU FILE OPTION - Generate Source When you have completed your report layout, select the File Submenu option 'Generate Source' to create a .PR1 (.PRG) Clipper source code file. [BREPORT File/Generate Source - Dialog Window] █File█ Format Change Add Delete Move About ╔═════════════════╗════════════════════════════════════════════════════════════╗ ║ Load Report ║ ║ ║ Select Dat╔════════════════════════════════════════╗ ║ ║█Generate S║ File: DUMMY.PR1 ║ ║ ╚═══════════║ Ready to Generate Source? (Y/N) ║ ║ ║ ║ ╚════════════════════════════════════════╝ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Press Y for Yes or N for No ▓ After selecting the 'Generate Source' menu option a dialog will allow you one last chance to back out of this decision, Press the Y key to proceed and create the report source file or the N key to return to the File Submenu. The filename created will have the filename of the report named when you created the report (.RPT) file, however, the file extension will be .PR1. This file will be placed in the DOS default drive and directory. You can then edit this file as if it were any other Clipper source file. The file extension .PR1 is used instead of .PRG. This is to help pre- vent accidentally overwriting report source during development. <14> The Aeolus BREPORT User Manual MAIN MENU FORMAT OPTION Select the Format option from the main menu using the right and left arrows to move the highlight pointer to the second main menu option 'Format' and press Enter. This will present the Format Submenu like the following screen example. [BREPORT Format Sub-Menu] File █Format█ Change Add Delete Move About ╔═╔═══════════════════╗════════════════════════════════════════════════════════╗ ║ ║█Subtotal Grouping█║ ║ ║ ║ Page Layout ║ ║ ║ ╚═══════════════════╝ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Up/Down-Move Pointer ▓ ENTER-Select ▓ ESC-Exit ▓ The Format Submenu contains two options, 'Subtotal Grouping' and 'Page Layout', move the hightlight bar using the up and down arrow keys and press Enter on either option to present the dialog for it. Note: If you do not yet have a report loaded selecting either of the Format Submenu options will only display an error message. Be sure to load a report before using these options. <15> The Aeolus BREPORT User Manual MAIN MENU OPTION FORMAT - Subtotal Grouping. [BREPORT Format/Subtotal Grouping - Entry Window] File █Format█ Change Add Delete Move Columns About ╔═╔═══════════════════╗════════════════════════════════════════════════════════╗ ║P║█Subtotal Grouping█║ Aeolus Software ║ ║P║ Page Lay╔═══════════════════════════════════╗ Report Mak║ ║P╚═════════║ Group Expression: ║ Test Report Num║ ║PgHdr4 ║ ║ AUTH_NAM█████████████████████████ ║ From xx/xx/xx To ║ ║PgHdr5 ║ ║ Group Heading: ║ ║ ║PgHdr6 ║Fi║ "Author: "+auth_nam██████████████ ║hdate Test Column Subtotal ║ ║PgHdr7 ║--║ Page Eject After Group? (Y/N) █ ║----- ----------- -------- ║ ║Body1 ║FL║ ║ FLD3 SBTTL ║ ║Subttl1 ║ A╚═══════════════════════════════════╝ SBTTL ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter Group Info ▓ PgUp/PgDn-Prev/Next ▓ Ctrl+N/Ctrl+U-Ins/Del ▓ ESC-Abort ▓ The program will only allow subtotals on column type reports. You may enter up to 99 subtotal groupings. You will want your subtot- als to reflect the sort or index order of the database. The first sub- total being the first level sort, the second the second and so on to the desired level. Not using a sorted or indexed database or putting the subtotals in an incorrect order will cause your report to produce incorrect results. In the 'Group Expression' field enter the database field name or field expression that will trip the subtotal when it changes. In the 'Group Heading' enter a quoted literal and/or database field to print on the subtotal line. Press the Page Up and Page Down keys to move between the subtotals entered into the current report. Press Ctrl+N to insert a subtotal between two others. Press Ctrl+U to delete the displayed subtotal. <16> The Aeolus BREPORT User Manual Press ESC to exit the 'Subtotal Grouping' dialog. <17> The Aeolus BREPORT User Manual MAIN MENU OPTION FORMAT - Page Layout The 'Page Layout' option of the Format Submenu allows you to change the information you entered when the report was initialized. (See MAIN MENU FILE OPTION -Load Report Section to review the field settings) One of the following three screens will be displayed when this is selected depending on the report type. If a column type report was selected the following screen is presented. [BREPORT Format/Page Layout (Columns) - Modification Window] File █Format█ Change Add Delete Move Columns About ╔═╔═══════════════════╗════════════════════════════════════════════════════════╗ ║P║ Subtotal Grouping ║ Aeolus Software ║ ║P║█Page Lay╔══════════════════════════════════╗ Report Mak║ ║P╚═════════║ COLUMN REPORT OPTIONS- ║ Test Report Num║ ║PgHdr4 ║ ║ ║ From xx/xx/xx To ║ ║PgHdr5 ║ ║ Page Width: 132 ║ ║ ║PgHdr6 ║Fi║ Lines per Page: 58 ║thdate Test Column Subtotal ║ ║PgHdr7 ║--║ Spaces Between Columns: 2 ║------ ----------- -------- ║ ║Body1 ║FL║ Database Select: DATAFILE ║E FLD3 SBTTL ║ ║Subttl1 ║ A║ ║ SBTTL ║ ║ ║ ║ Page Heading: ║ ║ ║ ║ ║ Aeolus Software Company█████████ ║ ║ ║ ║ ║ Report Maker████████████████████ ║ ║ ║ ║ ║ Test Report Number One██████████ ║ ║ ║ ║ ║ From xx/xx/xx To xx/xx/xx███████ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════════════════════╝ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter Page Layout Information ▓ ESC-Abort ▓ <18> The Aeolus BREPORT User Manual MAIN MENU OPTION FORMAT -- Page Layout If a label type report was selected the following screen is presented [BREPORT Format/Page Layout (Labels) - Entry Window] File █Format█ Change Add Delete Move About ╔═╔═══════════════════╗════════════════════════════════════════════════════════╗ ║B║ Subtotal Grouping ║ ║ ║B║█Page Lay╔══════════════════════════════════╗ ║ ║B╚═════════║ MAILING LABEL OPTIONS- ║ ║ ║Body4 ║ ║ ║ ║ ║Body5 ║ ║ Label Width: 40 ║ ║ ║Body6 ║ ║ Lines per Label: 6 ║ ║ ║ ║ ║ Labels Across: 3 ║ ║ ║ ║ ║ Database Select: LBLFILE ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════════════════════╝ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter Page Layout Information ▓ ESC-Abort ▓ <19> The Aeolus BREPORT User Manual MAIN MENU OPTION FORMAT -- Page Layout If a freeform type report was selected the following screen is pre- sented. [BREPORT Format/Page Layout (Freeform) - Modification Window] █File█ Format Change Add Delete Move About Exit ╔═╔═══════════════════╗═════════════════════════════════════════════╡FTEST.RPT╞╗ ║P║ Subtotal Grouping ║ ║ ║P║█Page Lay╔══════════════════════════════════╗ ║ ║B╚═════════║ FREE FORM OPTIONS- ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Text Width: █80 ║ ║ ║ ║ ║ Margin: █0 ║ ║ ║ ║ ║ Lines per Page: █58 ║ ║ ║ ║ ║ Database Select: DATAFILE ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════════════════════╝ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter Page Layout Information ▓ ESC-Abort ▓ Make any changes to the options presented, the results will be shown on the report layout in the report view area. <20> The Aeolus BREPORT User Manual MAIN MENU OPTION CHANGE The 'Change' main menu option will allow you to modify a text literal or field expression that is already on the report layout. Select the 'Change' main menu option using the right and left arrow keys, move the highlight block over the 'Change' option and press Enter. The following prompt will be display where the main menu had been. -MOVE CURSOR ON FIELD TO CHANGE A cursor will be placed in the report layout area of the screen. Use the four arrow keys, Tab, Shift+Tab, Home, End and, if needed, Page Up and Page Down to move the cursor on any part of a text literal or field expression you want to change. Press Enter to present the change dialog. Press ESC to return to the main menu. Also, pressing the Ctrl+U key will delete the report layout line the cursor is on. The Ctrl+N key will insert a blank line after the cursor position Note: If you deleted all the Body lines of your report layout, insert- ing a line with the cursor positioned on the last PgHdr line will add a blank Body line. If you deleted all the PgHdr lines, you cannot get them back. This note does not apply to label report layouts. When you have selected a field to change one of the following two screens will be presented, depending on the field type. If a text literal is selected for change, that text will be placed in a dialog for editting, in the example below the text 'Page Nbr:' is being modified. The field cannot exceed 80 characters in length. Press ESC to exit without making the changes. <21> The Aeolus BREPORT User Manual MAIN MENU OPTION CHANGE [BREPORT Change - Modify Text Literal Window] File Format █Change█ Add Delete Move Columns About ╔═══════╔════════════════════════════════════╗═════════════════════════════════╗ ║PgHdr1 ║ Text Literal: Page Nbr:███████████ ║ Aeolus Software ║ ║PgHdr2 ╚════════════════════════════════════╝ Report Mak║ ║PgHdr3 ║ Test Report Num║ ║PgHdr4 ║ From xx/xx/xx To ║ ║PgHdr5 ║ ║ ║PgHdr6 ║Field One Field Two Test Insert Birthdate Test Column Subtotal ║ ║PgHdr7 ║--------- --------- ----------- --------- ----------- -------- ║ ║Body1 ║FLD1 FLD2 FLDI BDTE FLD3 SBTTL ║ ║Subttl1 ║ Author: +auth_nam SBTTL ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter/Modify Text for Selected Position ▓ ESC-Abort ▓ If a field expression was selected to be changed, the field information will be placed in a dialog for editting. In the example below the field 'RPG' is being changed. Field Descriptions: Field Expression: A valid Clipper expression, you may use functions, memory variables (remember to put them in your program), database fields, quoted literals or any combination as long as you create a valid expression. Data Type: The data type the expression will be, can be: C - Character N - Numeric D - Date L - Logical (Memo fields are not allowed) Width: Enter the total width the field will occupy on the report. <22> The Aeolus BREPORT User Manual Decimal: If the Data Type is Numeric, you may enter the number of decimal places the number on the report will occupy. Press ESC to exit without changes. [BREPORT Change - Modify Data Element Window] File Format █Change█ Add Delete Move Columns About ╔═══════╔════════════════════════════════════════╗═════════════════════════════╗ ║PgHdr1 ║ Field Expression: RPG█████████████████ ║ Aeolus Software ║ ║PgHdr2 ║ Data Type: N ║ Report Mak║ ║PgHdr3 ║ Width: ██3 ║ Test Report Num║ ║PgHdr4 ║ Decimal: █0 ║ From xx/xx/xx To ║ ║PgHdr5 ║ ║ ║ ║PgHdr6 ╚════════════════════════════════════════╝date Test Column Subtotal ║ ║PgHdr7 ║--------- --------- ----------- --------- ----------- -------- ║ ║Body1 ║FLD1 FLD2 FLDI BDTE FLD3 SBTTL ║ ║Subttl1 ║ Author: +auth_nam SBTTL ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter Field Information ▓ ESC-Abort ▓ After entering any changes, they will be displayed in the report lay- out. <23> The Aeolus BREPORT User Manual MAIN MENU OPTION ADD The 'Add' main menu option will allow you to add a new text literal or field expression to the report layout. Select the 'Add' main menu option using the right and left arrow keys, move the highlight block over the 'Add' option and press Enter. The following prompt will be display where the main menu had been. -MOVE CURSOR TO BLANK AREA FOR ADD A cursor will be placed in the report layout area of the screen. Use the four arrow keys, Tab, Shift+Tab, Home, End and, if needed, Page Up and Page Down to move the cursor to any blank area of the report lay- out. Press Enter at the leftmost position you would like to add the field, the Add Submenu will then be presented. Press ESC to return to the main menu. Also, pressing the Ctrl+U key will delete the report layout line the cursor is on. The Ctrl+N key will insert a blank line after the cursor position. Note: If you deleted all the Body lines of your report layout, insert- ing a line with the cursor positioned on the last PgHdr line will add a blank Body line. If you deleted all the PgHdr lines, you cannot get them back. This note does not apply to label report layouts. Add menu- <24> The Aeolus BREPORT User Manual MAIN MENU OPTION ADD [BREPORT Add Menu] File Format Change █Add█ Delete Move Columns About ╔════════╦════════════╔═══════╗════════════════════════════════════════════════╗ ║PgHdr1 ║Page Nbr: RP║█Text██║ Aeolus Software ║ ║PgHdr2 ║ ║ Field ║ Report Mak║ ║PgHdr3 ║ ╚═══════╝ Test Report Num║ ║PgHdr4 ║ From xx/xx/xx To ║ ║PgHdr5 ║ ║ ║PgHdr6 ║Field One Field Two Test Insert Birthdate Test Column Subtotal ║ ║PgHdr7 ║--------- --------- ----------- --------- ----------- -------- ║ ║Body1 ║FLD1 FLD2 FLDI BDTE FLD3 SBTTL ║ ║Subttl1 ║ Author: +auth_nam SBTTL ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Up/Down-Move Pointer ▓ ENTER-Select ▓ ESC-Exit ▓ Select the type of field to add to the report layout using the up and down arrow keys to move the highlight bar, press enter to select either 'Text' for a text literal or 'Field' to add a field expression. Press ESC to exit the add menu. If the 'Text' option is selected from the Add Submenu, the following screen is presented. <25> The Aeolus BREPORT User Manual MAIN MENU OPTION ADD [BREPORT Add/Text Entry Window] File Format Change █Add█ Delete Move Columns About ╔════════╦════════════╔═══════╗════════════════════════════════════════════════╗ ║PgHdr1 ║Page Nbr: RP║█Text██║ Aeolus Software ║ ║PgHdr2 ║ ║ Fi╔════════════════════════════════════╗ Report Mak║ ║PgHdr3 ║ ╚═══║ Text Literal: ███████████████████ ║Test Report Num║ ║PgHdr4 ║ ╚════════════════════════════════════╝om xx/xx/xx To ║ ║PgHdr5 ║ ║ ║PgHdr6 ║Field One Field Two Test Insert Birthdate Test Column Subtotal ║ ║PgHdr7 ║--------- --------- ----------- --------- ----------- -------- ║ ║Body1 ║FLD1 FLD2 FLDI BDTE FLD3 SBTTL ║ ║Subttl1 ║ Author: +auth_nam SBTTL ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter New Text for Selected Position ▓ ESC-Abort ▓ Type in the text you would like displayed at the location selected, Press Enter when finished or ESC to abandon the operation. The maximum width of the text can be 80 characters. <26> The Aeolus BREPORT User Manual MAIN MENU OPTION ADD If the 'Field' option is selected from the Add Submenu, the following screen is presented. [BREPORT Add/Field Entry Window] File Format Change █Add█ Delete Move Columns About ╔════════╦════════════╔═══════╗════════════════════════════════════════════════╗ ║PgHdr1 ║Page Nbr: RP║ Text ║ Aeolus Software ║ ║PgHdr2 ║ ║█Fi╔════════════════════════════════════════╗ Report Mak║ ║PgHdr3 ║ ╚═══║ Field Expression: ████████████████████ ║ Report Num║ ║PgHdr4 ║ ║ Data Type: █ ║x/xx/xx To ║ ║PgHdr5 ║ ║ Width: ██0 ║ ║ ║PgHdr6 ║Field One Field║ Decimal: █0 ║ Subtotal ║ ║PgHdr7 ║--------- -----║ ║ -------- ║ ║Body1 ║FLD1 FLD2 ╚════════════════════════════════════════╝ SBTTL ║ ║Subttl1 ║ Author: +auth_nam SBTTL ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter Field Information ▓ ESC-Abort ▓ Enter the fields in this dialog to add a field expression to the report layout. Field Expression: Field Expression: A valid Clipper expression, you may use functions, memory variables (remember to put them in your program), database fields, quoted literals or any combination as long as you create a valid expression. Data Type: The data type the expression will be, can be: C - Character N - Numeric D - Date L - Logical (Memo fields are not allowed) Width: Enter the total width the field will occupy on the report. <27> The Aeolus BREPORT User Manual Decimal: If the Data Type is Numeric, you may enter the number of decimal places the number on the report will occupy. Press ESC to exit abandon the operation. <28> The Aeolus BREPORT User Manual MAIN MENU OPTION DELETE The 'Delete' main menu option will allow you to remove a text literal or field expression that is already on the report layout. Select the 'Delete' main menu option using the right and left arrow keys, move the highlight block over the 'Delete' option and press Enter. The following prompt will be display where the main menu had been. -MOVE CURSOR ON FIELD TO DELETE A cursor will be placed in the report layout area of the screen. Use the four arrow keys, Tab, Shift+Tab, Home, End and, if needed, Page Up and Page Down to move the cursor on any part of a text literal or field expression you want to delete. Press Enter to present the delete dialog. Press ESC to return to the main menu. Also, pressing the Ctrl+U key will delete the report layout line the cursor is on. The Ctrl+N key will insert a blank line after the cursor position Note: If you deleted all the Body lines of your report layout, insert- ing a line with the cursor positioned on the last PgHdr line will add a blank Body line. If you deleted all the PgHdr lines, you cannot get them back. This note does not apply to label report layouts. When you have selected a field to delete one of the following two screens will be presented, depending on the field type. This dialog is presented if a text literal is selected for deletion. <29> The Aeolus BREPORT User Manual [BREPORT Delete/Delete Literal Dialog] File Format Change Add █Delete█ Move Columns About ╔════════╦══════════╔════════════════════════════════════╗═════════════════════╗ ║PgHdr1 ║Page Nbr: ║ Text Literal: Page Nbr:███████████ ║ Aeolus Software ║ ║PgHdr2 ║ ║ O.K. to Delete? (Y/N) ║ Report Mak║ ║PgHdr3 ║ ╚════════════════════════════════════╝ Test Report Num║ ║PgHdr4 ║ From xx/xx/xx To ║ ║PgHdr5 ║ ║ ║PgHdr6 ║Field One Field Two Test Insert Birthdate Test Column Subtotal ║ ║PgHdr7 ║--------- --------- ----------- --------- ----------- -------- ║ ║Body1 ║FLD1 FLD2 FLDI BDTE FLD3 SBTTL ║ ║Subttl1 ║ Author: +auth_nam SBTTL ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Press Y-Yes or N-No ▓ ESC-Abort ▓ <30> The Aeolus BREPORT User Manual MAIN MENU OPTION DELETE This dialog is presented if a field expression is selected for dele- tion. [BREPORT Delete/Delete Expression Dialog] File Format Change Add █Delete█ Move Columns About ╔════════╦══════════╔════════════════════════════════════════╗═════════════════╗ ║PgHdr1 ║Page Nbr: ║ Field Expression: RPG█████████████████ ║ Aeolus Software ║ ║PgHdr2 ║ ║ Data Type: N ║ Report Mak║ ║PgHdr3 ║ ║ Width: ██3 ║ Test Report Num║ ║PgHdr4 ║ ║ Decimal: █0 ║From xx/xx/xx To ║ ║PgHdr5 ║ ║ O.K. to Delete? (Y/N) ║ ║ ║PgHdr6 ║Field One ╚════════════════════════════════════════╝olumn Subtotal ║ ║PgHdr7 ║--------- --------- ----------- --------- ----------- -------- ║ ║Body1 ║FLD1 FLD2 FLDI BDTE FLD3 SBTTL ║ ║Subttl1 ║ Author: +auth_nam SBTTL ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Press Y-Yes or N-No ▓ ESC-Abort ▓ In either case, press the Y key to delete the field from the report layout, or press the N key to leave it alone. <31> The Aeolus BREPORT User Manual MAIN MENU OPTION MOVE The 'Move' main menu option will allow you to move a text literal or field expression that is already on the report layout. Select the 'Move' main menu option using the right and left arrow keys, move the highlight block over the 'Move' option and press Enter. The following prompt will be display where the main menu had been. -MOVE CURSOR ON FIELD TO MOVE A cursor will be placed in the report layout area of the screen. Use the four arrow keys, Tab, Shift+Tab, Home, End and, if needed, Page Up and Page Down to move the cursor on any part of a text literal or field expression you want to move. Press Enter to highlight the selected field. Press ESC to return to the main menu. Also, pressing the Ctrl+U key will delete the report layout line the cursor is on. The Ctrl+N key will insert a blank line after the cursor position Note: If you deleted all the Body lines of your report layout, insert- ing a line with the cursor positioned on the last PgHdr line will add a blank Body line. If you deleted all the PgHdr lines, you cannot get them back. This note does not apply to label report layouts. When you have highlighted a field to move the following prompt will appear where the main menu is normally positioned on the top line of the screen. -MOVE HIGHLIGHTED FIELD TO NEW POSITION Use the four arrow keys, Tab, Shift+Tab, Home, End and "C" keys to move the field to its new location. Pressing the "C" key will center the highlighted text on the report. Pressing PgUp or PgDn will highlight the previous or next field on the screen allowing that field to be moved. Press Enter or ESC when finished to return to the main menu. Note: You cannot move a field from the Body of a report to the Page Header of a report, or visa versa. If you need to make this type of move, Delete from one section and Add to the other. Warning for Column Reports: If you use this option to move a field originally entered from the main menu Column dialog, it is possible the field will be automatically repositioned. If you re-enter the Column dialog after moving such a field and either insert or delete a column, all fields attached to columns will be repositioned. <32> The Aeolus BREPORT User Manual MAIN MENU OPTION COLUMNS If a column type report has been loaded, the 'Columns' option will appear on the main menu. Select this option using the right and left arrow keys to move the highlight block over the 'Columns' option and press Enter. The Column dialog will then be presented. The column information initially presented in this dialog will be the leftmost column currently displayed in the report layout view area of the screen. All columns will be available for editting, press the Page Up key to edit the previous column or Page Down for the next. You may insert or delete a column by pressing the Ctrl+N or Ctrl+U keys respec- tively. The column dialog looks like the following: [BREPORT Columns Entry/Modification Window] File Format Change Add Delete Move █Columns█ About ╔════════╦═══════════════╔═══════════════════════════════════╗═════════════════╗ ║PgHdr1 ║Page Nbr: RPG ║ Column Heading: ║ Aeolus Software ║ ║PgHdr2 ║ ║ █████████████████████████████████ ║ Report Mak║ ║PgHdr3 ║ ║ █████████████████████████████████ ║ Test Report Num║ ║PgHdr4 ║ ║ Field One████████████████████████ ║From xx/xx/xx To ║ ║PgHdr5 ║ ║ ---------████████████████████████ ║ ║ ║PgHdr6 ║Field One Fiel║ Contents: ║olumn Subtotal ║ ║PgHdr7 ║--------- ----║ FLD1█████████████████████████████ ║----- -------- ║ ║Body1 ║FLD1 FLD2║ Data Type: C ║ SBTTL ║ ║Subttl1 ║ Author: +auth_║ Width: ██9 Decimal: █0 ║ SBTTL ║ ║ ║ ║ ║ ║ ║ ║ ║ Total/Average/None? (T/A/N) N ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════════════════════════════════╝ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╠════════╬═════════════════════════════════════════════════════════════════════╣ ║Scale1 ║ 1 2 3 4 5 6 ║ ║Scale2 ║....|....|....|....|....|....|....|....|....|....|....|....|....|....║ ╚════════╩═════════════════════════════════════════════════════════════════════╝ ▓ Enter Column Info ▓ Ctrl+N/U-Ins/Del ▓ PgUp/PgDn-Prev/Next ▓ ESC-Abort ▓ Column Heading: Enter up to four column heading lines in this area, up to a maximum width of 80 characters each. Contents: A valid Clipper expression, you may use functions, memory variables (remember to put them in your program), database fields, quoted liter- <33> The Aeolus BREPORT User Manual als or any combination as long as you create a valid expression. MAIN MENU OPTION COLUMNS Data Type: The data type the expression will be, can be: C - Character N - Numeric D - Date L - Logical (Memo fields are not allowed) Width: Enter the total width the field will occupy on the report. Decimal: If the Data Type is Numeric, you may enter the number of decimal places the number on the report will occupy. Total/Average/None. If the Data Type is specified as Numeric you may optionally enter T to total this column or A to average the column, otherwise enter N to disregard. Note: if any column contain totals report grand totals are automati- cally accumulated and these columns will be printed on any subtotal lines. Press Ctrl+U to delete the column you are editting. Press Ctrl+N to insert a new column ahead of the column you are edit- ting. Press ESC to exit, when the column dialog box is cleared the report view area will be updated displaying any changes made to the report. <34> The Aeolus BREPORT User Manual A WORD ABOUT GENERATED SOURCE ALL REPORTS: Source code for reports is generated with each report as a single self- contained procedure. Before the main report loop (default is a DO WHILE !EOF()) there is a section where report variables are initialized. The initialization section of column and freeform type reports will contain three report memory variables: RPG is the report page counter, I like to print this as the page number on report headings. RPG_LEN is used to set the aproximate lines on the printed page. NEW_PAG is a logical variable used when subtotals are to eject a page. The initialization section of label reports will contain three differ- ent report memory variables: LBL_ACRSS is the number of labels across a page to print. LBL_WDTH is the number of characters each label is wide. LBL_LEN is the number of lines each label is long. Two other memory variables may be used in the initialization section if you uncomment them: OTHM old thermometer, compared to see if it has changed. RECS thermometer variable to count records processed. There is a section of code generated at the start of the main report loop that is commented out. This code, if uncommented, will display a progression thermometer on the screen as the report prints. The ther- mometer should only be used if the report loop spins through the entire database, otherwise the report will finish before the thermometer. After the thermometer code an IF construct traps the ESC key and dis- plays a dialog box which asks if the report should be aborted. Following the ESC key trap is the comment '** SKIP/LOOP from here'. Immediately after this line is a good place to put IF constructs that filter database records that do not get printed. I usually do not use the SET FILTER TO ... command in reports because with a SET FILTER TO ... active the thermometer does not work properly. ABOUT COLUMN REPORT SOURCE CODE: Not including the items contained under 'ALL REPORTS'. Column reports contain at least two and as many as six primary sec- tions, these are, in the order they appear in the code: <35> The Aeolus BREPORT User Manual Section Name Location in Source Required -------------------------------- ----------------------- ------------ Subtotal Variable Initialization Before Main Report Loop Not Required Report Heading In Main Report Loop Required Subtotal Checking and Printing In Main Report Loop Not Required Report Detail Line Printing In Main Report Loop Required Subtotal Variables Incremented In Main Report Loop Not Required Subtotal and Total Printing After Main Report Loop Not Required The required items will always appear in the generated source code. In the case of Column reports the not required items appear only if col- umns are selected to be totaled or averaged. Only as much source code as is needed will be created, so the amount reports vary is quite limitless. Keep in mind that the 'core' logic of most reports will need to be modified as all reports are in a simple DO WHILE !EOF() loop. ABOUT LABEL REPORT SOURCE CODE: The generated label source code is a very forgiving piece of code, the three variables noted above provide enough flexibility to make minor adjustments without major difficulty. Label source is nearly identical for each one that is generated. The major sections are: Section Name Where Located Required ----------------------- ----------------------- ------------ Label Alignment Testing Before Main Report Loop Required Label Variable Loading In Main Report Loop Required Label Printing In Main Report Loop Required If you are printing to a laser printer it is usually advisable to delete the whole 'Label Alignment Testing' section of code. Except for that only database filtering code should be required. ABOUT FREEFORM REPORT SOURCE CODE: Freeform report source code is identical to column report source code except that total and subtotal code is never present. <36>