SSRS Fields cannot be used in page headers or footers, ssrsfooters

SSRS Fields cannot be used in page headers or footers, ssrsfooters

Problem Environment: SSRS 2005 report development

 

The following error occurs when you try to use the Data Set field in the Page Header:

 

The value expression for textbox ''refersto a field. Fields cannot be used in page headers or footers.

 

Solution:

 

1. Enter a text box named text1 on the Page body Page and assign values using the data set field.

 

2. Drag a text box into the page header and use ReportItems to display the text value of step 1. The expression is ReportItems. text1.value.

 

3. Hide text1 of step 1 to solve the problem.

 

For more information about ReportItems, see: http://msdn.microsoft.com/zh-cn/library/dd255285.aspx

 

In version 2008 or later, you can drag the Data set field into the page header without this error.