Common SSRS URL Commands

Another page for your cookbook 🙂 (source)

&rc:Parameters=Collapsed
• This collapses the parameter bar but sends the parameters in the URL in the browser

&rc:Parameters=true
• This shows the parameter bar and is the default

&rc:Parameters=false
• This prevents the parameters from being passed in the browser and expanded

&rc:Toolbar=false
• This hides the toolbar

&rc:Format=PDF
• This will open up the report as a PDF, other examples are: HTML3.2, HTML4.0, HTMLOWC, MHTML, IMAGE, EXCEL, CSV, PDF, XML

&rs:Format=EXCEL&rc:OmitFormulas=true
• This will open the report in Excel

&rc:Zoom=Page Width
• This will open up the report in full width of the page

rs:ClearSession=true
• This clears the session state for the user. Used where the caching of the report prevents the designer from seeing their updated report and/or data. * This is a very important parameter to know as more often than not, the report data doesn’t update immediately unless parameters are changed, and your report may show cached data if this is not set.

&rc:StyleSheet=MyCustomStyle
• Note don’t add the .css extension. And this style sheet must be in the folder Program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportServerStyles folder.
• Use the HTMLViewer.css as your base template.

More info on MSDN.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s