Is it possible to use a $P{xxxxx} parameter for a complete query string

[giovannino]

Hi all,

I'm wondering if it's possible to use  only a parameter like  $P{pdf_query} to pass a complete query from php program.

For istance  "SELECT * FROM TABLE XXXXX".

Or parameter can only be use to pass a variable of a select yet recorded on Ireport

 

I've tried but I got this error.

net.sf.jasperreports.engine.JRException: Error executing SQL statement for : data
 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240)
 at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1112)
 at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:689)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:900)
 at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:152)
 at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:464)
 at com.jaspersoft.studio.data.reader.DatasetReader.start(DatasetReader.java:184)
 at com.jaspersoft.studio.property.dataset.dialog.DataPreviewTable$4.run(DataPreviewTable.java:250)
 at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'null' at line 1
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
 at java.lang.reflect.Constructor.newInstance(Unknown Source)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
 at com.mysql.jdbc.Util.getInstance(Util.java:386)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
 at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313)
 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233)
 ... 9 more

[sambitgudu]

Yes it is possible. In your case you are missing '!' , it should be look like

$P!{pdf_query}

[dfloresgonz]

select * from mytable m $P!{query_string}

where $P!{query_string} is for example WHERE m.FIELD like '%somevalue%'

[giovannino]

OK Thanks !!