横向展开的交叉报表报错

qweasdzxc

横向展开的交叉报表报错，正确的要怎么改？

1. 2018-03-13 13:16:59 Excel生成报表定义失败，文件名：G:/BeX5_V3.6/model/UI2/HR/salary/process/salaryTransaction/report1.xml
   
2. javax.servlet.ServletException: java.lang.RuntimeException: Excel生成报表定义失败，文件名：G:/BeX5_V3.6/model/UI2/HR/salary/process/salaryTransaction/report1.xml
   
3.     at com.justep.ui.servlet.MainServlet.service(Unknown Source)
   
4.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
   
5.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   
6.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   
7.     at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
   
8.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   
9.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   
10.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
11.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
12.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
13.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
14.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
15.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
16.     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
17.     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
18.     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
19.     at java.lang.Thread.run(Thread.java:745)
    
20. Caused by: java.lang.RuntimeException: Excel生成报表定义失败，文件名：G:/BeX5_V3.6/model/UI2/HR/salary/process/salaryTransaction/report1.xml
    
21.     at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
    
22.     at Report.generateReportDoc(Report.java:339)
    
23.     at Report.generateReportDefine(Report.java:311)
    
24.     at Report.execute(Report.java:67)
    
25.     at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
    
26.     at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
    
27.     at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
    
28.     at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
    
29.     at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
    
30.     at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
    
31.     at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
    
32.     at com.justep.ui.WindowCompiler2.compile(Unknown Source)
    
33.     at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
    
34.     at com.justep.ui.WindowServer2.service(Unknown Source)
    
35.     ... 17 more
    
36. Caused by: java.lang.RuntimeException: Excel生成报表定义失败
    
37.     at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
    
38.     ... 31 more
    
39. Caused by: java.lang.ArrayIndexOutOfBoundsException: 7
    
40.     at com.justep.xls.Worksheet.getCell(Unknown Source)
    
41.     at com.justep.report.xls.XLSTransUtils.getSpan(Unknown Source)
    
42.     at com.justep.report.xls.XLSTransContent.a(Unknown Source)
    
43.     at com.justep.report.xls.XLSTransContent.a(Unknown Source)
    
44.     at com.justep.report.xls.XLSTransContent.scanCols(Unknown Source)
    
45.     at com.justep.report.xls.XLSTransContent.transform(Unknown Source)
    
46.     ... 32 more
    
47. 三月 13, 2018 1:16:59 下午 org.apache.catalina.core.StandardWrapperValve invoke
    
48. 严重: Servlet.service() for servlet main-servlet threw exception
    
49. java.lang.ArrayIndexOutOfBoundsException: 7
    
50.     at com.justep.xls.Worksheet.getCell(Unknown Source)
    
51.     at com.justep.report.xls.XLSTransUtils.getSpan(Unknown Source)
    
52.     at com.justep.report.xls.XLSTransContent.a(Unknown Source)
    
53.     at com.justep.report.xls.XLSTransContent.a(Unknown Source)
    
54.     at com.justep.report.xls.XLSTransContent.scanCols(Unknown Source)
    
55.     at com.justep.report.xls.XLSTransContent.transform(Unknown Source)
    
56.     at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
    
57.     at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
    
58.     at Report.generateReportDoc(Report.java:339)
    
59.     at Report.generateReportDefine(Report.java:311)
    
60.     at Report.execute(Report.java:67)
    
61.     at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
    
62.     at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
    
63.     at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
    
64.     at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
    
65.     at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
    
66.     at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
    
67.     at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
    
68.     at com.justep.ui.WindowCompiler2.compile(Unknown Source)
    
69.     at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
    
70.     at com.justep.ui.WindowServer2.service(Unknown Source)
    
71.     at com.justep.ui.servlet.MainServlet.service(Unknown Source)
    
72.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
73.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
74.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
75.     at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
    
76.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    
77.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
78.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
79.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
80.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
81.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
82.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
83.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
84.     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
85.     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
86.     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
87.     at java.lang.Thread.run(Thread.java:745)

复制代码

jishuang

在excel的最上面多加几行空的

qweasdzxc

jishuang 发表于 2018-3-13 13:24
在excel的最上面多加几行空的

现在横向展开的不对，想要的是上面那张图的效果，结果显示的是下图的效果

jishuang

第三行上面加一空行，在空行的第一个单元格设置批注report-break:true

qweasdzxc

jishuang 发表于 2018-3-13 14:05
第三行上面加一空行，在空行的第一个单元格设置批注report-break:true

不对啊，不是我想要的效果
我想是基本工资、岗位工资、绩效工资等展开在合计前面，然后合计是对前面几项的求和

jishuang

参考/UI2/demo/report/process/simple/crossActivity.w中多维行统计的设置

qweasdzxc

jishuang 发表于 2018-3-14 10:20
参考/UI2/demo/report/process/simple/crossActivity.w中多维行统计的设置

参考了，不知道怎么改

jishuang

那多源的方式设置conditionh或者conditionv批注看看
http://docs.wex5.com/%E7%AC%AC3% ... %E7%A4%BA%E4%BE%8B/中有案例说明

qweasdzxc

jishuang 发表于 2018-3-14 11:19
那多源的方式设置conditionh或者conditionv批注看看
http://docs.wex5.com/%E7%AC%AC3%E7%AB%A0%E6%8A%A5%E ...

减法的一个表达式不知道要怎么写？

jishuang

直接写单元格相减