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.
Category: SQL Server Reporting Services :: Article: 322

Add comment

Your rating:

Submit

Credit where Credit is Due:


Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

Accreditation

Badge - Certified Zoho Creator Associate
Badge - Certified Zoho Creator Associate

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.