John Chapman

How To SharePoint
Sep 8, 2011
John Chapman
No Comments

[SQL Reporting Services 2008 R2] Hide Header, Toolbar, or Parameters When Viewing in SharePoint Integrated Mode

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit

I have a number of instances where SSRS reports are displayed through Page Viewer Web Parts in SharePoint. When doing so, I like to only display the report, not the header, toolbar, or parameters section. You can hide them by appending these query strings to the URL:

rv:HeaderArea=None
rv:ToolBar=None
rv:ParamMode=Hidden

For example:

http://{SHAREPOINT_SITE}/_layouts/ReportServer/RSViewerPage.aspx
?rv:RelativeReportUrl=/Reports/report.rdl&rv:HeaderArea=None&rv:ToolBar=None
&rv:HeaderArea=None&rv:ToolBar=None&rv:ParamMode=Hidden

That’s it.

Source

Related content:

  1. [SQL Reporting Services 2008 R2] Enable Remote Errors
  2. [SharePoint 2010] SQL Reporting Services Report Builder Cannot Connect in SharePoint Integrated Mode
  3. [SharePoint 2010] Cross-Domain Proxy Page for Client-Side Scripts
  4. [SharePoint 2010] FIMSynchronizationService Errors After SP1 Install – Microsoft SharePoint is not supported with version 4.0.30319.235 of the Microsoft .Net Runtime
  5. [SharePoint 2010/2007] Get the User Who Created a List or Library
Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit

John Chapman

Hello, I'm John Chapman. I am a SharePoint developer living in Denver, Colorado. I develop solutions using ASP.NET, C#, jQuery, SQL, SharePoint, etc, and I thrive on the challenge of writing code to overcome the impossible, annoying, or otherwise difficult obstacles.

More Posts - Website - Twitter

Leave a comment

John Chapman