Passing a parameter via URL to SQL Server Reporting Services

by

First, be sure to replace Reports/Pages/Report.aspx?ItemPath= with ReportServer?. In other words, instead of this:

http://server/Reports/Pages/Report.aspx?ItemPath=/ReportFolder/ReportSubfolder/ReportName

Use this syntax:

http://server/ReportServer?/ReportFolder/ReportSubfolder/ReportName

Parameters can be referenced or displayed in a report using @ParameterName, whether they’re set in the report or in the URL. You can attach parameters to the URL with &ParameterName=Value.

To hide the toolbar where parameters are displayed, add &rc:Toolbar=false to the URL (reference).

Putting that together, you can run a URL with embedded values, or call this as an action from one report and read by another report:

http://server.domain.com/ReportServer?/ReportFolder1/ReportSubfolder1/ReportName&UserID=ABC123&rc:Toolbar=false

In the report’s dataset properties query: SELECT stuff FROM view WHERE User = @UserID

In the report, set the expression value to [UserID] (or =Fields!UserID.Value)

Keep in mind that if a report has multiple parameters, you might need to include all parameters in the URL, even if blank, depending on how your dataset query is written. That means repeating the parameter name for multiple values of the same parameter, too.

To pass a parameter using Action = Go to URL, set expression to:

="http://server.domain.com/ReportServer?/ReportFolder1/ReportSubfolder1/ReportName&UserID="
 &Fields!UserID.Value 
 &"&rc:Toolbar=false"
 &"&rs:ClearSession=True"

Be sure to have a space after an expression if followed by & (a line break is isn’t enough). No space is required before an expression. This method can pass a parameter but does not hide it as it is visible in the URL.

If you don’t include &rs:ClearSession=True then the report won’t refresh until browser session cache is cleared.

To pass a parameter using Action = Go to report:

  • Specify the report
  • Add parameter(s) to run the report
  • Add parameter(s) you wish to pass (the parameters need to be defined in the destination report, so to my knowledge you can’t use URL-specific commands such as rc:toolbar using this method); however, I suppose it would be possible to read or set the Prompt User checkbox, as seen in reporting sever parameters, through custom code in the report)

For reference, see this page on URL encoding, e.g. / = %2f

More Related Contents:

  1. Passing parameter via url to sql server reporting service
  2. How to get Url Hash (#) from server side
  3. Characters allowed in a URL
  4. Adding a parameter to the URL with JavaScript
  5. How to get multiple parameters with same name from a URL in PHP
  6. When should I use a trailing slash in my URL?
  7. slashes in url variables
  8. What’s valid and what’s not in a URI query?
  9. Absolute urls, relative urls, and…?
  10. What does a dot mean in a URL path?
  11. Is it valid to have more than one question mark in a URL?
  12. url with multiple forward slashes, does it break anything?
  13. In a URL, should spaces be encoded using %20 or +? [duplicate]
  14. Access a URL and read Data with R
  15. What is the difference between URL parameters and query strings?
  16. What’s the best way to get the current URL in Spring MVC?
  17. How to check validity of URL in Swift?
  18. Encode / decode URLs
  19. COMPLETE list of HTML tag attributes which have a URL value?
  20. Why do some websites add “Slugs” to the end of URLs? [closed]
  21. Browser support for URLs beginning with double slash
  22. Weird characters in URL
  23. How do I choose the URL for my Spring Boot webapp?
  24. IIS URL Rewrite not working with query string
  25. URL for multiple markers in Google Maps
  26. Tomcat session management – url rewrite and switching from http to https
  27. URL Scheme for Phone Call
  28. GitHub source dynamic navigation
  29. The permissions granted to user ‘ are insufficient for performing this operation. (rsAccessDenied)”}
  30. How can I pre-populate html form input fields from url parameters?

Leave a Comment