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

Excel Report Format Jasper Reports

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Duplicate
    • 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)

        Issue Links

          Activity

          Hide
          rudyhuang rudyhuang added a comment -

          See ZK-4168

          Show
          rudyhuang rudyhuang added a comment - See ZK-4168

            People

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

              Dates

              • Created:
                Updated:
                Resolved: