passing the querystring from php to JasperServer

[ronedog]

I'm using Web Services to run some reports created in iReport on JasperServer.  Is it possible to pass the whole querystring that is located inside the XML?  For example, If I add the following string to my call to jasper from php can the report use this query to populate the data?

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

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

[lucianc]

You can have a report query of the form $P!{ReportQuery}, where ReportQuery is a report parameter.  Then you can pass a value to the parameter and it will be used as query.

Regards,

Lucian

[ronedog]

Great. Thanks!