Pass Multiple Values in a single parameter to a SSRS 2008 Report from PHP

  • I have a PHP page that performs some table updates for me for a particular record. I am passing the necessary parameters from my SSRS 2008 report to this PHP page, and would like to then pass these parameters back to the report and re-render it. I need to pass back in the URL. When I pass a single value, the report renders fine. The SSRS report is being run in an iFrame, which is why I need to pass back through an URL.

    Here is a sample of the URL as I'd like to see it:

    http://server/jamey/report.php?report=test&status=A&budget=5000&dept=BS,ZA&arrange=004,006,010

    parameters dept and arrange are multi value parameters. I know that passing these values comma delimited won't work, nor will putting them in quotes, etc...

    If I understand how I need to form the URL so the report will render with multiple values, I should be fine. Just cannot figure that part out.

    Any questions, please let me know.

    Thanks,

    Jamey

  • Another way to think of this is as such: I can pass the variables back to the report; I'm just unable to check the boxes of those variables. I am able to default multiple options in the multi-select variable by using a query. I would think something along those same lines would work, only specifying the variables I'm passing back to the report.

  • For those who this may help, I ended up creating a second version of the report. And then I passed the comma-delimited values to the second report and rendered that.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply