home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Media Share 9
/
MEDIASHARE_09.ISO
/
progmisc
/
bldr10b.zip
/
BREPORT.DOC
< prev
next >
Wrap
Text File
|
1993-03-19
|
83KB
|
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>