带条件的位移报表.raq

润乾报表范例

version=1.0
7,6
<0-0>
	3:1208="25";1207="25";1102="name=ds1,sql=\"select * from sub_capital\",type=normal,param=\"\",beginrow=0,endrow=2147483647,;";1101="2";1206="25";1205="25";1202="2";1201="4"
</>
<0-1>
	3:4101="1";4306=0;2102="10";2101="60.0";4305=0;4304=0;4303="0";4302="12";4301="宋体";4413="-1";4108=0;4203="0";4202="2";4107=0;4201="1";4106=1
</>
<0-2>
	3:4101="1";4306=0;2102="10";2101="64.0";4305=0;4304=0;4303="0";4302="12";4301="宋体";4413="-1";4108=0;4203="0";4202="2";4107=0;4201="1";4106=1
</>
<0-3>
	3:4101="1";4306=0;2102="10";2101="95.0";4305=0;4304=0;4303="0";4302="12";4301="宋体";4413="-1";4108=0;4203="0";4202="2";4107=0;4201="1";4106=1
</>
<0-4>
	3:4101="1";4306=0;2102="10";2101="102.0";4305=0;4304=0;4303="0";4302="12";4301="宋体";4413="-1";4108=0;4203="0";4202="2";4107=0;4201="1";4106=1
</>
<0-5>
	3:4101="1";4306=0;2102="10";2101="120.0";4305=0;4304=0;4303="0";4302="12";4301="宋体";4413="-1";4108=0;4203="0";4202="2";4107=0;4201="1";4106=1
</>
<1-0>
	3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";3102=0;4108=0;4203="0";3101="20.0";4202="2";4107=0;4201="1";4106=1
</>
<1-1>
</>
<1-2>
</>
<1-3>
</>
<1-4>
</>
<1-5>
</>
<2-0>
	3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";3102=0;4108=0;4203="0";3101="36.0";4202="2";4107=0;4201="1";4106=1
</>
<2-1>
	3:4304=1;4303="-16751002";4302="14";4103="2,1-2,5";4102="带条件的位移报表";4201="2"
</>
<2-2>
	1:1
	2:4102
</>
<2-3>
	1:1
</>
<2-4>
	1:1
</>
<2-5>
	1:1
</>
<3-0>
	3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";3102=0;4108=0;4203="0";3101="20.0";4202="2";4107=0;4201="1";4106=1
</>
<3-1>
	3:4412="-16751002";4411="1.0";4410="5"
</>
<3-2>
	1:1
</>
<3-3>
	1:1
</>
<3-4>
	1:1
</>
<3-5>
	1:1
</>
<4-0>
	3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";3102=0;4108=0;4203="0";3101="20.0";4202="2";4107=0;4201="1";4106=1
</>
<4-1>
	1:0
	3:4103="4,1-4,2";4407="5";4406="-16751002";4405="1.0";4404="4";4403="-16751002";4402="1.0";4401="5";4303="-16751002";4410="4";4201="2";4409="-16751002";4408="1.0"
</>
<4-2>
	1:1
	3:4401="4"
</>
<4-3>
	1:1
	2:4103
	3:4102="总金额"
</>
<4-4>
	1:1
	3:4102="比上期"
</>
<4-5>
	1:1
	3:4102="比去年同期";4404="5"
</>
<5-0>
	3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";3102=0;4108=0;4203="0";3101="20.0";4202="2";4107=0;4201="1";4106=1
</>
<5-1>
	1:0
	2:4103
	3:4407="4";4102="1999年"
</>
<5-2>
	1:0
	2:4103
	3:4501="1";4407="4"
	4:4105="map(list(1,2,3,4,5,6,7,8,9,10,11,12),list(\"一月\",\"二月\",\"三月\",\"四月\",\"五月\",\"六月\",\"七月\",\"八月\",\"九月\",\"十月\",\"十一月\",\"十二月\"))";4102="list(1,2,3,4,5,6,7,8,9,10,11,12)"
</>
<5-3>
	1:1
	2:4102,4501,4105,4104
	4:4102="ds1.sum(amount,years==1999 && monthes==B5)"
</>
<5-4>
	1:1
	2:4102
	3:4104="#.00%"
	4:4102="(C5-C5[-1])/if(C5[-1]=null,1,C5[-1])"
</>
<5-5>
	1:1
	2:4102
	3:4404="5"
</>
<6-0>
	3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";3102=0;4108=0;4203="0";3101="20.0";4202="2";4107=0;4201="1";4106=1
</>
<6-1>
	1:0
	3:4102="2000年";4410="5"
</>
<6-2>
	1:0
	2:4102,4105,4104
	3:4410="5"
	4:4102="list(1,2,3,4,5,6,7,8,9,10,11,12)";4105="map(list(1,2,3,4,5,6,7,8,9,10,11,12),list(\"一月\",\"二月\",\"三月\",\"四月\",\"五月\",\"六月\",\"七月\",\"八月\",\"九月\",\"十月\",\"十一月\",\"十二月\"))"
</>
<6-3>
	1:1
	2:4102,4501,4105
	4:4102="ds1.sum(amount,years==2000 && monthes==B6)"
</>
<6-4>
	1:0
	2:4102
	3:4410="5"
	4:4102="(C6-C6[-1])/if(C6[-1]=null,1,C6[-1])"
</>
<6-5>
	1:0
	3:4410="5"
	4:4102="(C6-C5{$B6==B5})/if(C5{$B6==B5}=null, 1, C5{$B6==B5})"
</>