halex

Sorry, just realized that I posted this to the wrong forum. Posted duplicate in the jasperserver forum.

We are going to try using Jasperserver for our reporting needs, but are unsure if we should install Jasper server on the same server/cluster that the OLAP database is sitting on. The benfit here is that we would more than likely get some HA from installing this on the OLAP environment, but I figure there would be reprecussions when it comes to database performance. What we are really trying to figure out is if we will see a massive performance gain by removing network overhead, and if the outweighs the negative. Thoughts? - Peter

We are going to try using Jasperserver for our reporting needs, but are unsure if we should install Jasper server on the same server/cluster that the OLAP database is sitting on. The benfit here is that we would more than likely get some HA from installing this on the OLAP environment, but I figure there would be reprecussions when it comes to database performance. What we are really trying to figure out is if we will see a massive performance gain by removing network overhead, and if the outweighs the negative. Thoughts? - Peter

RESOLVED: The problem was that I was using "Text Field" instead of "Static Text".

UPDATE: This problem only occurs when I use a Text Fields. If I just pull fields from the DB query it works fine, but as soon as I use a standard text field to add static text to the report I get this error.

Post Edited by halex at 07/28/2010 19:12

Just installed Jaspersoft Ireport and am trying to get a feel for it as I have a client that is potentially interested in useing it. I've successfully installed it and have set up a connection to a sample database that I have on a MySQL VM that's hosted on my workstation. I have a query that pulls 1 row from a customer data table and displays just the first and last name of the customer on the report. When I click on preview I get the error below. Please note that all I have installed at this point is ireport. I also have Java and the JDK installed on this machine. Please let me know if there is anything else I need to make this work. Errors compiling C:\baldhead\projects\jasper\ireport\report1.jasper! Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@7c06ab net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed, calculator_report1_1280343181334_653022: 179: unexpected token: : @ line 179, column 50. 1 error at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits (JRGroovyCompiler.java:101) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:188) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:131) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:514) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed, calculator_report1_1280343181334_653022: 179: unexpected token: : @ line 179, column 50. 1 error at org.codehaus.groovy.control.ErrorCollector.failIfErrors(ErrorCollector.java:296) at org.codehaus.groovy.control.ErrorCollector.addFatalError(ErrorCollector.java:143) at org.codehaus.groovy.control.ErrorCollector.addError(ErrorCollector.java:113) at org.codehaus.groovy.control.ErrorCollector.addError(ErrorCollector.java:125) at org.codehaus.groovy.control.SourceUnit.addError(SourceUnit.java:348) at org.codehaus.groovy.antlr.AntlrParserPlugin.parseCST(AntlrParserPlugin.java:85) at org.codehaus.groovy.control.SourceUnit.parse(SourceUnit.java:244) at org.codehaus.groovy.control.CompilationUnit$1.call(CompilationUnit.java:143) at org.codehaus.groovy.control.CompilationUnit.applyToSourceUnits(CompilationUnit.java:772) at org.codehaus.groovy.control.CompilationUnit.compile(CompilationUnit.java:438) at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:97) ... 6 more Compilation running time: 176!