Hi to all,
I have a report created in jaspersoft studio 6.4 with subreport inside.
When I try to execute master report, it crash. In knowagejasperreportengine.log file i see that there are errors about Fields extracted from the query. It seems that it can't link jasper_field to sql query field, this is the error:
Caused by: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: $F{MATRICOLA}
at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:872)
at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:330)
at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:382)
at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:357)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummaryNoLastFooterSamePage(JRVerticalFiller.java:1073)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:1032)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:293)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:129)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:551)
at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:393)
at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:91)
at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:456)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:863)
at it.eng.spagobi.engines.jasperreport.JasperReportEngineInstance.runReport(JasperReportEngineInstance.java:224)
... 30 more
The field $F{MATRICOLA} is a simple sql field. If i try to launch master report from jasper studio it works, if i try to lunch subreport loaded on knowage, it works.
In the master report, in the property of subreport block, i try to set the field expression, with /<full path>/subreport.jrxml or /<full path>/subreport.jasper, then i try to insert only the file name subreport.jasper or subreport.jrxml. The result doesn't change, the error is always the same.
If i delete the field MATRICOlA from the report, the log show another proble with the next field, so it is not a problem of a specific field of sql script.
The same report create with Ireport 4.1 and launched on SpagoBI 5,1 works.
Any idea?
Thanks
Alessandro
