Reports created with INFO/ACCESS generally include headings. By default, a heading consisting of the page number and the current time and date prints at the top of every page. The end-of-list message appearing at the end of a report is also considered part of the heading. INFO/ACCESS reports do not by default produce footings (text at the bottom of every page).
Define the text that appears at the top and bottom of every page of a report by including the HEADING and FOOTING modifiers in an INFO/ACCESS query. Enclose the desired heading or footing text in double quotes and enter it immediately after the appropriate modifier.
For example, this phrase specifies a heading that reads JANUARY SALES and a footing that reads PRELIMINARY:
|
HEADING "JANUARY SALES" FOOTING "PRELIMINARY" |
There are a number of additional parameters that may be included in headings and footings, and are specified with the one- and two-character options shown in the table below.
|
Option |
Description |
|
B |
When used with the B option of the BREAK-ON modifier, inserts data from the attribute specified in the report heading. |
|
Bn |
When used with the B option of the BREAK-ON modifier, inserts data from the attribute specified in the report heading, left-justified, in a field of n blanks. |
|
C |
Centers the heading or footing. When used with the L option, centers the specified line. |
|
D |
Inserts the current date in the heading or footing, using the form dd mmm yyyy. |
|
F |
Inserts the name of the file being accessed. |
|
Fn |
Left-justifies the name of the file being accessed in a field of n blanks. |
|
L |
Starts a new line in the heading or footing. Use this option to create multiple-line text. |
|
P |
Inserts current page number, right-justified in a field of four blanks. |
|
Pn |
Inserts current page number, left-justified in a field of n blanks. |
|
T |
Inserts the current time and date in the heading or footing in the form hh:mm:ss dd mmm yyyy. The time is shown in 24-hour format. |
|
'' |
Prints a single quote in the text of the heading or footing. These are two single quotes. |
Include options within the heading or footing text (i.e., within the double quotes) and enclose them singly or as a group in single quotes.
The following topics are presented:
Suppressing the Default Page and Column Headings
See Also
Formatting INFO/ACCESS Reports