Page Setup dialog: Header/Footer tab

Use this dialog to add a header or footer to a printed worksheet. For example, you might want to add a report author details or the date and time to the top of a worksheet. For a detailed example of a worksheet with a header and footer, see "About elements of a printed worksheet in Discoverer Plus Relational".

Note: A header or footer that you create is displayed on the printed worksheet but is not displayed on-screen.

Hint: Ensure that the header margin size and footer margin size specified on the "Page Setup dialog: Margins tab" are big enough to print the header and footer that you specify.

For more information, see:

"What are Page Setup options"

"About elements of a printed worksheet in Discoverer Plus Relational"

"How to print Discoverer worksheets"

Header

Use these fields to create a header at the top of the worksheet. For example, you might want to print the date and time at the top of the worksheet. The header is printed on every page above the worksheet title (if printed) and worksheet body.

Border Below

Use this drop down list to print a solid line below the header to separate the header from the rest of the worksheet (for example, worksheet title, worksheet data, graph).

Insert

Use this button to display a drop down list of text variables (for example, date, time) that you can insert into the Left, Center, and Right fields for the header (for more information about variables, see "Notes" below).

Hint: Before you insert a text variable, click inside the Left, Center, or Right fields for the header, then click Insert.

Font

Use this button to display the "Header/Footer Font dialog", which enables you to select a font style for the header.

Left/Center/Right

Use these fields to enter text you want to appear in the header. You can enter text and variables. For example, to display the text Weekly Report at the left of the header, click inside the Left field and type Weekly Report.

Footer

Use these fields to create a footer at the bottom of the worksheet. For example, you might want to print the name of the worksheet creator at the bottom of the worksheet. The footer is printed on every page below the worksheet text area (if printed) and worksheet body.

Border Above

Use this drop down list to print a solid line above the footer to separate the footer from the rest of the worksheet (for example, worksheet text area, worksheet data, graph)

Insert

Use this button to display a drop down list of text variables (for example, date, time) that you can insert into the Left, Center, or Right fields for the footer (for more information about variables, see "Notes" below).

Hint: Before you insert a variable, click inside the Left, Center, and Right fields for the footer, then click Insert.

Font

Use this button to display the "Header/Footer Font dialog", which enables you to select a font style for the footer.

Left/Center/Right

Use these fields to enter text you want to appear in the footer. You can enter text and text variables. For example, to display Weekly Report at the left of the footer, place the cursor in the Left field and type Weekly Report.

Print Preview

Use this button to display the "Print Preview dialog", which enables you to check that the layout is correct before you print the worksheet.

OK

Use this button to close the Page Setup dialog and return to the previous dialog. Discoverer applies the Page Setup options for the current session. To save the Page Setup options permanently for the selected worksheet, you must save the workbook (for more information, see "How to save workbooks").

Notes

  • A variables is prefixed with an ampersand character (&) in the Left, Center, or Right fields. The value of a variable is updated when the worksheet is printed. In other words, if you display the &Time variable on a worksheet, the time value is updated each time the worksheet is printed. For example, if you insert the &Time variable into a header, Discoverer prints '08.30.00 AM' if you print the worksheet at eight-thirty in the morning and '12.00.00- PM' if you print the worksheet at midday.