[Dataset Parameters]

I also have the same scenario can you please help in this.

 

I have query say select c1,c2 from table 1 where c1='100';

I will form this complete query in java and i want to pass this as an parameter to dataset in jasper.

 

i am getting the below error.

Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : report_I18LTest_mubl_dataSet_1371621283684_821026

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:143)

at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:684)

at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605)

at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:901)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)

at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:609)

at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59)

at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:205)

at java.lang.Thread.run(Thread.java:662)

Caused by: java.sql.SQLException: SQL string is not Query

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1464)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)

at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:137)

 

[[Resolved] Table Component: Merge cell]

HI,i wanted to do in tables.....if repeated values are there then they should be merged.Can anyone help me

[Merge cells based on condition in table - excel export]

Hi,Even i need same help but with tables.....if repeated values are there then they should be merged.Can anyone help me

[Merging Rows of a table]

HI,i wanted to do in tables.....if repeated values are there then they should be merged.Can anyone help me