statisgraph1.raq

润乾报表范例

version=1.0
6,4
<0-0>
	3:1208="25";1207="25";1102="name=ds1,sql=\"SELECT buy_record.id,  buy_record.quantity,  buy_record.product, buy_record.price FROM buy_record\",type=normal,param=\"\",beginrow=0,endrow=2147483647,;name=ds2,sql=\"SELECT customer.customer_id, customer.customer_name FROM customer\",type=normal,param=\"\",beginrow=0,endrow=2147483647,;name=ds3,sql=\"SELECT product.product_id, product.product_name FROM product\",type=normal,param=\"\",beginrow=0,endrow=2147483647,;";1101="2";1206="25";1205="25";1202="2";1201="4"
</>
<0-1>
	3:2102="10";2101="594.0"
</>
<0-2>
	3:4106=0;2102="10";2101="100.0"
</>
<0-3>
	3:4106=0;2102="10";2101="93.0"
</>
<1-0>
	3:3103="10";3102=0;3101="18.0"
</>
<1-1>
</>
<1-2>
</>
<1-3>
</>
<2-0>
	3:3103="10";3102=0;3101="20.0";4106=0
</>
<2-1>
	3:4102="客户";4502="";4201="2"
</>
<2-2>
	1:1
	2:4502
	3:4102="产品"
</>
<2-3>
	1:1
	3:4102="购买数量"
</>
<3-0>
	3:3103="10";3102=0;3101="26.0";4106=1
</>
<3-1>
	3:4501="1"
	4:4105="ds2.select_one(#2,#1=@value)";4102="ds1.group(#1,true)"
</>
<3-2>
</>
<3-3>
</>
<4-0>
	3:3103="10";3102=0;3101="105.0"
</>
<4-1>
	3:4103="4,1-5,1";4701="";4101="4";4502="a3"
	4:4102="graph(\"displayValueFormat=\\\"#0.00\\\",graphFormat=\\\"JPG\\\",backTransparent=\\\"0\\\",xValues=,type=\\\"2\\\",axisColor=\\\"-16777216\\\",legendLocation=\\\"2\\\",yStartValue=,categoryExp=\\\"b5\\\",displayValue=\\\"1\\\",gridLineColor=\\\"-4144960\\\",yUnit=\\\"1\\\",statusTimeType=\\\"4\\\",gridLineType=\\\"1\\\",alarmLines=,xTitle=\\\"客户\\\",yTitle=\\\"产品\\\",graphTitle=\\\"客户购买统计图\\\",backColor=\\\"-1\\\",fonts=\\\"0=宋体,0,12,0,-16777216,0,0&1=宋体,0,12,0,-16777216,0,0&2=宋体,0,12,0,-16777216,1,0&3=宋体,0,12,0,-16777216,0,0&4=宋体,0,12,0,-16777216,0,0&5=宋体,0,12,0,-16777216,0,0&6=宋体,0,12,0,-16777216,0,0\\\",graphTransparent=\\\"0\\\",seriesValuesExp=\\\"C2=C5\\\",=\")"
</>
<4-2>
</>
<4-3>
</>
<5-0>
	3:3103="10";3102=0;3101="40.0"
</>
<5-1>
	1:0
	2:4102,4701,4101
</>
<5-2>
	3:4104="";4501="1"
	4:4105=" ds3.select_one(product_name,product_id=@value)";4102="ds1.group(#3,true)"
</>
<5-3>
	4:4102="ds1.#2"
</>