Add a header or footer to a report or list

Add a header or footer to make a report easier to read. Headers and footers are containers in which you can add objects like text, images, and report expressions such as the current date and page numbers. You can add headers and footers to pages and lists.

Tip: The Revenue by Product Brand (2011) sample report in the Sales and Marketing (cube) package includes a customized header and footer.

Add a page header or footer when you want information to appear on every page in the report, such as a title or page numbers. You can use combinations of text, data items, and report expressions in titles.

You can add the following headers and footers to lists to organize data into logical sections or to identify every change in value of a column.

Type	Description
List page header	Adds a header that appears at the top of the list on every page in which list data appears.
Overall header	Adds a header that appears once at the top of the list.
Group or section header	Adds a header that appears for each group of a grouped column or each section.
Group or section footer	Adds a footer that appears for each group of a grouped column or each section.
Overall footer	Adds a footer that appears once at the bottom of the list.
List page footer	Adds a footer that appears at the bottom of the list on every page in which list data appears. Note that summary calculations in list page footers only summarize the data that is visible on that page of the list report.

You can also add section footers by adding a summary.

Before you begin

To see the headers and footers, ensure that the visual aids are turned on.

Procedure

If you want to add a page header or footer, from the report object toolbar, click the More icon , click Headers & footers > Page header & footer, select the appropriate check boxes, and click OK.
If you want to add a list header or footer, from the report object toolbar, click the More icon , click Headers & footers > List headers & footers, select the appropriate check boxes, and click OK.
If you want to add objects to a header or footer, click the Toolbox icon and drag the objects to the appropriate location.

To add objects to a list header or footer, you must first unlock the report. Click the More icon , then click the Locked icon .

Tip: To add data items to the page header or footer, you must associate a query to the page.
To split a header or footer into multiple cells that span the list, select the cell to be split and then, from the report object toolbar, click the Split cell icon .
To merge multiple cells in a list header or footer, select the cells that you want to merge, and, from the report object toolbar, click the Merge cells icon .