交叉报表为什么只能有最多两列的数值列

dr琅琊人

交叉报表为什么只能有最多两列的数值列，多加了就报500的错

jishuang

500错看tomcat控制台的完整错误

dr琅琊人

jishuang 发表于 2018-5-22 10:54
500错看tomcat控制台的完整错误

2018-05-22 10:30:35 开始-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2018-05-22 10:30:36 结束-WINDOW生成中间文件: /UI2/portal/pc3/index.w
2018-05-22 10:30:36 开始-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2018-05-22 10:30:36 结束-中间文件生成缓存文件: /UI2/portal/pc3/index.w
2018-05-22 10:30:37 开始-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2018-05-22 10:30:37 结束-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2018-05-22 10:30:37 开始-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2018-05-22 10:30:37 结束-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2018-05-22 10:30:38 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2018-05-22 10:30:38 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/waitActivity.w
2018-05-22 10:30:38 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2018-05-22 10:30:38 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/waitActivity.w
2018-05-22 10:30:38 开始-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2018-05-22 10:30:38 结束-WINDOW生成中间文件: /UI2/SA/task/taskView/submitActivity.w
2018-05-22 10:30:38 开始-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2018-05-22 10:30:38 结束-中间文件生成缓存文件: /UI2/SA/task/taskView/submitActivity.w
2018-05-22 10:30:42 开始-WINDOW生成中间文件: /UI2/ResearchProject/QueryManagement/process/QueryManagement/ActualFundsUseActivity.w
2018-05-22 10:30:42 Excel生成报表定义失败，文件名：D:/BeX5_3.8/model/UI2/ResearchProject/QueryManagement/process/QueryManagement/ActualFundsUseActivityReport.xml
javax.servlet.ServletException: java.lang.RuntimeException: Excel生成报表定义失败，文件名：D:/BeX5_3.8/model/UI2/ResearchProject/QueryManagement/process/QueryManagement/ActualFundsUseActivityReport.xml
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
        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.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: Excel生成报表定义失败，文件名：D:/BeX5_3.8/model/UI2/ResearchProject/QueryManagement/process/QueryManagement/ActualFundsUseActivityReport.xml
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at Report.generateReportDoc(Report.java:339)
        at Report.generateReportDefine(Report.java:311)
        at Report.execute(Report.java:67)
        at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
        at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler2.compile(Unknown Source)
        at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
        at com.justep.ui.WindowServer2.service(Unknown Source)
        ... 17 more
Caused by: java.lang.RuntimeException: Excel生成报表定义失败
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        ... 30 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 6
        at com.justep.xls.Worksheet.getCell(Unknown Source)
        at com.justep.report.xls.XLSTransUtils.getSpan(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.scanCols(Unknown Source)
        at com.justep.report.xls.XLSTransContent.transform(Unknown Source)
        ... 31 more
五月 22, 2018 10:30:42 上午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
java.lang.ArrayIndexOutOfBoundsException: 6
        at com.justep.xls.Worksheet.getCell(Unknown Source)
        at com.justep.report.xls.XLSTransUtils.getSpan(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.scanCols(Unknown Source)
        at com.justep.report.xls.XLSTransContent.transform(Unknown Source)
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at Report.generateReportDoc(Report.java:339)
        at Report.generateReportDefine(Report.java:311)
        at Report.execute(Report.java:67)
        at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
        at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
        at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler2.compile(Unknown Source)
        at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
        at com.justep.ui.WindowServer2.service(Unknown Source)
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
        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.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)

jishuang

在excel文件的最上方添加6行以上的空行看看

dr琅琊人

jishuang 发表于 2018-5-22 11:38
在excel文件的最上方添加6行以上的空行看看

果然是，谢谢