预算执行分析浮动表客服

1、【】选择项=select distinct gsdm,gsmc from pubgszl where kjnd=2008&返回字段=gsdm;gsmc&是否多选=1数据源：【账套】select distinct ztbh,ztmc from gl_ztcs where kjnd=2008 and ztmc系统账套【经费支出总】select kjnd,kjqj,zth,sum(case when fzdm5 like 301% then jfje else 0 end) as je301,sum(case when fzdm5 like 302% then jfje else 0 end) as

2、 je302,sum(case when fzdm5 like 303% then jfje else 0 end) as je303,sum(case when fzdm5 like 304% then jfje else 0 end) as je304 , sum(case when fzdm5 like 305% then jfje else 0 end) as je305 , sum(case when fzdm5 like 306% then jfje else 0 end) as je306 , sum(case when fzdm5 like 307% then jfje els

3、e 0 end) as je307 , sum(case when fzdm5 like 308% then jfje else 0 end) as je308, sum(case when fzdm5 like 309% then jfje else 0 end) as je309,sum(case when fzdm5 like 310% then jfje else 0 end) as je310, sum(case when fzdm5 like 311% then jfje else 0 end)as je311, sum(case when fzdm5 like 399%then

4、jfje else 0 end) as je399 from gl_view_yeb wherekjqj= and(jfje-dfje)0 and fzdm5 like 3% group bykjnd,kjqj,zth图表设置：报表属性：表样：表公式列表：A1=柞水县+SubString(Param(kjqj),1,4)+年+SubString(Param(kjqj),5,2)+费支出表A2=RelativeCell(-12,0)+RelativeCell(-11,0)+RelativeCell(-10,0)+RelativeCell(-9,0)+RelativeCell(-8,0)+Rela

5、tiveCell(-7,0)+RelativeCell(-6,0)+RelativeCell(-5,0)+RelativeCell(-4,0)+RelativeCell(-3,0)+RelativeCell(-2,0)+RelativeCell(-1,0) A4=Field(经费支出总.zth)B4=DictTrans(账套,Field(经费支出总.zth),ztbh,ztmc) C4=Field(经费支出总.je301)D4=Field(经费支出总.je302) E4=Field(经费支出总.je303) F4=Field(经费支出总.je304) G4=Field(经费支出总.je305)

6、 H4=Field(经费支出总.je306) I4=Field(经费支出总.je307) J4=Field(经费支出总.je308) K4=Field(经费支出总.je309) L4=Field(经费支出总.je310) M4=Field(经费支出总.je311) N4=Field(经费支出总.je399)O4=RelativeCell(-12,0)+RelativeCell(-11,0)+RelativeCell(-10,0)+RelativeCell(-9,0)+RelativeCell(-8,0)+RelativeCell(-7,0)+RelativeCell(-6,0)+RelativeCell(-5,0)+RelativeCell(-4,0)+RelativeCell(-3,0)+RelativeCell(-2,0)+RelativeCell(-1,0)-重点说明：代码名称工资福利支出其他支出合计#Field(经费支出总.zth)#DictTrans(账套,Field(经费支出总.zth),ztbh,ztmc) #Field(经费支出总.je301)#Field(经费支出总.je399)#RelativeCell(-2,0)+RelativeCell(-1,0)-常用