Is it possible to do a dynamic query in iReport so that the SQL is passed in at runtime instead of saving it in a jrxml file? If so please demonstrate how.
So, I'm using iReport and trying to pass in a query dynamically at runtime as a parameter.
Rationale: The rationale in my case is that this query is used somewhere else in my java application so instead of hardcoding the same query I would rather just get it from java and pass it in as a parameter so I don't have to maintain two synced up copies.
However, even trying to pass in a simple query like "select dummy from dual" chokes.
JRXML looks like this
<parameter class="java.lang.String" name="dynamicQuery"> <querystring language="SQL"> <!--[CDATA[$P{dynamicQuery}]]--> </querystring> <field class="java.lang.String" name="DUMMY"></field> </parameter>
But when I do it I get an errror below.
Even when I do a simple test like select
Caused by: java.sql.SQLException: Invalid SQL type at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:209) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:76) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:972) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1192) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3460) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:137) ... 11 more Print not filled. Try to use an EmptyDataSource...
