shelweb

Query works perfect in sqlplus, also when I change the datasource the report builds without issue. The funny thing is that the datasource connects successfully.

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: s. at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:530) at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:505) at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:386) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: s. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:342) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:526) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException at com.jaspersoft.web.rest.JasperRestConnector.executeRequest(JasperRestConnector.java:262) at com.jaspersoft.jdbc.driver.JasperPreparedStatement.executeQuery(JasperPreparedStatement.java:52) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:332) ... 6 more

when the images are placed side by side the report works in JasperSoft Server.

I have created a stoplight with three identical images placed one on top the other with different conditional print expressions. The report runs without issue in studio but when published to the JasperSoft Server the report fails. I have noticed that the dots around the images change color when moved, Green, blue and red. Is it possible to have image layers?