can we pass an sql query string as a param into report?

Can we pass an sql query string as a param into Jaspe开发者_Go百科rReports report? I want the query string be passed as a simple String type parameter into the report at run-time and the fields returned by this query be available for this report; is it possible ?

Mannyee, yes of course, you can pass the formed SQL query.
It can be something like this:

<parameter name="queryString" isForPrompting="true" class="java.lang.String">
...
<queryString><![CDATA[$P!{queryString}]]></queryString>