Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Pass Multiple Values in a single parameter to a SSRS 2008 Report from PHP Expand / Collapse
Author
Message
Posted Monday, March 18, 2013 10:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 30, 2014 2:09 PM
Points: 29, Visits: 135
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
Post #1432266
Posted Wednesday, March 20, 2013 3:57 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 30, 2014 2:09 PM
Points: 29, Visits: 135
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.
Post #1433529
Posted Thursday, April 4, 2013 3:49 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 30, 2014 2:09 PM
Points: 29, Visits: 135
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.
Post #1439035
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse