Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

add report header/footer to report Expand / Collapse
Author
Message
Posted Monday, March 17, 2014 4:06 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:17 AM
Points: 362, Visits: 422
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?
Post #1551953
Posted Monday, March 17, 2014 5:36 PM This worked for the OP Answer marked as solution
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 10:48 PM
Points: 697, Visits: 4,478
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.
Post #1551964
Posted Monday, March 17, 2014 11:47 PM This worked for the OP Answer marked as solution
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 11:46 PM
Points: 17, Visits: 30
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.


  Post Attachments 
Add Report Header & Footer.jpg (10 views, 42.90 KB)
Post #1552002
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse