Can We Pass An Sql Query String As A Param Into Report?

Can we pass an sql query string as a param into JasperReports report? I want the query string be passed as a simple String type parameter into the report at run-time and the fields

Solution 1:

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>