canuckconsulting
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?
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?
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.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect...thanks!
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).