我用以下句话实现图片上样式,但是我想把期初写进去就不知道怎么写了,谢谢大家
select case grouping(a.sswz) when 1 then '合计' when 0 then case grouping(a.sswz) when 1 then a.sswz + ' SubTotal' when 0 then '' End end ' ',
d.zdrq as 制单日期,a.djbh,c.wlbh, c.wlmc, c.dw, c.wlgg,a.lx,
case when a.lx='销售出库'then ABS(sum(a.sssl)) else case when a.lx='其它出库'then ABS(sum(a.sssl)) else case when a.lx='销售退回'then sum(-a.sssl) else case when a.lx='销售出库红冲'then sum(-a.sssl) else sum(a.sssl)END END END END as 数量,
a.ckmc,f.dwmc from wl_rk a
inner join wl_flmx c on a.sp_rowid=c.ID
inner join wl_rkwl d on a.djbh=d.djbh
inner join user_id e on d.created_by=e.emp_rowid
inner join GY_KF_DW f on a.dw_rowid=f.id
where d.zdrq BETWEEN '2017-8-1' AND '2017-9-2 23:59:59' and a.djbh like '%%' and c.wlbh like '%%' and c.wlmc like '%%' and a.ckmc like '%徐州仓库%' and d.sh=1 and f.user_id like '%钟涛%' and a.djbh NOT LIKE 'XSC%'
group by c.wlbh,c.wlmc,c.dw,c.wlgg,a.ckmc,d.zdrq,a.djbh,a.sssl,a.lx,f.dwmc,a.sswz with rollup
having(grouping(c.wlbh) + grouping(c.wlmc)) +grouping(c.dw)+grouping(a.ckmc)+grouping(a.sswz) = 0 or
grouping(c.wlbh)+grouping(c.wlmc)+grouping(c.dw)+grouping(a.ckmc) = 3 order by c.wlbh,a.lx DESC,d.zdrq