jongr

I found a work-around for this problem by copying the ireportlibgroovy-all-1.0.jar (2302kb) to replace the jasperserverWEB-INFlibgroovy-all-1.0-beta-10.jar (839kb)

I have installed jasperserver-2.0-windows-installer.exe and iReport-2.0.0-windows-installer.exe The report I have created works in iReport and also after it was installed in JasperServer However, I find that if I set the iReport 'properties, scriptlet language' to groovy it will run ok in iReport but fails with the message below when I run it from JasperServer This message is from the iReport JasperServer plugin: 1 - Could not initialize class org.codehaus.groovy.ast.ClassHelper java.lang.Exception:Â1Â-ÂCouldÂnotÂinitializeÂclassÂorg.codehaus.groovy.ast.ClassHelper ÂÂÂÂatÂcom.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:382) ÂÂÂÂatÂcom.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:299) ÂÂÂÂatÂcom.jaspersoft.jasperserver.irplugin.ReportRunner.run(ReportRunner.java:73) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource) This message is when the report is run from JasperServer: type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoClassDefFoundError: Could not initialize class org.codehaus.groovy.ast.ClassHelper org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:860) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360) javax.servlet.http.HttpServlet.service(HttpServlet.java:709) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:136) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) root cause java.lang.NoClassDefFoundError: Could not initialize class org.codehaus.groovy.ast.ClassHelper org.codehaus.groovy.antlr.AntlrParserPlugin.makeType(AntlrParserPlugin.java:2129) org.codehaus.groovy.antlr.AntlrParserPlugin.classDef(AntlrParserPlugin.java:322) org.codehaus.groovy.antlr.AntlrParserPlugin.convertGroovy(AntlrParserPlugin.java:204) org.codehaus.groovy.antlr.AntlrParserPlugin.buildAST(AntlrParserPlugin.java:180) org.codehaus.groovy.control.SourceUnit.convert(SourceUnit.java:305) org.codehaus.groovy.control.CompilationUnit$4.call(CompilationUnit.java:505) org.codehaus.groovy.control.CompilationUnit.applyToSourceUnits(CompilationUnit.java:773) org.codehaus.groovy.control.CompilationUnit.convert(CompilationUnit.java:492) org.codehaus.groovy.control.CompilationUnit.compile(CompilationUnit.java:425) net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:97) net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:190) net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:105) net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:212) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:711) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$CacheableCompiledReports.getData(EngineServiceImpl.java:153) com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.saveData(HibernateRepositoryCache.java:179) com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.getCachedItem(HibernateRepositoryCache.java:125) com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.cache(HibernateRepositoryCache.java:71) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) $Proxy5.cache(Unknown Source) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getCompiledReport(EngineServiceImpl.java:720) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getJasperReport(EngineServiceImpl.java:547) com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportInputControlDefaultValues(EngineServiceImpl.java:908) com.jaspersoft.jasperserver.war.action.ReportParametersAction.loadDefaultInputValues(ReportParametersAction.java:354) com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:418) com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:119) com.jaspersoft.jasperserver.war.action.ViewReportAction.checkForParams(ViewReportAction.java:121) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103) org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136) org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203) org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142) org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61) org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180) org.springframework.webflow.engine.State.enter(State.java:200) org.springframework.webflow.engine.Flow.start(Flow.java:557) org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195) org.springframework.webflow.engine.SubflowState.doEnter(SubflowState.java:120) org.springframework.webflow.engine.State.enter(State.java:200) org.springframework.webflow.engine.Transition.execute(Transition.java:229) org.springframework.webflow.engine.TransitionableState.onEvent(TransitionableState.java:112) org.springframework.webflow.engine.Flow.onEvent(Flow.java:572) org.springframework.webflow.engine.impl.RequestControlContextImpl.signalEvent(RequestControlContextImpl.java:207) org.springframework.webflow.engine.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:214) org.springframework.webflow.executor.FlowExecutorImpl.resume(FlowExecutorImpl.java:238) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) $Proxy11.resume(Unknown Source) org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:115) org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170) org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360) javax.servlet.http.HttpServlet.service(HttpServlet.java:709) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:136) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)

