Passing database query at runtime to report

[sukirtha]

Hi,

I came to know that jasper allows sql query to be passed at runtime during report generation. However I could not obtain any sample to do the same. If any of you have an idea of how to this, please share it here.

My requirement is as follows,

 

Depending on the user's request, the query to be executed for a particular report will change. So I need to pass the sql query only during runtime.

 

Any help will be appreciated. Thanks in advance.

 

Warm Regards,

Sukirtha Joseph

[lucianc]

You can pass the report query string via a parameter:

Code:

<!-- the JRXML -->
<parameter name="Query" isForPrompting="false"/>
<queryString>$P!{Query}</queryString>

<!-- the fill code -->
String query = "select ...";
params.put("Query", query);
JasperFillManager.fillReport(report, params, connection);

 

HTH,

Lucian