占比报表.raq

润乾报表范例

version=1.0
11,4
<0-0>
	3:1105="en=\"month\",ch=\"月\",tp=17,w=,fmt=,val=\"8\";en=\"year1\",ch=\"年\",tp=17,w=,fmt=,val=\"2000\";";1208="25";1207="25";1102="name=ds1,sql=\"select * from sub_capital\",type=normal;name=ds3,sql=\"select * from capital\",type=normal;name=ds2,sql=\"select * from item\",type=normal";1101="2";1206="25";1205="25";1202="2";1201="4"
</>
<0-1>
	3:4101="1";4306=0;2102="10";2101="160";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="129";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="176";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="3";4413="-1";3102=0;4108=0;4203="0";3101="20";4202="2";4107=0;4201="1";4106=1
</>
<1-1>
	3:4303="-16751002";4102="北京润乾软件有限公司";4413="-590853";4412="-16751002";4411="1.0";4305=1;4410="4"
</>
<1-2>
	1:1
	2:4303,4102,4305
</>
<1-3>
	1:1
	3:4108=1;4303="-16751002";4102="www.runqian.com.cn";4201="3"
</>
<2-0>
	3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="0";4413="-1";3102=0;4108=0;4203="0";3101="20";4202="2";4107=0;4201="1";4106=1
</>
<2-1>
	1:0
	2:4412,4411,4305,4410
	3:4304=1;4409="-16751002";4408="1.0";4302="20";4407="4";4301="隶书";4103="2,1-3,3";4102="占 比 报 表";4201="2"
</>
<2-2>
	1:1
	2:4102
</>
<2-3>
	1:1
</>
<3-0>
	3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="0";4413="-1";3102=0;4108=0;4203="0";3101="20";4202="2";4107=0;4201="1";4106=1
</>
<3-1>
	1:0
	2:4409,4408,4407,4102
</>
<3-2>
	1:0
	2:4409,4408,4407
</>
<3-3>
	1:0
	2:4409,4408,4407
</>
<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="24";4202="2";4107=0;4201="1";4106=1
</>
<4-1>
	1:0
	2:4304,4302,4301,4103
	3:4406="-4004893";4405="0.5";4404="4";4403="-4004893";4402="3.0";4401="4";4303="-16777216";4413="-1180420";4412="-4004893";4411="0.5";4410="4"
</>
<4-2>
	1:1
	3:4413="-852226";4201="3";4402="0.5";4102="占比";4305=1;4304=1;4303="-16751002"
</>
<4-3>
	1:1
	3:4413="-1180420";4405="3.0";4102="实际金额"
</>
<5-0>
	3:4101="1";4306=0;4305=0;4304=0;4303="-16777216";4302="12";4301="宋体";3103="10";4413="-1";3102=0;4108=0;4203="4";3101="2";4202="2";4107=0;4201="1";4106=1
</>
<5-1>
	1:0
	2:4413,4201
	3:4407="4";4203="4";4409="-4004893";4408="0.5"
</>
<5-2>
	1:1
	3:4402="0.5";4201="3"
</>
<5-3>
	1:1
	3:4405="3.0"
</>
<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";4202="2";4107=0;4201="1";4106=1
</>
<6-1>
	1:0
	2:4203
	3:4413="-1180420";4502="";4501="1";4305=1;4304=1;4303="-10079488"
	4:4102="ds2.group(type,true)"
</>
<6-2>
	1:0
	2:4203
	3:4303="-10079488";4413="-852226";4104="#0.000"
	4:4102="sum(C7[A6:0]{})/C8"
</>
<6-3>
	1:0
	2:4203
	3:4413="-1180420";4104="#,##0.000";4303="-10079488"
	4:4102="sum(C7{})"
</>
<7-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";4202="2";4107=0;4201="1";4106=1
</>
<7-1>
	1:0
	2:4102
	3:4502="A6";4303="-16751002";4413="-1179649";4201="3"
	4:4105="ds2.select_one(name,id=@value)";4102="ds2.group(id,true)"
</>
<7-2>
	1:0
	2:4102
	3:4602=0;4303="-16777216";4601=0
	4:4102="C7/C8"
</>
<7-3>
	1:0
	2:4102
	3:4105="";4303="-16777216"
	4:4102="ds1.sum(amount,years==@year1 && monthes==@month && item==A7)"
</>
<8-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";4202="2";4107=0;4201="1";4106=1
</>
<8-1>
	1:0
	2:4502,4501,4105,4201
	3:4102="资产总额";4303="-16777063";4411="3.0"
</>
<8-2>
	1:0
	2:4102,4602,4601
	3:4303="-16777063";4411="3.0"
	4:4102="sum(C7{})/C8"
</>
<8-3>
	1:0
	2:4102,4105
	3:4411="3.0";4303="-16777063"
	4:4102="ds1.sum(amount,years==@year1 && monthes==@month)"
</>
<9-0>
	3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="2";4413="-1";3102=0;4108=0;4203="0";3101="20";4202="2";4107=0;4201="1";4106=1
</>
<9-1>
	1:0
	2:4102,4406,4405,4404,4403,4402,4401,4305,4304,4412,4411,4410
	3:4303="-16751002";4408="3.0";4413="-525317"
</>
<9-2>
	1:1
</>
<9-3>
	1:1
</>
<10-0>
	3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="4";4413="-1";3102=0;4108=0;4203="0";3101="20";4202="2";4107=0;4201="1";4106=1
</>
<10-1>
	1:0
	2:4409,4408,4407
	3:4102="电话：82893346"
</>
<10-2>
	1:0
	2:4409,4408,4407
	3:4102="传真：82896075"
</>
<10-3>
	1:0
	2:4409,4408,4407
	3:4108=1;4102="email:[e-mail]"
</>