Run a JasperServer reprt via PHP and pass over the querystring.

Question

I'm using Web Services to run some reports created in iReport on JasperServer. Inside the .jrxml file I can see the xml that holds the SQL for the report. Is it possible to pass this querystring over to JasperServer via Web Services, instead of hard coding the definition inside the .jrxml file. This is the string I would build in PHP, then pass over to JasperServer to be used in the execution of the report.

              <queryString>
                <![CDATA[SELECT * FROM table WHERE j=2]]>
            </queryString>

Basically, I'm trying to find a way to dynamically create the SQL in PHP, then pass the SQL over to Jasper to run the report...is it even possible? Thanks.

Answer 1

Found out I could do this by setting up a parameter with $P!{query} instead of using $P{query}. The "!" makes the difference. Hope it helps someone else who comes along with the same problem.

Answer 2

hiii.........Ronedog......... hw r u........... I need the same solution.........can you mail me the full code if you can it'll be great help.........thanx......

mail me to [email protected] & [email protected] Moncy Mathai

Answer 3

Hi Ronedog,

can you pls send to me too? i wanna do the same thing. If it's ok, pls send to me at kurky17 AT yahoo.com.

Thank you!