dee211

Hi everyone I have a report that works perfectly fine. I have a custom jar that simply modifies big numbers according to user preference formatting. Not a big deal. The issue I have is that whenever I use the +/- buttons in the server to resize the report I get this error: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: followed by the error: unable to resolve class. But it resolves the class fine when it's first loaded..?

I find that if you add some kind of limit to your query it works. MySQL uses 'limit' and Oracle uses 'rownum <=1'. If you add this into your reports query (not your dataset query) then the table in the details band will not repeat.