关于报表

tlkj

我现在在做报表 遇到几个问题 需要帮助解答
1. 我在报表设计中grouph下的selecth那一行没有数据显示是怎么回事
2.在报表设计中可以进行数据运算吗
3.如何在报表的下面输出一下固定的 如 填表人之类的 因为用的是grouph 所以会跟着grouph动和重复
4.交叉报表中是写了‘|’ 并且设置属性slant_line 但是浏览器中还是A|B 并没有斜杠5.我在数据库中sql语句得到的结果是按照一二三四五排序的 但是grouph后得到的结果却是按照拼音排序 要怎么改成一二三四五这样的
请帮忙解答下 比较着急

jishuang

1.确认单元格合并等是否正确
2.可以，但如果比较复杂的推荐在sql中处理，报表中运算会影响效率
3.可以用colspan进行列合并
4.确认批注写的是否正确
5.sql中加order by了吗？可以在sql中加group分组看看数据是什么样的排序

tlkj

1. 单元格合并是正确的
2. 执行一个加法运算都会报错
3.colspan合并的时候 比如输入2 但是输入不进去
5. 数据库中是一二三四五 但是浏览器中是按照拼音输出的  
现在有出现了问题 我没有进行更改但是进不去了
2016-03-21 10:58:30 开始-WINDOW生成中间文件: /UI2/portal/pc/index.w
2016-03-21 10:58:30 结束-WINDOW生成中间文件: /UI2/portal/pc/index.w
2016-03-21 10:58:30 开始-中间文件生成缓存文件: /UI2/portal/pc/index.w
2016-03-21 10:58:30 结束-中间文件生成缓存文件: /UI2/portal/pc/index.w
2016-03-21 10:58:30 开始-WINDOW生成中间文件: /UI2/portal/pc/index.w
2016-03-21 10:58:30 结束-WINDOW生成中间文件: /UI2/portal/pc/index.w
2016-03-21 10:58:30 开始-中间文件生成缓存文件: /UI2/portal/pc/index.w
2016-03-21 10:58:31 结束-中间文件生成缓存文件: /UI2/portal/pc/index.w
2016-03-21 10:58:32 开始-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2016-03-21 10:58:32 结束-WINDOW生成中间文件: /UI2/portal/pc/main/main.w
2016-03-21 10:58:32 开始-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2016-03-21 10:58:32 结束-中间文件生成缓存文件: /UI2/portal/pc/main/main.w
2016-03-21 10:58:36 开始-WINDOW生成中间文件: /UI2/qx/qx/process/dayReport/ribaoActivity.w
2016-03-21 10:58:36 Excel生成报表定义失败，文件名：E:/BeX5_V3.2.1/model/UI2/qx/qx/process/dayReport/ribao1.xml
javax.servlet.ServletException: java.lang.RuntimeException: Excel生成报表定义失败，文件名：E:/BeX5_V3.2.1/model/UI2/qx/qx/process/dayReport/ribao1.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生成报表定义失败，文件名：E:/BeX5_V3.2.1/model/UI2/qx/qx/process/dayReport/ribao1.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.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)
        ... 31 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 22
        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)
        ... 32 more
三月 21, 2016 10:58:36 上午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
java.lang.ArrayIndexOutOfBoundsException: 22
        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.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)
请尽快解答好吗 着急

tlkj

我把关于reportdata的引用 即 group select 等都删除了 就可以进去浏览器了 这是怎么回事
而且 我的右边reportData1除了提供的4个外还应该有 reportData1中的列名 但是我的只用提供的四个 而没有其他的列

在之前的时候我手动填上也是可以用的 现在不行了是怎么回事

tlkj

通过实验 证明 如果用select 可以在浏览器中显示 但是用selecth就会报错 group也是这种情况 但是报表必须用到h
大神给解答下好吗

tlkj

