groupsum.raq

润乾报表范例

version=1.0
10,6
<0-0>
	3:1105="";1208="25";1207="25";1102="name=ds1,sql=\"SELECT buy_record.id, buy_record.buy_date, buy_record.product, buy_record.quantity, buy_record.price from buy_record\",type=normal,param=\"\",beginrow=0,endrow=0,;name=ds3,sql=\"SELECT product.product_id, product.product_name from product\",type=normal,param=\"\",beginrow=0,endrow=0,;name=ds2,sql=\"SELECT customer.customer_id, customer.customer_name from customer\",type=normal,param=\"\",beginrow=0,endrow=0,;";1101="2";1206="25";1205="25";1202="2";1201="4"
</>
<0-1>
	3:2102="10";2101="72.0"
</>
<0-2>
	3:4101="1";4306=0;2102="10";2101="155.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="168.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="119.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="161.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:3103="10";3102=0;4413="-1";4412="-16777216";3101="38.0";4411="0.75";4410="1";4203="0";4202="2";4201="1";4108=0;4107=0;4106=1;4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体"
</>
<1-1>
	3:4303="-10092544";4302="18";4301="隶书";4103="1,1-1,5";4102="客户购买汇总表";4413="-198665";4412="-205604";4201="2";4411="3.0";4410="4"
</>
<1-2>
	1:1
	2:4102
</>
<1-3>
	1:1
</>
<1-4>
	1:1
</>
<1-5>
	1:1
	2:4303,4301,4413,4201
</>
<2-0>
	3:3103="10";4306=0;3102=0;4305=0;3101="20.0";4108=0;4304=0;4303="0";4107=0;4302="12";4106=1;4301="宋体";4413="-1";4101="1";4409="-16777216";4408="0.75";4407="1";4406="-201749";4405="3.0";4404="4";4203="0";4202="2";4201="1"
</>
<2-1>
	1:0
	2:4103,4411
	3:4407="4";4102="汇总项目";4406="-205604";4404="4";4403="-205604";4402="3.0";4401="4";4302="16";4413="-199179";4409="-205604";4408="3.0"
</>
<2-2>
	1:1
	2:4402
	3:4102="汇总明细"
</>
<2-3>
	1:1
	3:4102="购买日期";4413="-197894"
</>
<2-4>
	1:1
	3:4102="购买数量";4413="-528401"
</>
<2-5>
	1:1
	3:4102="购买金额";4405="3.0";4413="-66822"
</>
<3-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="3.0";4202="2";4107=0;4201="1";4106=1
</>
<3-1>
	1:0
	2:4102,4303,4302,4301,4413,4201,4408
</>
<3-2>
	1:0
	2:4102,4302,4301,4408
	3:4203="4"
</>
<3-3>
	1:0
	2:4102,4302,4301,4408
	3:4203="4"
</>
<3-4>
	1:0
	2:4102,4302,4301,4408
	3:4203="4"
</>
<3-5>
	1:0
	2:4102,4302,4301,4408
	3:4203="4"
</>
<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="17.0";4202="2";4107=0;4201="1";4106=1
</>
<4-1>
	1:0
	3:4103="4,1-5,1";4102="客户";4501="1";4303="-10092544";4413="-199179";4201="2"
</>
<4-2>
	1:1
	2:4102,4402
	3:4103="4,2-5,2"
	4:4102="ds1.group(id,true)";4105="ds2.select_one(customer_name, customer_id == @value)"
</>
<4-3>
	1:0
	2:4203
	3:4501="1";4104="yyyy-MM-dd"
	4:4102="ds1.group(buy_date,false)"
</>
<4-4>
	1:0
	2:4203
	4:4102="ds1.sum(quantity)"
</>
<4-5>
	1:0
	2:4203
	3:4201="3"
	4:4102="ds1.sum(quantity*price)"
</>
<5-0>
	3:3103="10";3102=0;4406="-16777216";3101="18.0";4405="0.75";4404="1";4412="-16777216";4411="0.75";4410="1"
</>
<5-1>
	1:0
	2:4102,4501,4303,4413,4201
</>
<5-2>
	1:0
	2:4102,4501,4413,4201,4105
	3:4303="-16777216"
</>
<5-3>
	1:0
	2:4501,4413,4104
	3:4303="-10092493";4102="小计：";4201="3"
</>
<5-4>
	1:0
	2:4102,4413
	3:4303="-10092493";4502="B4"
	4:4102="sum(D4[B4:0]{})"
</>
<5-5>
	1:0
	2:4102,4413,4201
	4:4102="sum(E4[B4:0]{})"
</>
<6-0>
	3:4409="-16777216";3103="10";4408="0.75";3102=0;4407="1";4406="-16777216";3101="16.0";4405="0.75";4404="1";4412="-16777216";4411="0.75";4410="1"
</>
<6-1>
	1:0
	2:4103
	3:4303="-10092544"
</>
<6-2>
	1:1
	2:4402
	3:4102=""
</>
<6-3>
	1:0
	3:4303="-10092544";4102="总计："
</>
<6-4>
	1:0
	2:4102,4502
	3:4303="-10092544"
	4:4102="sum(D4{})"
</>
<6-5>
	1:0
	2:4102
</>
<7-0>
	3:3103="10";3102=0;4413="-1";3101="16.0";4203="0";4409="-16777216";4202="2";4408="0.75";4201="1";4108=0;4407="1";4107=0;4106=1;4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体"
</>
<7-1>
	1:0
	3:4103="7,1-8,1";4102="产品";4501="1";4413="-199179";4201="2"
</>
<7-2>
	1:1
	2:4102,4402
	3:4103="7,2-8,2"
	4:4102="ds1.group(product,true)";4105="ds3.select_one(product_name,product_id==@value)"
</>
<7-3>
	1:1
	2:4102,4103,4105
	3:4413="-197894";4104="yyyy-MM-dd"
	4:4102="ds1.group(buy_date,false)"
</>
<7-4>
	1:0
	2:4102
	3:4413="-528401"
	4:4102="ds1.sum(quantity)"
</>
<7-5>
	1:0
	3:4413="-66822";4201="3"
	4:4102="ds1.sum(quantity*price)"
</>
<8-0>
	3:3103="10";3102=0;3101="16.0"
</>
<8-1>
	1:0
	2:4102,4501,4303,4413,4201
</>
<8-2>
	1:0
	2:4102,4501,4303,4413,4201,4105
</>
<8-3>
	1:0
	2:4501,4413,4104
	3:4102="小计：";4201="3"
</>
<8-4>
	1:0
	2:4102,4413
	4:4102="sum(D7[B7:0]{})"
</>
<8-5>
	1:0
	2:4102,4413,4201
</>
<9-0>
	3:3103="10";3102=0;3101="18.0"
</>
<9-1>
	1:0
	2:4103,4402
	3:4303="-10092544";4102="";4201="3";4411="3.0"
</>
<9-2>
	1:1
	2:4102
</>
<9-3>
	1:1
	3:4102="总计："
</>
<9-4>
	1:0
	2:4102
	3:4411="3.0"
	4:4102="sum(D7{})"
</>
<9-5>
	1:0
	3:4411="3.0"
</>