Print

URL passed settings in Reporting Services

Thought I'd put a note on how to remove the toolbar using the URL as I didn't find this clear on the net. Tried it and it didn't work. That's because I was using the Reporting Manager URL rather than the Reporting Server URL.

Note:
  1. Change "<your_reportserver>" to the name of your Reporting Server
  2. Change "%2fMYREPORTS%2fDemos%2fRB+Report+for+Me" to the name and folder of your report.

To hide all except the report (default is True)
http://<your_reportserver>/ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render
&rc:Toolbar=False

To hide just the parameters (default is True)
http://<your_reportserver>/ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render
&rc:Parameters=False

To change the Rendering modes (defaults to HTML4.0)
http://<your_reportserver>/ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render
&rs:Format=XML
Where XML can be any of the following: HTML3.2, HTML4.0, MHTML, IMAGE, EXCEL, WORD, CSV, PDF, XML, defaults to HTML4.0

So to export to PDF in landscape
http://<your_reportserver>/ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render
&rs:Format=PDF&rc:PageWidth=11in&rc:PageHeight=8.5in

Or a clean export to PDF with minimal margins
http://<your_reportserver>/ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render
&rs:Format=PDF&rc:MarginTop=0.1in&rc:MarginRight=0.1in&rc:MarginBottom=0.1in&rc:MarginLeft=0.1in
Further rendering options: MS Reporting Services Device Information Settings

To specify the zoom configuration (defaults to 100%)
http://<your_reportserver>/ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render
&rc:Zoom=100%
Note: Where 100% can be page width in percent or whole page.

To show/hide the document map (default is true)
http://<your_reportserver>/ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render
&rc:DocMap=True

Specify a page (defaults to 1)
http://<your_reportserver>/ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render
&rc:Section=False

Jump to a Bookmark
http://<your_reportserver>/ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render
&rc:BookMarkID=1

Provide search criteria and find the first instance
http://<your_reportserver>/ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render
&rc:FindString=foo
Note: I have no idea what this is for.

Render a snapshot
http://<your_reportserver>/ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render
&rs:Snapshot=2004-03-30T15:45:02

Use a specific stylesheet (handy for customizing toolbars)
http://<your_reportserver>/ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render
&rc:Stylesheet=Htmlviewer_copy.css

Customize the Toolbar (Advanced)
To enter custom code for a report, view the report properties, the first field in Report Builder or Business Intelligence Development Studio (BIDS) is "Code". Click on the browse button next to it to edit.
Visit http://odetocode.com/code/128.aspx

Issues encountered
Note there appears to be an issue with regards to rendering. An updated and deployed report on the same day will render fine in a webbrowser but when exported to PDF format, it will retain the previously deployed report settings (header&footer). Resolved this by clearing my web-browser's temporary files. Do we instruct all users viewing the reports to do this? When does this report automatically expire?

Reminder on Paper Sizes
A4 = 8.27in (width) × 11.69in (height)
Letter = 8.5in (width) x 11in (height)
Switch width's for height to convert these to landscape.