Uploaded image for project: 'ZK'
  1. ZK
  2. ZK-4168

Excel Report Format Jasper Reports

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 8.6.0.1
    • Fix Version/s: None
    • Component/s: General
    • Labels:
      None
    • Environment:

      IntelliJ, Java, Jasper Reporting Engine.

      Description

      Hello,

      Our team hosts a web app that displays various types of jasper reports. We recently upgraded to ZK PE 8.6.0.1. In this version, when attempting to access one of these jasper reports in the Excel format, there is an error shown in the report component window. Our workaround to this is to revert back to ZK PE 8.5.0.1, and the Excel report loads properly without any issue. I have attached images displaying the error message and the output window call stack.

      Error Message:
      Could not initialize class net.sf.jasperreports.engine.export.JRXlsExporter

      And here is the call stack from the output window:
      java.lang.NoSuchMethodError: org.apache.poi.hssf.util.HSSFColor.getTripletHash()Ljava/util/Map;
      at net.sf.jasperreports.engine.export.JRXlsExporter.<clinit>(JRXlsExporter.java:160)
      at org.zkoss.zkex.zul.Jasperreport$JasperreporteExporterImpl.getJRExporter(Jasperreport.java:603)
      at org.zkoss.zkex.zul.Jasperreport.doReport(Jasperreport.java:512)
      at org.zkoss.zkex.zul.Jasperreport.access$200(Jasperreport.java:87)
      at org.zkoss.zkex.zul.Jasperreport$ExtraCtrl.getMedia(Jasperreport.java:444)
      at org.zkoss.zk.au.http.AuDynaMediar.service(AuDynaMediar.java:131)
      at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:455)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
      at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
      at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:412)
      at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
      at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1385)
      at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      at java.lang.Thread.run(Thread.java:748)

        Activity

        Hide
        CharlesQiu CharlesQiu added a comment -

        JasperReports now depends on Apache POI 3.15, please update your POI version to solve this problem.

        Show
        CharlesQiu CharlesQiu added a comment - JasperReports now depends on Apache POI 3.15, please update your POI version to solve this problem.
        Hide
        marthatischuk marthatischuk added a comment -

        Thank you, that resolved the issue for us.

        Show
        marthatischuk marthatischuk added a comment - Thank you, that resolved the issue for us.

          People

          • Assignee:
            CharlesQiu CharlesQiu
            Reporter:
            marthatischuk marthatischuk
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 1 hour
              1h