Passing Multiple values to SSRS via a URL RRS feed

  • Question

  • I have a report in SSRS 2008 with a drill through report which I invoke from an URL. I need to pass the values of a paramater that may have multiple values selected via the URL. Is there a way to convert the parameter's values to something that I can pass via the URL?
    Friday, January 15, 2010 3:43 PM


All replies

  • To pass the parameters explicitly, try this:


    Otherwise, if you want to pass parameters that are pre-existing in the originating report, try something more like:


    Friday, January 15, 2010 6:35 PM
  • The problem is not passing single value parameters. To use your sample if Parameter1 was configured to allow multi select and the user have selected more than one value, how can I pass all the selected values to the target report's Param1 parameter? ...Param1="+Parameters!Parameter1.Value(0)+ "," + Parameters!Parameter1.Value(1)... does not work

    Friday, January 15, 2010 9:32 PM
  • Use Join function. It depends, an example would be: =Join(Parameters!Parameter1.Value, ",")

    To construct a URL, use like Aaron example:
    ="http://<servername>/Reportserver?%2fFolderName%2fReportName&rs:Command=Render&Parameter1=" & Join(Parameters!Parameter1.Value, "&Parameter1=")

    Chicagoan ...
    • Proposed as answer by Jerry Nee Monday, January 18, 2010 2:46 AM
    • Marked as answer by Ockert Labuschagne Wednesday, January 20, 2010 4:51 PM
    Friday, January 15, 2010 9:49 PM