Blogs

SSRS Local Administrators Do Not Have Full Access in Report Manager and Report Server

I finally joined the rest of the civilized world on Windows 7 and so far have been very happy.  But I haven’t been able to get away from supporting a local development environment.  So I installed SQL Server 2005 on Windows 7 Enterprise including SQL Server Reporting Services and the rest of the services and everything configured properly (you still have to go through all of the IIS configuration before you can properly install SSRS, that information can be found in many other places).  After the installation and configuration I went to the Report Manager only to realize that I could not see the Site Settings link or any of the typical functionality and layout.  It appeared as if the administrator permissions were not getting through.  Next, I tried to access the Report Server URL only to get the typical error:

The permissions granted to user SERVERNAME\username' are insufficient for performing this operation. (rsAccessDenied)

SSRS Reusable Headers and Footers

Recently a client on SQL Server 2008 R2 asked me about the best practice for creating Page Headers and Footers that are easily maintained as they change relatively often.  With over 100 reports and ideally a few different footer templates I did a little brainstorming and research. 

The first thought that came to mind was subreports.  Unfortunately, you cannot add subreports to the Page Header or Page Footer.  Subreports could still work for some simple reports if they were placed above and below the tablix, but may not repeat on every page.  It could also potentially be placed inside the tablix, but then page breaking and displaying page numbers would be tricky.

Another thought was to use report templates.  This option works fine for the initial layout, but provides no help with changes to the headers and footers for existing reports down the road.

I finally found this blog post by Nick Ward which was an excellent start and became t