Report Solution Patterns and Recipes - Professional SQL Server 2005 Reporting Services - page 303

Figure 7-41

Using Field Values in Page Headers and Footers
Another limitation of the Reporting Services architecture is its inability to add data-bound items to page
headers and footers. The reason for this is that the pagination of a report occurs after the data has been
rendered. During the page formatting pass, items in the page header and footer areas have access to
already rendered report items but not to data fields.

What you'll need:

❑ One or more hidden text boxes in the body of the report body.

❑ Text boxes in the page header or footer used to present field values.

❑ Expressions used to repeat values from the hidden item(s).