vincentc

Hello, We have something that looks like a bug on JasperServer 4.5. This happens when we created an Ad Hoc report ('table') and we choose to "Hide detail lines." When we execute the report, we get this error message: 2012-03-21 09:59:54,170 ERROR errorPage_jsp, http-80-1: 487 - stack trace of exception That redirected to errorPage.jsp com.jaspersoft.jasperserver.api.JSException: error setting up deferral Has com.jaspersoft.ji.adhoc.action.ViewAdhocReportAction.runReport (ViewAdhocReportAction.java: 203) at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java: 39) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java: 25) at java.lang.reflect.Method.invoke (Method.java: 597) [... ] Caused by: java.lang.IllegalArgumentException: unknown field [our_field]_count at at Has net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues ​​(JRFillDataset.java: 895) Has net.sf.jasperreports.engine.fill.JRFillDataset.next (JRFillDataset.java: 860) Has net.sf.jasperreports.engine.fill.JRFillDataset.next (JRFillDataset.java: 837) Has net.sf.jasperreports.engine.fill.JRBaseFiller.next (JRBaseFiller.java: 1434) Has net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport (JRVerticalFiller.java: 126) Has net.sf.jasperreports.engine.fill.JRBaseFiller.fill (JRBaseFiller.java: 836) Has net.sf.jasperreports.engine.fill.JRBaseFiller.fill (JRBaseFiller.java: 765) Has com.jaspersoft.ji.engine.ProEngineServiceImpl.fillReport (ProEngineServiceImpl.java: 253) Has com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport (AdhocEngineServiceImpl.java: 662) Has com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport (AdhocEngineServiceImpl.java: 2158) Has com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport (AdhocEngineServiceImpl.java: 2087) Has com.jaspersoft.ji.adhoc.action.ViewAdhocReportAction.runReport (ViewAdhocReportAction.java: 163) I noticed that these are the automatic calculations made by Jasper (total, sums ...) that are a problem. When we execute the report with "Displaying the detail lines," everything is OK (no crash). Anyone know there a workaround for this problem?? Thank you very much in advance Vincent

Hello, I currently encounter a problem during the development of an ad hoc report. I created a domain and in this domain, I use several tables with a derived table based on a simple SQL query (SELECT ... FROM ... WHERE). This query works and returns only 10 records. A join is also shed on the derived table (I do not know if this important detail). When I make my ad hoc report (format: table), if I add a field in my derived table as a column, it works perfectly. By cons, if I want to add it as a group (and that's what I want), I get the message"Loading ..." that appears indefinitely and nothing happens. Does anyone know what can cause this? In advance, thank you. Vincent