multicross.raq

润乾报表范例

version=1.0
8,6
<0-0>
	3:1107="ordertype=,DESC";1105="en=\"a\",ch=\"\",tp=17,w=,fmt=\"\",val=\"5\";en=\"start\",ch=\"\",tp=2,w=,fmt=\"\",val=\"1999-01-01\";en=\"end\",ch=\"\",tp=2,w=,fmt=\"\",val=\"2004-01-01\";";1208="25";1207="25";1102="name=ds1,sql=\"SELECT income.dept, income.class, income.sex, income.area, income.income from income WHERE  income.income >? order by area ordertype\",type=normal,param=\"a:6\",beginrow=0,endrow=0,;name=ds2,sql=\"SELECT dept.id,dept.name FROM dept\",type=normal,param=\"\",beginrow=0,endrow=0,;name=ds3,sql=\"SELECT class.id,class.name FROM class\",type=normal,param=\"\",beginrow=0,endrow=0,;name=ds4,sql=\"SELECT area.id,area.areaname FROM area\",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="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-2>
	3:4101="1";4306=0;2102="10";2101="68.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="65.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="86.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="88.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="35.0";4202="2";4107=0;4201="1";4106=1
</>
<1-1>
	3:4103="1,1-1,5";4102="多维交叉报表";4406="0";4405="1.0";4403="0";4402="1.0";4304=1;4303="-16777114";4302="14";4412="0";4411="1.0";4201="2";4409="0";4408="1.0"
</>
<1-2>
	1:1
	2:4102
</>
<1-3>
	1:1
</>
<1-4>
	1:1
	2:4201
</>
<1-5>
	1:1
</>
<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="20.0";4202="2";4107=0;4201="1";4106=1
</>
<2-1>
	1:0
	2:4103,4102,4304,4302
	3:4412="-13108";4411="2.0";4410="4"
</>
<2-2>
	1:1
</>
<2-3>
	1:1
</>
<2-4>
	1:1
	2:4201
</>
<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>
	1:0
	2:4405,4411
	3:4103="3,1-4,2";4407="4";4406="-13108";4404="4";4403="-13108";4402="2.0";4401="4";4304=1;4413="-526338";4409="-13108";4408="2.0"
</>
<3-2>
	1:1
	2:4402
</>
<3-3>
	1:1
	3:4103="";4501="2"
	4:4102="ds1.group(area,false)"
</>
<3-4>
	1:1
	2:4501
	3:4502="";4103="3,4-4,4";4102="小计";4503="C3"
</>
<3-5>
	1:1
	2:4502,4503
	3:4103="3,5-4,5";4102="总计";4405="2.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="20.0";4202="2";4107=0;4201="1";4106=1
</>
<4-1>
	1:0
	2:4408
</>
<4-2>
	1:0
	2:4408
</>
<4-3>
	1:0
	2:4102,4103,4408
	3:4503=""
	4:4102="ds1.group(sex,true)"
</>
<4-4>
	1:0
	2:4102,4408
</>
<4-5>
	1:0
	2:4102,4408
</>
<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:4501="1";4104=""
	4:4102="ds2.select(#1)";4105="ds2.select_one(#2,#1=@value)"
</>
<5-2>
	1:1
	2:4102,4105,4402,4104
	3:4502=""
	4:4102="ds3.select(#1)";4105="ds3.select_one(#2,#1=@value)"
</>
<5-3>
	1:0
	2:4102,4501,4304
	3:4502="";4201="3"
	4:4102="ds1.sum(income,dept=A5 && class=B5)"
</>
<5-4>
	1:1
	2:4102
	4:4102="sum(C5[A5:0,B5:0;C3:0]{})"
</>
<5-5>
	1:1
	2:4102,4503
	3:4405="2.0"
	4:4102="sum(C5[A5:0,B5: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.0";4202="2";4107=0;4201="1";4106=1
</>
<6-1>
	1:0
	2:4501,4105,4104
	3:4103="6,1-7,2";4502="A5";4102="小计"
</>
<6-2>
	1:1
	2:4102,4402
</>
<6-3>
	1:0
	2:4102
	4:4102="sum(C5[A5:0;C3:0,C4:0]{})"
</>
<6-4>
	1:0
	2:4102
	4:4102="sum(C5[A5:0;C3:0]{})"
</>
<6-5>
	1:0
	2:4102
	4:4102="sum(C5[A5:0]{})"
</>
<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.0";4202="2";4107=0;4201="1";4106=1
</>
<7-1>
	1:0
	2:4502
	3:4102="总计";4412="0";4411="2.0"
</>
<7-2>
	1:1
	2:4102,4402
</>
<7-3>
	1:0
	2:4102,4502
	3:4412="0";4411="2.0"
	4:4102="sum(C5[;C3:0,C4:0]{})"
</>
<7-4>
	1:1
	2:4102
	4:4102="sum(C5[;C3:0]{})"
</>
<7-5>
	1:1
	2:4102,4503
	3:4405="2.0"
	4:4102="sum(C5{})"
</>