locked
Passing Multivalue Parameter in URL in SSRS 2008 not working RRS feed

  • Question

  • I am trying to test the concept of passing multi value parameters from one report using the Action Property of a textbox to open another report is a new Window with the Multi Value parameter values already passed.

    The test involves the following:

    Report 1:

    1. Multi Value Parameter @ReportParameter1 has three Values: Value1, Value2, Value3

    2. Has a text box with the Action Property set to Go to URL with the following Expression:

    ="javascript:void(window.open('http://reportserver/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fReport2&rs:Command=Render&ReportParameter1="
    + JOIN(Parameters!ReportParameter1.Value,"&ReportParameter1=") + "'))"

    Report 2:

    1. Has Two Parameters @ReportParameter1 and @ReportParameter2

    2. @ReportParameter1 has Available Values as follows: Value1, Value2, Value3

        Does not have any default Values

    When I click on the textbox on Report1, it does navigate to Report2 but none of the Values are being set.

    Can someone please tell me what am I doing wrong or missing?

    Wednesday, June 17, 2015 5:33 PM

Answers

  • Hi BI Learner,

    According to your description, when you pass parameter values in go to URL action, the target report parameter box doesn’t contain passed parameter values, right?

    In Reporting Services, when we specify the go to URL action to access reports, we should use report server URL instead of report manager URL. In your scenario, the expression of Go to URL action should be specified like below:
    ="javascript:void(window.open('http://<server name>/ReportServer/Pages/ReportViewer.aspx?%2fReport+Project8%2fCopy+of+test0681pass+parameter&rs:Command=Render&ReportParameter1=" &join(Parameters!ReportParameter1.Value,"&ReportParameter1=")&"'))"

    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu


    Qiuyun Yu
    TechNet Community Support


    • Marked as answer by BI Learner Thursday, June 18, 2015 5:33 AM
    Thursday, June 18, 2015 4:11 AM

All replies

  • Hi BI Learner,

    According to your description, when you pass parameter values in go to URL action, the target report parameter box doesn’t contain passed parameter values, right?

    In Reporting Services, when we specify the go to URL action to access reports, we should use report server URL instead of report manager URL. In your scenario, the expression of Go to URL action should be specified like below:
    ="javascript:void(window.open('http://<server name>/ReportServer/Pages/ReportViewer.aspx?%2fReport+Project8%2fCopy+of+test0681pass+parameter&rs:Command=Render&ReportParameter1=" &join(Parameters!ReportParameter1.Value,"&ReportParameter1=")&"'))"

    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu


    Qiuyun Yu
    TechNet Community Support


    • Marked as answer by BI Learner Thursday, June 18, 2015 5:33 AM
    Thursday, June 18, 2015 4:11 AM
  • You need  to do it like this

    https://altecnotes.wordpress.com/2012/01/04/149/


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Thursday, June 18, 2015 5:24 AM
  • This totally worked like a charm.

    Thank you so much.

    • Proposed as answer by John9740 Friday, February 21, 2020 10:53 PM
    Thursday, June 18, 2015 5:33 AM