Link to home
Start Free TrialLog in
Avatar of canuckconsulting
canuckconsultingFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SSRS Sharing headers and footers between reports

I am creating a data warehouse and would like to use a standard header and footer across all the reports.  Ideally this would be a dynamic link so that all reports would reflect any changes made to the shared header and footer.

I found this  

link discussing a solution involving creating a script to update the text in each of the RDLs.  This would work but I'm surprised that SSRS doesn't offer a more elegant solution.  Do I have any alternatives to this brute force approach?
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

That's a great hack being described through that link.  And unfortunately that's about the only way you could possibly achieve this.  Unfortunately SSRS does not have this functionality built in...

Another option might be using images where you'd replace the existing (external!) image with an updated one but they also have their limitations.  They don't always render crispy clear and you'd need to take the dimensions into account (you don't want the new image to get stretched or cut off for instance).
I haven't used this myself but isn't this what report parts are for?
http://technet.microsoft.com/en-us/library/ee633670(v=sql.105).aspx#PublishingComponents

http://technet.microsoft.com/en-us/library/dd239352.aspx
It says "You cannot publish the report items within the rectangle as report parts. When people add the rectangle to a report, they get the rectangle and the items it contains.".

So I'd say try to put the header and the footer inside a rectangle and publish those as report parts. Then use those parts on your other reports.
Avatar of canuckconsulting

ASKER

Are report parts only available in conjunction with SharePoint?  I'm hosting these reports on a site directly so can't (to my knowledge) leverage any SharePoint functionality.
ASKER CERTIFIED SOLUTION
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Perfect...thanks!