Paginated Report Parameters

The parameters in the Produce a Paginated Report dialog allow you to control settings related to the appearance of the report; specify a title, subtitle, and footnotes for the report; and select the columns for which totals are shown.

General

Paper Size
Specifies the size of the page.

You should generally set this to the type of paper in your printer.

Orientation
Specifies whether the report should be printed portrait (tall and narrow) or landscape (short and wide).

For reports with just a few columns, portrait is probably best in that it allows more rows to fit on a page. For reports with many columns, landscape is best.

Borders?
When selected, specifies that the report should have lines around the table and between columns.
Shading
Specifies how alternate lines should be shaded. Line shading makes wide reports easier to read.
Page Numbers?
When selected, specifies that a page number should be included on the bottom of each page.

Titles & Notes

Report Title
The title that appears at the top of each page of the report.
Subtitle
The subtitle appears beneath the title.
Footnote(s)
Footnotes appear on the bottom of each page (just above the page number, if Page Numbers? is selected).

To enter more than one row of footnotes, type the first row, press Enter, type the second row, and so on. The input box will automatically scroll both horizontally and vertically.

You may include special codes in a title, subtitle, or footnote that serve as placeholders for certain values. When the report is produced, the placeholders are replaced with the corresponding values. For example, $PAGE is replaced with the page number and $PAGES is replaced with the total number of pages in the report. A reasonable subtitle could therefore be $PAGE of $PAGES. To include the current date and time on a report, use something like $MONTH/$DAY/$YEAR $HOUR:$MINUTE:$SECOND.

Here is a list of available placeholders:

$PAGE The page number of this page
$PAGES The total number of pages in the report
$YEAR The current year (e.g., 04 for 2004)
$MONTH The current month (e.g., 05 for May)
$DAY The current day of month (e.g., 06 for the sixth)
$HOUR The current hour (e.g., 15 for 3 p.m.)
$MINUTE The current minute (e.g., 05)
$SECOND The current second (e.g., 05)

When producing a report from the results of a Quick Query, the following placeholders are also available:

$QQPROMPT1 The user prompt for the first Quick Query input item
$QQPROMPT2 The user prompt for the second Quick Query input item
$QQPROMPTn The user prompt for the nth Quick Query input item
$QQINPUT1 The user's input for the first Quick Query input item
$QQINPUT2 The user's input for the second Quick Query input item
$QQINPUTn The user's input for the nth Quick Query input item

Fonts

Report Title
The font type and size for the title of the report.
Subtitle
The font type and size for the subtitle of the report.
Footnotes
The font type and size for the footnotes of the report.
Column Headings
The font type and size for the column headings of the report.
Column Data
The font type and size for the column data of the report.

Totals

You can show totals for one or more columns by selecting the columns here. Totals are shown at the end of the report and are sums.

Note: If a column has averages and you wish to show the average of the averages, you cannot do this in a report. Instead, use a tabulation to compute the average of the averages.

Advanced

Page Margins
The width of the page margins (top and bottom, left and right).
Column Separation
The width of the separation between columns.

Even with a separation of 0 inches, the data from two adjacent columns is separated by a small amount. For clarity, however, it is often better to use a wider separation.