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 Understanding Headers and Footers.

Before you begin this procedure, you must create a layout suggestion for the report. For more information, see How to: Create a Layout Suggestion.

To redesign page footers

  1. 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 How to: Add and Identify Hidden Fields.

  2. In Object Designer, click Report, select the report, and then click Design.

  3. In the Classic client, on the View menu, click Layout.

  4. In Microsoft Visual Studio, on the Report menu, click Page Footer to create a page footer in the RDLC report layout.

  5. 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.

      CopyCode imageCopy Code 
    =ReportItems!MyTextBox.Value

    In this example, MyTextBox is the name of the text box that you created in step 1.

  6. Save and compile the report. For more information, see How to: Integrate Classic Client Report Designer and Visual Studio Report Designer.

See Also