Sudhakarkmt

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)

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

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

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