报表制作

天啦噜404

报表中的group前半部分可以用，后半部分不能用，这是什么原因 SQL语句：

1. SELECT p.part part,p.name NAME,p.point POINT,r.ID ID,r.c c,rt.TWA TWA,rt.STEL STEL ,s.TWA sTWA,s.STEL sSTEL ,r.test test,r.SN sn FROM point_name p left JOIN(result r left JOIN (report rt LEFT JOIN samp_gbz s ON rt.test = s.name)ON r.SN = rt.SN AND r.test = rt.test) ON p.point = rt.point where p.SN = 'HKZJ170056' and r.SN = 'HKZJ170056'

复制代码

jishuang

前面的都已经分开了，后面的就不能通过group合并

天啦噜404

jishuang 发表于 2017-4-5 13:34
前面的都已经分开了，后面的就不能通过group合并

那报表有没有属性可以把后面的合在一起呢，后面的数据都是只有一个值

jishuang

可以自己用rowspan批注设置

天啦噜404

jishuang 发表于 2017-4-5 14:47
可以自己用rowspan批注设置

请问有关于这方面的文档或者案例吗？

jishuang

http://bbs.wex5.com/forum.php?mod=viewthread&tid=48236

天啦噜404

jishuang 发表于 2017-4-5 17:36
http://bbs.wex5.com/forum.php?mod=viewthread&tid=48236

报错，你能看看我哪里写错了吗

1. 2017-05-12 17:01:32 Excel生成报表定义失败，文件名：D:/HK_V3.6/model/UI2/OA/TextReport/process/TextReport/mainActivity.xml
   
2. javax.servlet.ServletException: java.lang.RuntimeException: Excel生成报表定义失败，文件名：D:/HK_V3.6/model/UI2/OA/TextReport/process/TextReport/mainActivity.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生成报表定义失败，文件名：D:/HK_V3.6/model/UI2/OA/TextReport/process/TextReport/mainActivity.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.execute(Unknown Source)
    
30.         at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
    
31.         at com.justep.ui.WindowCompiler2.compile(Unknown Source)
    
32.         at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
    
33.         at com.justep.ui.WindowServer2.service(Unknown Source)
    
34.         ... 17 more
    
35. Caused by: java.lang.RuntimeException: Excel生成报表定义失败
    
36.         at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
    
37.         ... 30 more
    
38. Caused by: java.lang.NumberFormatException: For input string: "$PD19"
    
39.         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    
40.         at java.lang.Integer.parseInt(Integer.java:569)
    
41.         at java.lang.Integer.valueOf(Integer.java:766)
    
42.         at com.justep.report.xls.XLSTransformer.a(Unknown Source)
    
43.         at com.justep.report.xls.XLSTransformer.a(Unknown Source)
    
44.         ... 31 more
    
45. 五月 12, 2017 5:01:32 下午 org.apache.catalina.core.StandardWrapperValve invoke
    
46. 严重: Servlet.service() for servlet main-servlet threw exception
    
47. java.lang.NumberFormatException: For input string: "$PD19"
    
48.         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    
49.         at java.lang.Integer.parseInt(Integer.java:569)
    
50.         at java.lang.Integer.valueOf(Integer.java:766)
    
51.         at com.justep.report.xls.XLSTransformer.a(Unknown Source)
    
52.         at com.justep.report.xls.XLSTransformer.a(Unknown Source)
    
53.         at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
    
54.         at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
    
55.         at Report.generateReportDoc(Report.java:339)
    
56.         at Report.generateReportDefine(Report.java:311)
    
57.         at Report.execute(Report.java:67)
    
58.         at com.justep.ui.component.ComponentEngine.processServerTemplate(Unknown Source)
    
59.         at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
    
60.         at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
    
61.         at com.justep.ui.component.ComponentEngine.parser(Unknown Source)
    
62.         at com.justep.ui.component.ComponentEngine.execute(Unknown Source)
    
63.         at com.justep.ui.WindowCompiler2.w2Middle(Unknown Source)
    
64.         at com.justep.ui.WindowCompiler2.compile(Unknown Source)
    
65.         at com.justep.ui.WindowServer2.compileWindow(Unknown Source)
    
66.         at com.justep.ui.WindowServer2.service(Unknown Source)
    
67.         at com.justep.ui.servlet.MainServlet.service(Unknown Source)
    
68.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
69.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
70.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
71.         at com.justep.portal.filter.RedirectFilter.doFilter(Unknown Source)
    
72.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    
73.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
74.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
75.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
76.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
77.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
78.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
79.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
80.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
81.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
82.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
83.         at java.lang.Thread.run(Thread.java:745)
    
84. 
    

复制代码

jishuang

$PR19C5
不能写$PD19

天啦噜404

jishuang 发表于 2017-5-12 17:13
$PR19C5
不能写$PD19

按照你说的改了之后发现还是没有用，这个$PR19C5是什么意思，你能说明一下吗，可能我的报表有些东西需要设置一下

jishuang

按照第19行第5列单元格的扩展合并

应该写错了，你的D19应该是第19行第4列，改为$PR19C4看看