Footers in client report definition (RDLC) report layouts have limitations that require you to add hidden fields to the body of the report that contain the data that you want to display in the footer. The field in the footer references the hidden field in the body. For more information about headers and footers, see.
Before you begin this procedure, you must create a layout suggestion for the report. For more information, see.
To redesign page footers
Add a hidden field to the body section of the report. The SourceExpr field should contain the field that you want to use in the footer. For more information, see.
In Object Designer, click Report, select the report, and then click Design.
In the Classic client, on the View menu, click Layout.
In Microsoft Visual Studio, on the Report menu, click Page Footer to create a page footer in the RDLC report layout.
To display data in the footer from the hidden field that you created in step 1, use ReportItems. For example, use the following to get the value of a text box.
In this example, MyTextBox is the name of the text box that you created in step 1.
Save and compile the report. For more information, see.