预览显示全部（行前分页：没选参数时能展示全部的模版，例如图二、图三一起显示）急！

yangyan520(提问者)

你咋跟客服回答的一样，

回复

2016-09-07 15:47 

取消 回复

yixingtianyuan

看楼主的描述，就是指这个功能了啊！

回复

2016-09-07 15:51 

取消 回复

yixingtianyuan

论坛内有很多这类的帖子，可以看下，希望可以帮得到楼主http://bbs.fanruan.com/thread-57565-1-1.html，http://bbs.fanruan.com/thread-71475-1-1.html

回复

2016-09-07 15:54 

取消 回复

yangyan520(提问者)



select  right(a.wd13,2) id, a.WD02  ,a.WD03 ,a.WD04  ,a.wd05+\'-\'+a.wd06 as wd05  ,a.WD07 , a.WD08 ,
sum(isnull(a.DL01 ,0)+ISNULL(a.DL02 ,0))  dl01
,sum(isnull(a.DL14 ,0)) as DL02
,sum(isnull(a.DL07 ,0)) dl04
,sum(isnull(c.DL07 ,0)) dl05
,isnull(a.DL03,0) as dl07
,a.wd12
,a.wd14
,a.WD09
,a.WD18
,a.WD19
,a.WD21
,a.wd22
from [dbo].[T_RESULT_02]  a
      left join [dbo].[T_RESULT_02]  c
on a.WD04=c.WD04     and a.WD05-1=c.WD05    and  a.WD06=c.WD06    and a.WD08=c.WD08   and  a.WD10=c.WD10    and a.WD11=c.WD11   and a.WD12=c.WD12   and a.WD13=c.WD13   
where    a.wd15=\'4\'   and a.wd07=\'${company_name}\'  and a.wd05+\'-\'+a.wd06=\'${date}\'
and a.WD04 =\'10001\'  and (a.WD29 is null or a.WD29<>\'是\')  and a.wd31=\'是\'
and  a.WD05  in (\'2014\',\'2013\')
group by  a.WD02  ,a.WD03 ,a.WD04  ,a.WD05  ,a.WD06  ,a.WD07 , a.WD08 ,a.DL03 ,a.DL01,a.DL02,a.wd14,a.wd12,right(a.wd13,2),a.WD09
,a.WD18
,a.WD19
,a.WD21
,a.wd22
union
select  right(a.wd13,2) id, a.WD02  ,a.WD03 ,a.WD04  ,a.wd05+\'-\'+a.wd06 as wd05  ,a.WD07 , a.WD08 ,
sum(isnull(a.DL01 ,0))  dl01
,sum(isnull(a.DL14 ,0)) as DL02
, sum(isnull(a.DL07 ,0)) dl04
, sum(isnull(a.DL08 ,0)) dl05
,isnull(a.DL03,0) as dl07
,a.wd12
,a.wd14
,a.WD09
,a.WD18
,a.WD19
,a.WD21
,a.wd22
from [dbo].[T_RESULT_02]  a
      left join [dbo].[T_RESULT_02]  c
on a.WD04=c.WD04     and a.WD05-1=c.WD05    and  a.WD06=c.WD06    and a.WD08=c.WD08   and  a.WD10=c.WD10    and a.WD11=c.WD11   and a.WD12=c.WD12   and a.WD13=c.WD13   
where   a.wd07=\'${company_name}\'  and a.wd05+\'-\'+a.wd06=\'${date}\'
and a.WD04 =\'10001\'  and (a.WD29 is null or a.WD29<>\'是\')  and a.wd15 in (\'3\',\'4\',\'1\',\'2\')
and  a.WD05 not in (\'2014\',\'2013\')
group by  a.WD02  ,a.WD03 ,a.WD04  ,a.WD05  ,a.WD06  ,a.WD07 , a.WD08 ,a.DL03 ,a.DL01,a.DL02,a.wd14,a.wd12,right(a.wd13,2),a.WD09
,a.WD18
,a.WD19
,a.WD21
,a.wd22

回复

2016-09-07 16:19 

取消 回复

quiet3008559

你这里我看到两个参数${company_name}和${date}，你的业务组是哪个参数啊？
可以这么写一下，用前一个参数举例吧。
${if(len(company_name)==0,\"\",\" and a.wd07=\'\"+company_name+\"\' \")}

回复

2016-09-07 15:33 

取消 回复