FOOTING

The FOOTING keyword defines a page footing for the report. The synonym FOOTER may be used.

text	is the footing text to appear on each page.

A page footing defined with the FOOTING keyword will appear at the bottom of each page of the report. The footing text may contain control codes enclosed in single quotes to insert variable data or to alter the appearance of the footing. These control codes are:

B{n}	Insert data from the corresponding B control code in a BREAK.ON or BREAK.SUP option string. The optional single digit qualifier, n, defaults to zero if omitted.

C	Centres the current line of the footing text.

D	Inserts the date. The default format is dd mmm yyyy (e.g. 24 Aug 2005) but can be changed using the DATE.FORMAT command.

F{n}	Inserts the file name in a field of n spaces. If n is omitted, a variable width is used.

G	Inserts a gap. Spaces are inserted in place of the G control code to expand the text to the width of the output device. If more than one G control code appears in a single line, spaces are distributed as evenly as possible.

When a footing line uses both G and C, the footing is considered as a number of elements separated by the G control options. The element that contains the C option will be centered. The items either side of the centered element are processed separately when calculating the number of spaces to be substituted for each G option.

Hn	Sets horizontal position (column) numbered from one. Use of H with C or with a preceding G token may have undesired results.

I{n}	Inserts the record id in a field of n spaces. If n is omitted, a variable width is used.

L	Inserts a new line at this point in the text.

N	Suppresses pagination of the output to the display.

O	Reverses the elements separated by G tokens in the current line on even numbered pages. This is of use when printing double sided reports.

P{n}	Insert page number. The page number is right justified in n spaces, widening the field if necessary. If omitted, n defaults to four.

S{n}	Insert page number. The page number is left justified in n spaces, widening the field if necessary. If omitted, n defaults to one.

T	Inserts the time and date in the form hh:mm:ss dd mmm yyyy. The format of the date component can be changed using the DATE.FORMAT command.

A single quote may be inserted in the footing by use of two adjacent single quotes in the text.

If more than one FOOTING definition is given in a single query, the first one is used. This allows a query sentence to include a footing that will override an alternative footing in the default listing phrase.

FOOTING, FOOTER