URL Parameters Used in Reporting Services

This article shows you some of the most common reporting parameters to use in Microsoft SQL Server Reporting Services.

When you go to the http://reportserver/reportserver/foldername/reportname

The last command in the url is &rs:Command=Render

You can add some other commands as follows:

&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

    • &rs:Format=EXCEL&rc:OmitFormulas=true

  • This will open the report in Excel

    • 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