关于报表

jishuang

用System.out.println(new com.justep.system.transform.Table2Row().transform(table,null).asXML());把用到的table的内容输出，然后把excel和输出的内容都发一下

tlkj

这是我的excel 文件

                String sql= " select zyq zyq,liudongxianlu liudongxianlu,liudongzhandian liudongzhandian,guding guding,qingzhangxianlu+qingzhangzhandian qingzhang,qingzhangxianlu qingzhangxianlu,qingzhangzhandian qingzhangzhandian,liudongxianlu+qingzhangxianlu xianluqiangxiu,liudongzhandian+guding+qingzhangzhandian zhandianqiangxiu,liudongzhandian+guding+qingzhangzhandian+liudongxianlu+qingzhangxianlu qiangxiuzong,liudongxianlu+liudongzhandian liudongqiangxiu 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 from v_dayReport1 where  wgsj <= '"+hou+"' and wgsj >= '"+qian+"') zong"
                                        +" left join"
                                        +" (select disp_id from v_dayReport1 where (qxlx='流动车抢修' or qxlx='中心站抢修') and xlzd='线路抢修'and wgsj <= '"+hou+"' and wgsj >= '"+qian+"') liudongxianlu "
                                        +" on zong.disp_id=liudongxianlu.disp_id"
                                        +" left join"
                                        +" (select disp_id from v_dayReport1 where (qxlx='流动车抢修' or qxlx='中心站抢修') and xlzd='站点抢修'and wgsj <= '"+hou+"' and wgsj >= '"+qian+"') liudongzhandian"
                                        +" on zong.disp_id=liudongzhandian.disp_id"
                                        +" left join"
                                        +" (select disp_id from v_dayReport1 where qxlx='固定站抢修'and wgsj <= '"+hou+"' and wgsj >= '"+qian+"') guding"
                                        +" on zong.disp_id=guding.disp_id"
                                        +" left join"
                                        +" (select disp_id from v_dayReport1 where qxlx='大抢修'and xlzd='线路抢修'and wgsj <= '"+hou+"' and wgsj >= '"+qian+"') qingzhangxianlu"
                                        +" on zong.disp_id=qingzhangxianlu.disp_id"
                                        +" left join"
                                        +" (select disp_id from v_dayReport1 where qxlx='大抢修'and xlzd='站点抢修' and wgsj <= '"+hou+"' and wgsj >= '"+qian+"') 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 ";
//                String sql="select zyq zyq from v_dayReport1 where  wgsj <= '"+hou+"' and wgsj >= '"+qian+"'";
        HashMap<String,String> sqlMap = new HashMap<String,String>();
        sqlMap.put(SQL.DEFAULT_DB_NAME,sql);

        return SQL.select(sqlMap,null,"/qx/qx/data");

------------------------这是我调用的action 我该怎么改呢

jishuang

return SQL.select(sqlMap,null,"/qx/qx/data");
改为
Table table = SQL.select(sqlMap,null,"/qx/qx/data");
System.out.println(new com.justep.system.transform.Table2Row().transform(table,null).asXML());
return table;

报表用到几个data把几个data的都输出，标注一下对应的那个data

jishuang

return SQL.select(sqlMap,null,"/qx/qx/data");
改为
Table table = SQL.select(sqlMap,null,"/qx/qx/data");
System.out.println(new com.justep.system.transform.Table2Row().transform(table,null).asXML());
return table;

报表用到几个data把几个data的都输出，标注一下对应的那个data