raghupathiraja.arumugam

In Image properties, have to change Scale Image's property value as Fix Frame. Then the images fitting in the frame, what we given. Thank You!!!

Hi All, I wanna generate reprot with 3 different images in TOP,LEFT and Right sides of the detail band. I am using Background band to display images and for that i created Supreport to include the Imgaes. In the Subreport i used image from palatte's options. Now i am able to get the images in the report is fine . But the size of the images are affecting my detail band. So i tried to resize the Image from the jasper tool but while generating report the original image got affected and displaying small one. My requirement is, the input images should fix in the image size, what i have given in the jasper designer. Please help me out fo this one and suggest me for the same. Thanks!!!

Thanks for the answer. Yes, I am also think like that only. But i got more than 2 Lack reports successfully, after that i got this issue. i thinks database problem like some one refreshing table or truncating table etc., But i am also in doubt and try to find out the solution.

Hi, i am new to jasper reports. I have developed a application to generate reports with the use of JASPER Code from java. I have compiled jrxml file and got object from that and passing that obect to generate reports. I got more than 2Lack reports and after that got following exception and stopped process. net.sf.jasperreports.engine.fill.JRFillSubreport : prepare - Fill 2145049582: exception net.sf.jasperreports.engine.JRException: Error executing SQL statement for : subForMain at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:207) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:741) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:639) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1238) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:869) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:813) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:639) 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: ORA-00942: table or view does not exist at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:201) ... 9 more 2013-01-03 12:07:00,858 net.sf.jasperreports.engine.fill.JRFillSubreport : prepare - Fill 519518501: exception net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : subForMain at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:741) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:328) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:388) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:347) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2039) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:761) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:271) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:129) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:903) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:813) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:639) 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: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : subForMain at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:207) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:741) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:639) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1238) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:869) ... 5 more Caused by: java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:201) ... 9 more I dont know that this is a data base issue or Jasper issue. Please help me out of this.

Hi, I am new to jasper report. I am creating a jasper report with the header band. i am displaying text field in the band when the customer id changes i want to display his group in the header band. from query only i can get customer group, passing customer id as parameter to sub report and mapped the sub report in the header band. when i am executing the report i am not getting report and gets designer page only. Please suggest me.