cross.raq

润乾报表范例

version=1.0
5,4
<0-0>
	3:1105="en=\"buy_date\",ch=\"日期\",tp=2,w=,fmt=\"yyyy-mm-dd\",val=\"2003-6-1\";";1208="25";1207="25";1102="name=ds1,sql=\"SELECT customer.customer_id, customer.customer_name from customer\",type=normal,param=\"\",beginrow=0,endrow=0,;name=ds3,sql=\"SELECT buy_record.id, buy_record.buy_date, buy_record.product, buy_record.quantity from buy_record\",type=normal,param=\"\",beginrow=0,endrow=0,;name=ds2,sql=\"SELECT product.product_id, product.product_name from product\",type=normal,param=\"\",beginrow=0,endrow=0,;";1101="2";1206="25";1205="25";1202="2";1201="4"
</>
<0-1>
	3:4101="1";4306=0;2102="10";2101="98.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="3.0";4305=0;4304=0;4303="-16777216";4302="12";4301="宋体";4413="-1";4108=0;4203="4";4202="2";4107=0;4201="1";4106=0
</>
<0-3>
	3:4101="1";4306=0;2102="10";2101="90.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="0";4413="-1";3102=0;4108=0;4203="0";3101="49.0";4202="2";4107=0;4201="1";4106=1
</>
<1-1>
	3:4409="-2565893";4304=1;4408="2.0";4303="-16777216";4407="4";4302="16";4103="1,1-1,3";4403="-2565893";4102="交叉报表";4402="2.0";4401="4";4413="-198922";4201="2"
</>
<1-2>
	1:1
	2:4304,4303,4302,4403,4102,4402,4401
</>
<1-3>
	1:1
	3:4304=1;4302="16";4406="-2565893";4405="2.0";4404="4"
</>
<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="46.0";4202="2";4107=0;4201="1";4106=1
</>
<2-1>
	1:0
	2:4409,4304,4408,4407,4302,4103,4201
	3:4406="-4144960";4404="5";4102="客户,产品,购买数量";4414="2";4413="-265486";4412="-3355444";4411="1.0";4410="4"
</>
<2-2>
	1:1
	2:4303,4102,4402,4414,4411
	3:4406="-3355444";4404="2";4403="-4144960";4401="5";4413="-198922"
</>
<2-3>
	1:0
	2:4304,4409,4408,4302,4407
	3:4103="";4501="2";4403="-3355444";4401="2";4303="-16777216";4413="-199950";4412="-3355444";4202="1";4410="4"
	4:4102="ds2.group(product_id,false)";4105="ds2.select_one(product_name,product_id=@value)"
</>
<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="2.0";4202="2";4107=0;4201="1";4106=1
</>
<3-1>
	1:0
	2:4102,4414
	3:4407="4";4203="4";4409="-3355444";4408="1.0"
</>
<3-2>
	1:0
	2:4413
	3:4409="-3355444";4407="4";4404="4";4411="3.0"
</>
<3-3>
	1:0
	2:4103,4102,4501,4303,4202,4201,4105
	3:4409="-3355444";4407="4";4401="4";4413="-198151";4411="1.0"
</>
<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="19.0";4202="2";4107=0;4201="1";4106=1
</>
<4-1>
	1:0
	2:4203
	3:4501="1";4412="-2565893";4411="2.0";4201="2"
	4:4102="ds1.group(customer_id,false)";4105="ds1.select_one(customer_name,customer_id=@value)"
</>
<4-2>
	1:0
	3:4408="3.0";4404="2";4413="-198922";4412="-2565893";4411="2.0"
</>
<4-3>
	1:0
	3:4103="";4401="2";4303="-16777216";4412="-2565893";4411="2.0";4201="2";4408="1.0"
	4:4102="ds3.sum(quantity,id==A4 && product==C2)"
</>