Hitachi Vantara Pentaho Community Forums
Results 1 to 21 of 21

Thread: JasperReport Dependencies Directory

  1. #1
    Join Date
    Mar 2011
    Posts
    140

    Lightbulb JasperReport Dependencies Directory

    Hello everyone,

    I've been struggling for days now and I still don't have jasperreports working on pentaho.

    I think I'm not using the right dependencies or I'm not placing them in the right directory.

    So, could someone help me out with this ? I mean, what are the right dependencies for jasperreports 4.0.2 and when I have those dependencies, where do I put them ?

    At this moment I have the following dependencies:

    - jasperreports*.jar
    - commons*.jar
    - jdt-compiler.jar
    - itext*.jar

    and I've put them in the directory of tomcat/webapps/pentaho/WEB-INF/lib .

    This however is not working for me, because when I create a jrxml with iReport 4.0.2 I get an exception in Pentaho. The weird thing is that when I use the example jrxml provided in Pentaho everything goes well. That's the reason I think that my dependencies might be in the wrong directory.

    Any suggestions ? Because I'm really stuck here ...

    Any help will be appreciated !

  2. #2

    Default

    Hi,

    Are you getting some exception on the log ?? can you add a screen shot with the error or the error file log.

    Usually you just have to update the jasperreports*.jar excluding the flow version and iText.

    Regards.

    Cristhian.

  3. #3
    Join Date
    Mar 2011
    Posts
    140

    Default

    Hello cristhiank,

    First off, thanks for helping out.

    Second, where would you put the *.jars ? In the same directory I'm using or in another one ?


    So, here is the exception. I can't make any sense of it, so I hope someone can. I also added the .xaction and the .jrxml ...
    Code:
    2011-04-21 08:42:54,736 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 9489bb91-6be2-11e0-876f-b7949dae9f4f:SOLUTION-ENGINE:test.xaction: Action Sequence execution failed, see details below
    | Error Time: donderdag 21 april 2011 8:42:54 uur CEST
    | Session ID: joe
    | Instance Id: 9489bb91-6be2-11e0-876f-b7949dae9f4f
    | Action Sequence: test.xaction
    | Execution Stack:
    EXECUTING ACTION: test (JasperReportsComponent)
    | Action Class: JasperReportsComponent
    | Action Desc: test
    | Loop Index (1-based): 0
    Stack Trace:org.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 - Activiteit kon niet worden uitgevoerd
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1318)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897)
    	at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399)
    	at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317)
    	at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193)
    	at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
    	at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:167)
    	at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:310)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
    	at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    	at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
    	at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    	at java.lang.Thread.run(Thread.java:619)

    The test.xaction
    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <action-sequence> 
      <title>test</title>
      <version>1</version>
      <logging-level>DEBUG</logging-level>
      <documentation> 
        <author>test</author>  
        <description>Empty blank action sequence document</description>  
        <help/>  
        <result-type/>  
        <icon/> 
      </documentation>
    
      <inputs/>
    
      <outputs/>
    
      <resources>
        <report-definition>
          <solution-file>
            <location>test.jrxml</location>
            <mime-type/>
          </solution-file>
        </report-definition>
      </resources>
      
      <actions> 
        <action-definition>
          <component-name>JasperReportsComponent</component-name>
          <action-type>test</action-type>
          <action-resources/>
          <component-definition>
            <output-type><![CDATA[pdf]]></output-type>
            <jndi><![CDATA[SampleData]]></jndi>
          </component-definition>
        </action-definition>
    
      </actions> 
    </action-sequence>

  4. #4

    Default

    Hello ObjetiveC,

    I think that the jar files are ok, this is something else. I ran your xaction on mi server and it worked... I think that before the stack trace you copied here must be another exception, that's the exception we're looking for... The stack trace you copied is the standard error from the BI-Server, usually the inner exception is logged before that exception. Check your log again and copy the first exception before that.

    Regards,

  5. #5
    Join Date
    Mar 2011
    Posts
    140

    Default

    Hello cristhiank,

    You were right. I reproduced the error and checked my log again. I found the following exception. It still makes no sense to me, so I hope you can help me out here:

    Code:
    2011-04-21 20:13:12,203 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2011-04-21 20:13:18,843 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2011-04-21 20:13:19,703 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2011-04-21 20:13:21,187 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2011-04-21 20:13:23,265 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2011-04-21 20:13:24,796 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2011-04-21 20:13:25,968 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2011-04-21 20:13:27,375 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
    2011-04-21 20:14:36,203 ERROR [org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent] Error Start: Pentaho Pentaho Platform Engine Core 3.8.0-stable.45256
    2011-04-21 20:14:36,234 ERROR [org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent] 32098c87-6c43-11e0-a8e6-75c0e76c9448:COMPONENT:context-29950846-1303409667921:test.xactionJasperReport.ERROR_0010 - not able to compile report <path>\biserver-ce\pentaho-solutions\bi-developers\reporting\test.jrxml to file <path>\biserver-ce\pentaho-solutions\bi-developers\reporting\test.jasper
    net.sf.jasperreports.engine.JRException: Language "groovy" not supported by this report compiler.
    Expecting "java" instead.
    	at net.sf.jasperreports.engine.design.JRJdtCompiler.checkLanguage(JRJdtCompiler.java:586)
    	at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:134)
    	at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215)
    	at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:131)
    	at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:113)
    	at org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent.didReportCompile(JasperReportsComponent.java:688)
    	at org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent.processCurrentReport(JasperReportsComponent.java:414)
    	at org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent.executeAction(JasperReportsComponent.java:349)
    	at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1293)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897)
    	at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399)
    	at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317)
    	at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193)
    	at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
    	at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:167)
    	at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:316)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
    	at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    	at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
    	at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)
    	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
    	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
    	at java.lang.Thread.run(Thread.java:619)
    2011-04-21 20:14:36,250 ERROR [org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent] Error end:
    2011-04-21 20:14:36,250 WARN  [org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent] 32098c87-6c43-11e0-a8e6-75c0e76c9448:COMPONENT:context-29950846-1303409667921:test.xactionEr werd geen outputstroom opgegeven, de standaard output stroom wordt gebruikt. Dit zal in de toekomst niet langer ondersteund worden. Wijzig deze action sequence aub
    2011-04-21 20:14:36,265 ERROR [org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent] Error Start: Pentaho Pentaho Platform Engine Core 3.8.0-stable.45256
    2011-04-21 20:14:36,265 ERROR [org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent] 32098c87-6c43-11e0-a8e6-75c0e76c9448:COMPONENT:context-29950846-1303409667921:test.xactionJasperReport.ERROR_0014 - Rapport uitvoering mislukt
    net.sf.jasperreports.engine.JRException: java.io.FileNotFoundException: <path>\biserver-ce\pentaho-solutions\bi-developers\reporting\test.jasper
    	at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:84)
    	at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:243)
    	at org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent.exportReport(JasperReportsComponent.java:489)
    	at org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent.executeAction(JasperReportsComponent.java:382)
    	at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1293)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987)
    	at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897)
    	at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399)
    	at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317)
    	at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193)
    	at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
    	at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:167)
    	at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:316)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
    	at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    	at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    	at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    	at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
    	at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)
    	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
    	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
    	at java.lang.Thread.run(Thread.java:619)
    Caused by: java.io.FileNotFoundException: <path>\pentaho-solutions\bi-developers\reporting\test.jasper
    	... 79 more
    2011-04-21 20:14:36,265 ERROR [org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent] Error end:

  6. #6

    Default

    Hello ObjetiveC,

    Looks like you have old jasperreport jar, verify you have deleted the old jasperreports-2.0.5.jar and replaced withe the newer version. Groovy wasn't supported on old jasperreports versions.

    Regards,

  7. #7
    Join Date
    Mar 2011
    Posts
    140

    Default

    Hello cristhiank,

    I followed up your advice and checked the dependencies even double & triple checked it and even did a clean BI install with the jasperreport*.jars and I really did remove the old jasperreport-2.0.5.jar. Even after all of that I'm getting the same exception.

    I also did a search on "jasper" with a result of:

    Code:
    jasperreports.license -> biserver-ce\licenses
    jasperreports-conf -> biserver-ce\pentaho-solutions\system\jasperreports
    
    jasper-el.jar -> tomcat\lib
    jasper.jar -> tomcat\lib
    jasper-jdt.jar -> tomcat\lib
    
    jasperreports-4.0.2.jar -> tomcat\webapps\pentaho\WEB-INF\lib
    jasperreports-applet-4.0.2.jar -> tomcat\webapps\pentaho\WEB-INF\lib
    jasperreports-fonts-4.0.2.jar -> tomcat\webapps\pentaho\WEB-INF\lib
    So I don't know if those *.jar in tomcat\lib are the issue, I don't think that has anything to do with jasperreports though.

    What else could I try ? I'm stuck on this issue for the last 2/3 days so I really want to fix.


    Thank you for your time and do bear with me.
    Last edited by ObjectiveC; 04-21-2011 at 03:35 PM.

  8. #8

    Default

    Hello ObjectiveC,

    One last check, did you copy groovy-all jar ??
    Join me on the IRC at ##pentaho to chat.

    Regards,

  9. #9
    Join Date
    Mar 2011
    Posts
    140

    Default

    Hello again,

    here is the test.jrxml created with iReport-4.0.2. I couldn´t upload it since this extension is not supported.

    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="test" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
        <property name="ireport.zoom" value="1.0"/>
        <property name="ireport.x" value="32"/>
        <property name="ireport.y" value="0"/>
        <background>
            <band splitType="Stretch"/>
        </background>
        <title>
            <band height="79" splitType="Stretch">
                <staticText>
                    <reportElement x="0" y="0" width="429" height="65"/>
                    <textElement/>
                    <text><![CDATA[this is a test. It should be displayed in Pentaho ...]]></text>
                </staticText>
            </band>
        </title>
        <pageHeader>
            <band height="35" splitType="Stretch"/>
        </pageHeader>
        <columnHeader>
            <band height="61" splitType="Stretch"/>
        </columnHeader>
        <detail>
            <band height="125" splitType="Stretch"/>
        </detail>
        <columnFooter>
            <band height="45" splitType="Stretch"/>
        </columnFooter>
        <pageFooter>
            <band height="54" splitType="Stretch"/>
        </pageFooter>
        <summary>
            <band height="42" splitType="Stretch"/>
        </summary>
    </jasperReport>

  10. #10

    Default SOLVED: JasperReports error

    Hi ObjectiveC,

    As we talk on the IRC the main issue was that JasperComponent on pentaho isn't compatible with groovy by now, so you must use "java" as the language for reports on iReport designer.
    The other issue is that your reports must include a Query to work, seems like the JasperComponent validates that the report uses a dataset for render it.
    Here is the jrxml
    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="test" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
        <property name="ireport.zoom" value="1.0"/>
        <property name="ireport.x" value="0"/>
        <property name="ireport.y" value="0"/>
        <subDataset name="dataset1"/>
        <queryString>
            <![CDATA[select * from products]]>
        </queryString>
        <field name="PRODUCTCODE" class="java.lang.String"/>
        <field name="PRODUCTNAME" class="java.lang.String"/>
        <field name="PRODUCTLINE" class="java.lang.String"/>
        <field name="PRODUCTSCALE" class="java.lang.String"/>
        <field name="PRODUCTVENDOR" class="java.lang.String"/>
        <field name="PRODUCTDESCRIPTION" class="java.lang.String"/>
        <field name="QUANTITYINSTOCK" class="java.lang.Integer"/>
        <field name="BUYPRICE" class="java.math.BigDecimal"/>
        <field name="MSRP" class="java.math.BigDecimal"/>
        <background>
            <band splitType="Stretch"/>
        </background>
        <title>
            <band height="79" splitType="Stretch">
                <staticText>
                    <reportElement x="0" y="0" width="100" height="20"/>
                    <textElement/>
                    <text><![CDATA[Pentaho TEST]]></text>
                </staticText>
            </band>
        </title>
        <pageHeader>
            <band height="35" splitType="Stretch"/>
        </pageHeader>
        <columnHeader>
            <band height="61" splitType="Stretch"/>
        </columnHeader>
        <detail>
            <band height="125" splitType="Stretch"/>
        </detail>
        <columnFooter>
            <band height="45" splitType="Stretch"/>
        </columnFooter>
        <pageFooter>
            <band height="54" splitType="Stretch"/>
        </pageFooter>
        <summary>
            <band height="42" splitType="Stretch"/>
        </summary>
    </jasperReport>
    Attached Files Attached Files

  11. #11
    Join Date
    Mar 2011
    Posts
    140

    Default

    Hello cristhiank,

    I want to thank you for your time, patience and help. You were great !

    For all those interested I issued a bug on jira:
    http://jira.pentaho.com/browse/BISERVER-5931


    Cheers,
    ObjectiveC !

  12. #12
    Join Date
    Sep 2007
    Posts
    10

    Default

    Hi

    I had the same problem but I changed the report language as cristhiank (thanks) said.
    But now i have another problem with parameter. i created a jasper report with integer parameter, when i try to call from pentaho, i get a error saying:
    net.sf.jasperreports.engine.JRException: Incompatible java.lang.String value assigned to parameter FinYearPrm in the Actual VS Budget Sales dataset.
    Action Sequence
    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <action-sequence> 
      <title>Actual VS Budget Sales</title>
      <version>1</version>
      <logging-level>DEBUG</logging-level>
      <documentation> 
        <author>Danilo de Sousa</author>  
        <description>Empty blank action sequence document</description>  
        <help/>  
        <result-type>report</result-type>  
        <icon/> 
      </documentation>
    
      <inputs> 
        <FinYearPrm type="integer"> 
          <sources> 
            <request>FinYearPrm</request> 
          </sources>  
          <default-value><![CDATA[2007]]></default-value> 
        </FinYearPrm> 
      </inputs>
    
      <outputs/>
    
      <resources> 
        <report-definition> 
          <solution-file> 
            <location>Actual VS Budget Sales.jasper</location>  
            <mime-type>text/plain</mime-type> 
          </solution-file> 
        </report-definition> 
      </resources>
      
      <actions> 
        <action-definition> 
          <component-name>SecureFilterComponent</component-name>
          <action-type>Prompt/Secure Filter</action-type>
          <action-inputs> 
            <FinYearPrm type="integer"/> 
          </action-inputs>
          <component-definition> 
            <selections> 
              <FinYearPrm filter="none" style="text-box" prompt-if-one-value="true"> 
                <title>Financial Year</title> 
              </FinYearPrm> 
            </selections> 
          </component-definition> 
        </action-definition>
      
        <action-definition> 
          <component-name>JasperReportsComponent</component-name>
          <action-type>Jasper</action-type>
          <action-inputs>
            <FinYearPrm type="integer"/>
          </action-inputs>
          <component-definition> 
            <output-type>html</output-type>  
            <jdbcdriver><![CDATA[com.mysql.jdbc.Driver]]></jdbcdriver>  
            <jndi><![CDATA[dwsales]]></jndi> 
          </component-definition> 
        </action-definition>
     
      </actions> 
    </action-sequence>
    And Jasper Report
    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Actual VS Budget Sales" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
        <property name="ireport.zoom" value="1.0"/>
        <property name="ireport.x" value="0"/>
        <property name="ireport.y" value="0"/>
        <parameter name="FinYearPrm" class="java.lang.Integer">
            <defaultValueExpression><![CDATA[new Integer(2007)]]></defaultValueExpression>
        </parameter>
        <queryString>
    ....
    
    </jasperReport>
    And Error log
    Code:
    00:07:03,871 ERROR [JasperReportsComponent] aec3ca4e-711a-11e0-aee2-f361f64ff73c:COMPONENT:context-1884467831-1303942023628:ActualVSBudgetSales.xactionJasperReport.ERROR_0014 - Report execution failed
    net.sf.jasperreports.engine.JRException: Incompatible java.lang.String value assigned to parameter FinYearPrm in the Actual VS Budget Sales dataset.
        at net.sf.jasperreports.engine.fill.JRFillDataset.setParameter(JRFillDataset.java:903)
        at net.sf.jasperreports.engine.fill.JRFillDataset.setFillParameterValues(JRFillDataset.java:642)
        at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:585)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1280)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:901)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)
        at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)
        at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)
        at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)
    .....

  13. #13

    Default

    Hello dsousa,

    I downloaded your files and I'm doing some testing.. Will post when have a solution..

  14. #14
    Join Date
    Mar 2011
    Posts
    140

    Default

    Hello dsousa,

    Since you've changed the language from groovy to java you won't have the benefits of duck typing anymore.

    Basically this means that you have to declare each type for every single field you have.

    For example

    net.sf.jasperreports.engine.JRException: Incompatible java.lang.String value assigned to parameter FinYearPrm in the Actual VS Budget Sales dataset.
    probably means that you'll have to change the type of field FinYearPrm from java.lang.String to java.lang.Integer. Look in the properties window for the "Expression Class".

    I think that's the issue you're experiencing. Not an ideal situation, so I'm working on the groovy fix.


    Let us know if you were able to fix this issue.


    Cheers !
    Last edited by ObjectiveC; 04-28-2011 at 07:13 AM. Reason: Read the XML provided. Makes it clear it should be set to java.lang.Integer.

  15. #15

    Default

    Hello dsousa,

    I found the issue.... and I have saddly tell you that the actual (old) JasperComponent on pentaho support only String and String-lists as parameters to Jasperreports.... So you can workaround this issue casting the String to the type you need on the jasper report, while the old component gets replaced with the new plugin and get very nice new features... Hope you can solve your issue...

    Regards.. CristhianK

  16. #16
    Join Date
    Sep 2007
    Posts
    10

    Default

    Hi CristhianK

    Thanks for your help. But, how can I cast String to Integer on the jasper report?
    I'm using iReport 4.0.2, pds 3.7.0 and FinYearPrm is the query parameter.

    Regards,
    DSousa
    Last edited by dsousa; 05-01-2011 at 07:01 PM.

  17. #17

    Default

    Hi,

    You can use Java Casting style on jasper reports expressions, something like Integer.parseInt when you need to use the parameter.

    Regards,

  18. #18
    Join Date
    Mar 2011
    Posts
    140

    Default

    Well, lol

    All that typing and you didn't even read my message

  19. #19
    Join Date
    Sep 2007
    Posts
    10

    Default

    Quote Originally Posted by cristhiank View Post
    Hi,

    You can use Java Casting style on jasper reports expressions, something like Integer.parseInt when you need to use the parameter.

    Regards,
    Thanks

  20. #20
    Join Date
    Apr 2011
    Posts
    1

    Default

    Hi people, i'm having a similar problem.

    I'm using pentaho 3.8 in localhost and iReport 4.0.1 to make the report, all groovy libs found on the server are version 1.5.6 and all jasper libs found are version 2.0.5. I've already changed the 'language' parameter to "java" in the jrxml (and it was gone after i recompiled it, don't know why) and tried to update the jar files to groovy-all-1.8.0 and jasperreports-4.0.1 but didn't work either, so rolled back to the standard. I'm pasting the jrxml below.

    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="PentahoTeste01" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
        <property name="ireport.zoom" value="2.0"/>
        <property name="ireport.x" value="143"/>
        <property name="ireport.y" value="0"/>
        <queryString>
            <![CDATA[SELECT
         dimclifo."nm_cli_for" AS cliente,
         dimgrupo."nm_grupo" AS grupo,
         sum(fatonfs."qtde") AS qtde
    FROM
         "public"."dimclifo" dimclifo INNER JOIN "public"."fatonfs" fatonfs ON dimclifo."cd_cli_for" = fatonfs."dim_clifor"
         INNER JOIN "public"."dimgrupo" dimgrupo ON fatonfs."dim_grupo" = dimgrupo."cd_grupo_famili"
    where dimclifo.nm_cli_for like '%IMPERATRIZ%'
    group by cliente, grupo
    order by grupo, cliente]]>
        </queryString>
        <field name="cliente" class="java.lang.String"/>
        <field name="grupo" class="java.lang.String"/>
        <field name="qtde" class="java.math.BigDecimal"/>
        <background>
            <band splitType="Stretch"/>
        </background>
        <title>
            <band height="15" splitType="Stretch">
                <staticText>
                    <reportElement x="253" y="0" width="33" height="15"/>
                    <textElement/>
                    <text><![CDATA[É nóis!]]></text>
                </staticText>
            </band>
        </title>
        <pageHeader>
            <band height="15" splitType="Stretch"/>
        </pageHeader>
        <columnHeader>
            <band height="20" splitType="Stretch">
                <staticText>
                    <reportElement x="0" y="0" width="325" height="20"/>
                    <textElement/>
                    <text><![CDATA[cliente]]></text>
                </staticText>
                <staticText>
                    <reportElement x="325" y="0" width="168" height="20"/>
                    <textElement/>
                    <text><![CDATA[grupo]]></text>
                </staticText>
                <staticText>
                    <reportElement x="493" y="0" width="62" height="20"/>
                    <textElement/>
                    <text><![CDATA[qtde]]></text>
                </staticText>
            </band>
        </columnHeader>
        <detail>
            <band height="20" splitType="Stretch">
                <textField>
                    <reportElement x="0" y="0" width="325" height="20"/>
                    <textElement/>
                    <textFieldExpression class="java.lang.String"><![CDATA[$F{cliente}]]></textFieldExpression>
                </textField>
                <textField>
                    <reportElement x="325" y="0" width="168" height="20"/>
                    <textElement/>
                    <textFieldExpression class="java.lang.String"><![CDATA[$F{grupo}]]></textFieldExpression>
                </textField>
                <textField>
                    <reportElement x="493" y="0" width="62" height="20"/>
                    <textElement textAlignment="Right"/>
                    <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{qtde}]]></textFieldExpression>
                </textField>
            </band>
        </detail>
        <columnFooter>
            <band height="7" splitType="Stretch"/>
        </columnFooter>
        <pageFooter>
            <band height="7" splitType="Stretch"/>
        </pageFooter>
        <summary>
            <band height="7" splitType="Stretch"/>
        </summary>
    </jasperReport>
    Don't know exactly where to found the useful logs, so if anyone says where, i'll paste them too.

    I'm stuck on this almost 2 days.

    Thank you all, Ivan Paz.

  21. #21
    Join Date
    Mar 2011
    Posts
    140

    Default

    hello bisnaguete,

    So doesn't it compile in iReport or doesn't it compile on the Pentaho platform ?

    I copy/paste the .jrxml, removed the datasource and compiled it in iReport. That worked perfectly. I then published it to the pentaho platform and that also worked for me, so somewhat more information might help to solve your problem.
    Last edited by ObjectiveC; 06-21-2011 at 04:44 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.