我的sql语句在sqlserver中得到的结果 是按照zyq分组得到的数据 也对zyq进行了排序 结果没问题 我的sql语句如下use qxselect zyq,disp_id,liudongxianlu,liudongzhandian,guding,qingzhangxianlu+qingzhangzhandian qingzhang,qingzhangxianlu,qingzhangzhandian from
(select zong.zyq zyq,count(zong.disp_id) disp_id,count(liudongxianlu.disp_id) liudongxianlu,count(liudongzhandian.disp_id) liudongzhandian,count(guding.disp_id) guding,count(qingzhangxianlu.disp_id) qingzhangxianlu,count(qingzhangzhandian.disp_id) qingzhangzhandian from
(select zyq,disp_id,zyq_id from v_dayReport1 where  wgsj <= '2016-03-19' and wgsj >= '2016-03-18') zong
left join
(select zyq, qxlx ,disp_id ,qxjg from v_dayReport1 where (qxlx='流动车抢修' or qxlx='中心站抢修') and xlzd='线路抢修' and  wgsj <= '2016-03-19' and wgsj >= '2016-03-18')liudongxianlu
on zong.disp_id=liudongxianlu.disp_id
left join
(select zyq, disp_id ,qxlx ,qxjg from v_dayReport1 where (qxlx='流动车抢修' or qxlx='中心站抢修') and xlzd='站点抢修'and  wgsj <= '2016-03-19' and wgsj >= '2016-03-18')liudongzhandian
on zong.disp_id=liudongzhandian.disp_id
left join
(select zyq, qxlx ,disp_id from v_dayReport1 where qxlx='固定站抢修' and  wgsj <= '2016-03-19' and wgsj >= '2016-03-18')guding
on zong.disp_id=guding.disp_id
left join
(select zyq, qxlx,disp_id from v_dayReport1 where qxlx='大抢修'and xlzd='线路抢修' and  wgsj <= '2016-03-19' and wgsj >= '2016-03-18')qingzhangxianlu
on zong.disp_id=qingzhangxianlu.disp_id
left join
(select zyq, qxlx,disp_id from v_dayReport1 where qxlx='大抢修'and xlzd='站点抢修' and  wgsj <= '2016-03-19' and wgsj >= '2016-03-18')qingzhangzhandian
on zong.disp_id=qingzhangzhandian.disp_id
group by zong.zyq )A
left join
t_work_area B
on A.zyq=B.zyq_mc
order by B.zyq_id
------------------------------------------------------------------------------
我的action也是对的 因为之前在浏览器中得到过结果 但是zyq是按照字母排序的 也就是 本来应该是一二三四五 但成了 二三四五一
--------------------------------------------------
现在在报表设计时看不到reportdta中的列，只用系统提供的那四个，并且我手动输入的时候select 和 group可以显示数据但是用selecth和grouph就会报错 报错信息是这样的
2016-03-21 12:34:42 Excel生成报表定义失败，文件名：E:/BeX5_V3.2.1/model/UI2/qx/qx/process/dayReport/ribao1.xml
javax.servlet.ServletException: java.lang.RuntimeException: Excel生成报表定义失败，文件名：E:/BeX5_V3.2.1/model/UI2/qx/qx/process/dayReport/ribao1.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生成报表定义失败，文件名：E:/BeX5_V3.2.1/model/UI2/qx/qx/process/dayReport/ribao1.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.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)
        ... 31 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 23
        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)
        ... 32 more
三月 21, 2016 12:34:42 下午 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
java.lang.ArrayIndexOutOfBoundsException: 23
        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.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)

-----------------------------------------------------------------------------------------------------------------
请帮忙调查看看 为什么会这样呢 该怎么修改呢

tlkj

我想做的报表是这样的 应该很简单 就是grouph + selecth 然后加上那些列 这样就会竖着向右输出
我的报表设计是这样的 但是会报错

jishuang

用grouph和select

grouph的有缺陷如果报类似与java.lang.ArrayIndexOutOfBoundsException: 23这样的错误就在excel的最上面添加空行多添加一下看看

tlkj

可是你看我的报表 我用select 和group能做出来吗

tlkj

我添加了20行 倒是可是进入了 但是数据显示那些表格都乱七八糟 标题什么的都没有了 这什么情况