|Downloading Data | Download as a PDF ||
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.
You should generally set this to the type of paper in your printer.
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.
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|
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.
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.