Thanks to jmurry, it works fine note: I had to change DATE_FORMAT(datefield,'%Y%c') to DATE_FORMAT(datefield,'%Y%m') so that I got two digit months

Ok, I will try that, but before I do I will need to convert my Parameter date into YYYYMM so that I can use it in MySQL (The parameter is using the type java.util.Date) Can you suggest the best way ? Thanks

I want to create an expression to calculate the number of months between two dates (preferably in groovy) and then multiply the result by a field value. Can anyone help - thanks

I am beginning to think that there is a conspiracy to hide the information on how to call a JasperReport from a web browser. Jasper reports is billed as being able to replace Crystal Reports (which can be run directly from the database application.) There seems to be loads on stuff out there - all written by java programmers who forget that us lesser mortals haven't a clue about java or how to call it. I have Tomcat and Apache and intranet pages. I have JasperServer and have built a report using Ireport (requesting a couple of parameters like date and customer) and have a .jrxml file and a compiled .jasper file. I can use the JasperServer page to navigate to my report and run it from there (after entering my login and password) but I would like to run it directly from my html web page. I have a web page with a form on it and can input the date and customer parameters mentioned above. So, what next ? Please spill the beans

I have a problem with ..jasperscripts>js-import.bat This is referenced in JasperServer Installation Manual (Appendix B.1.8). I get the following error. C:appsjasperscripts>js-import.bat --input-dir js-db-1.2-dump.sql 12:17:16,718 ERROR BaseExportImportCommand:46 - org.springframework.beans.factor y.BeanDefinitionStoreException: IOException parsing XML document from class path resource [config/applicationContext-export-import.xml]; nested exception is jav a.io.FileNotFoundException: class path resource [config/applicationContext-expor t-import.xml] cannot be opened because it does not exist org.springframework.beans.factory.BeanDefinitionStoreException: IOException pars ing XML document from class path resource [config/applicationContext-export-impo rt.xml]; nested exception is java.io.FileNotFoundException: class path resource [config/applicationContext-export-import.xml] cannot be opened because it does n ot exist Caused by: java.io.FileNotFoundException: class path resource [config/applicatio nContext-export-import.xml] cannot be opened because it does not exist at org.springframework.core.io.ClassPathResource.getInputStream(ClassPat hResource.java:135) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea nDefinitions(XmlBeanDefinitionReader.java:334) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea nDefinitions(XmlBeanDefinitionReader.java:317) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.registerCo nfig(BaseExportImportCommand.java:121) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.createSpri ngContext(BaseExportImportCommand.java:93) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(Ba seExportImportCommand.java:70) at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.j ava:43)

I also have just downloaded jasperserver-2.0-windows-installer.exe and it crashed just before end. Error message print is attached Post edited by: jongr, at: 2007/07/11 09:59 Post edited by: jongr, at: 2007/07/11 10:00 well, I tried to upload gif and jpg file but it was not accepted OK - More info I successfully installed it by excluding the mySQL database examples Post edited by: jongr, at: 2007/07/11 11:12

The database that I wish to report on uses dates (Long integers) in reverse order with the base in the year 1900. i.e. The 19 March 2007 is held as 1070319 How can I input the date using the datatype calendar and convert it for use in the report query ?

I have upgraded to JasperServer 1.2.1 and find that my existing reports in the mySQL database have disappeared. I can find no reference as to how existing data can be kept when upgrading.

The database that I wish to report on uses dates (Long integers) in reverse order with the base in the year 1900. i.e. The 19 March 2007 is held as 1070319 How can I input the date and convert it for use in the report query ?

I have built a report using Ireport and can run it in JasperServer. Is there a method to run it directly from Visual Basic6 in a similar way to Crystal Reports ?