Thanks - I have been reading all about the issues with upgrading iReport, and thanks for putting up that tips page. It's very valuable.
I though I had gone through and upgraded the components, itext, etc. , but I must have missed something because after further cleanup, the report now runs properly in developer. Running on server is still a problem. I think it is with the Jasper viewer. When it appears, a blank form with only the save button appears. If you mouse over the other buttons and page counter,they then appear. The report itself does not appear. You can page through and it says page 1 of 7, page 2 of 7, etc., but still no report displaying. This happens with all reports, not just the one I was have the earlier problem with.
I'm wondering if Vista can be causing a problem.
On another matter though - you say to put an "!" after the "P" for parameters. When I do this the report errors out in iReport and doesn't appear in the viewer when run from the servoy plugin.
So, $P{from_department} works but $P!{from_department} does not.
This is the error I get:
- Code: Select all
Error executing SQL statement for : c6chg_register
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : c6chg_register at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:685) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1235) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:865) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:814) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:421) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:251) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:898) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -131: Syntax error near 'and' on line 38