add report header/footer to report

  • In an existing ssrs 2008 r2, it looks like the report does not contain a page header. When I try to place the following code into the report:

    =Globals!ReportName & Chr(10) & "Run Date:" & Globals!ExecutionTime

    =Globals!PageNumber & " of " & Globals!TotalPages

    I get an error message that says globals can only be added to report headers or footers.

    Thus can you tell me how to add a report header and a footer into an existing report? Is this an insert item, is it something that you can drag onto the designer surface?

  • Can't remember SSRS2008R2 really well, but I think it's pretty similar to 2010. Right-click on the design surface of your report, select Insert and at the very bottom of the dropdown, you can select Header/Footer.

  • In 2008 R2, you can add page header & footer.

    Select Report -> From Menu Bar Select Report - > There you can find Add Header / Add Footer.

    Please go through the attachment.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply