📄 同期比报表.raq
字号:
version=1.0
9,11
<0-0>
3:1105="";1208="25";1207="25";1102="name=ds1,sql=\"SELECT sub_capital.years, sub_capital.monthes, sub_capital.item, sub_capital.amount from sub_capital\",type=normal,param=\"\",beginrow=0,endrow=2147483647,;name=ds3,sql=\"SELECT capital.years, capital.monthes, capital.item, capital.amount from capital\",type=normal,param=\"\",beginrow=0,endrow=2147483647,;name=ds2,sql=\"SELECT item.type, item.id, item.name from item\",type=normal,param=\"\",beginrow=0,endrow=2147483647,;";1101="2";1206="25";1205="25";1202="2";1201="4"
</>
<0-1>
3:4101="1";4306=0;2102="10";4305=0;2101="152.0";4304=0;4303="0";4302="12";4301="宋体";4413="-1";4203="0";4202="2";4201="1";4106=1
</>
<0-2>
3:4101="1";4306=0;2102="10";4305=0;2101="104.0";4304=0;4303="0";4302="12";4301="宋体";4413="-1";4203="0";4202="2";4201="1";4106=1
</>
<0-3>
3:4101="1";4306=0;2102="10";4305=0;2101="78.0";4304=0;4303="0";4302="12";4301="宋体";4413="-1";4203="0";4202="2";4201="1";4106=1
</>
<0-4>
3:4101="1";4306=0;2102="10";4305=0;2101="70.0";4304=0;4303="0";4302="12";4301="宋体";4413="-1";4203="0";4202="2";4201="1";4106=1
</>
<0-5>
3:4101="1";4306=0;2102="10";4305=0;2101="82.0";4304=0;4303="0";4302="12";4301="宋体";4413="-1";4203="0";4202="2";4201="1";4106=1
</>
<0-6>
3:4101="1";4306=0;2102="10";4305=0;2101="72.0";4304=0;4303="0";4302="12";4301="宋体";4413="-1";4203="0";4202="2";4201="1";4106=1
</>
<0-7>
3:4101="1";4306=0;2102="10";4305=0;2101="69.0";4304=0;4303="0";4302="12";4301="宋体";4413="-1";4203="0";4202="2";4201="1";4106=1
</>
<0-8>
3:4101="1";4306=0;2102="10";4305=0;2101="73.0";4304=0;4303="0";4302="12";4301="宋体";4413="-1";4203="0";4202="2";4201="1";4106=1
</>
<0-9>
3:4101="1";4306=0;2102="10";4305=0;2101="72.0";4304=0;4303="0";4302="12";4301="宋体";4413="-1";4203="0";4202="2";4201="1";4106=1
</>
<0-10>
3:4101="1";4306=0;2102="10";4305=0;2101="68.0";4304=0;4303="0";4302="12";4301="宋体";4413="-1";4203="0";4202="2";4201="1";4106=1
</>
<1-0>
3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";4203="0";3101="20.0";4202="2";4201="1";4106=1
</>
<1-1>
3:1101="3";4201="2"
</>
<1-2>
1:1
</>
<1-3>
1:1
</>
<1-4>
1:1
</>
<1-5>
1:1
</>
<1-6>
1:1
</>
<1-7>
1:1
</>
<1-8>
1:1
</>
<1-9>
1:1
2:1101
</>
<1-10>
1:1
3:1101="3"
</>
<2-0>
3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";4203="0";3101="46.0";4202="2";4201="1";4106=1
</>
<2-1>
1:0
3:4304=1;4303="-16777216";4302="14";4103="2,1-2,10";4102="复杂报表"
</>
<2-2>
1:1
2:4102
</>
<2-3>
1:1
</>
<2-4>
1:1
</>
<2-5>
1:1
</>
<2-6>
1:1
</>
<2-7>
1:1
</>
<2-8>
1:1
</>
<2-9>
1:1
2:1101
</>
<2-10>
1:1
3:1101="3"
</>
<3-0>
3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";4203="0";3101="20.0";4202="2";4201="1";4106=1
</>
<3-1>
1:0
2:4304,4303,4302,4103,4102
3:4411="1.5";4410="4"
</>
<3-2>
1:1
</>
<3-3>
1:1
</>
<3-4>
1:1
</>
<3-5>
1:1
</>
<3-6>
1:1
</>
<3-7>
1:1
</>
<3-8>
1:1
</>
<3-9>
1:1
2:1101
</>
<3-10>
1:1
3:1101="3"
</>
<4-0>
3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";4203="0";3101="20.0";4202="2";4201="1";4106=1
</>
<4-1>
1:0
3:4303="-16777216";4408="1.5";4407="4";4405="1.0";4404="4";4103="4,1-5,1";4102="项目";4402="1.5";4401="4";4411="1.0"
</>
<4-2>
1:1
3:4103="4,2-5,2";4102="本期实绩";4402="1.0"
</>
<4-3>
1:1
3:4103="4,3-4,4";4102="比上期增减"
</>
<4-4>
1:1
2:4102
</>
<4-5>
1:1
3:4103="4,5-4,6";4102="比上年同期增减"
</>
<4-6>
1:1
2:4102
</>
<4-7>
1:1
3:4103="4,7-4,8";4102="当期全行与上期比较"
</>
<4-8>
1:1
2:4102
</>
<4-9>
1:1
2:1101
3:4103="4,9-4,10";4102="当期全行与上年同期比较"
</>
<4-10>
1:1
2:4102
3:4405="1.5";1101="3"
</>
<5-0>
3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";4203="0";3101="20.0";4202="2";4201="1";4106=1
</>
<5-1>
1:0
2:4102
3:4408="1.0";4411="1.5"
</>
<5-2>
1:0
2:4102
3:4408="1.0";4411="1.5"
</>
<5-3>
1:1
2:4103
3:4102="增减量"
</>
<5-4>
1:1
3:4102="增减幅"
</>
<5-5>
1:1
3:4102="增减量"
</>
<5-6>
1:1
3:4102="增减幅"
</>
<5-7>
1:1
3:4102="实绩"
</>
<5-8>
1:1
3:4102="差异"
</>
<5-9>
1:1
2:1101
3:4102="实绩"
</>
<5-10>
1:0
2:4103
3:4408="1.0";4102="差异";4411="1.5"
</>
<6-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="1.0";4202="2";4107=0;4201="1";4106=0
</>
<6-1>
1:0
2:4405,4404,4103,1101,4201
3:4408="1.5";4203="4";4411="1.0"
</>
<6-2>
1:1
2:4402,4401
</>
<6-3>
1:1
</>
<6-4>
1:1
</>
<6-5>
1:1
</>
<6-6>
1:1
</>
<6-7>
1:1
</>
<6-8>
1:1
</>
<6-9>
1:1
</>
<6-10>
1:1
3:4405="1.5";4404="4"
</>
<7-0>
3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";4203="0";3101="20.0";4202="2";4201="1";4106=1
</>
<7-1>
1:0
2:4203
3:1101="3";4501="1";4405="1.0";4404="4";4305=1;4304=1;4408="1.0"
4:4102="ds2.group(type,true)"
</>
<7-2>
1:1
2:4102,4501,4305,4304
3:4402="1.0";4201="3";4104="#,##0.00"
4:4102="sum(B8[A7:0]{})"
</>
<7-3>
1:1
2:4102
4:4102="sum(C8[A7:0]{})"
</>
<7-4>
1:1
2:4102
4:4102="C7/B7"
</>
<7-5>
1:1
2:4102
4:4102="sum(E8[A7:0]{})"
</>
<7-6>
1:1
2:4102
4:4102="E7/B7"
</>
<7-7>
1:1
2:4102
4:4102="sum(G8[A7:0]{})"
</>
<7-8>
1:1
2:4102
4:4102="sum(H8[A7:0]{})"
</>
<7-9>
1:1
2:4102,1101
4:4102="sum(I8[A7:0]{})"
</>
<7-10>
1:1
2:4102
3:4405="1.5";1101="3"
4:4102="sum(J8[A7:0]{})"
</>
<8-0>
3:4101="1";4306=0;4305=0;4304=0;4303="0";4302="12";4301="宋体";3103="10";4413="-1";4203="0";3101="20.0";4202="2";4201="1";4106=1
</>
<8-1>
1:0
2:4102,4304
3:4502="A7";4411="1.5";4201="3"
4:4102="ds2.group(id,true)";4105="ds2.select_one(name, id==value)"
</>
<8-2>
1:0
2:4102
3:4411="1.5"
4:4102="ds1.sum(amount,years==2000 && monthes==8 && item==A8)"
</>
<8-3>
1:1
2:4102
4:4102="B8-ds1.sum(amount,years==2000 && monthes==7 && item==A8)"
</>
<8-4>
1:1
2:4102
4:4102="C8/B8"
</>
<8-5>
1:1
2:4102
4:4102="B8-ds1.sum(amount,years==1999 && monthes==8 && item==A8)"
</>
<8-6>
1:1
2:4102
4:4102="E8/B8"
</>
<8-7>
1:1
2:4102
4:4102="ds3.sum(amount,years==2000 && monthes==8 && item==A8)"
</>
<8-8>
1:1
2:4102
4:4102="G8-ds3.sum(amount,years==2000 && monthes==7 && item==A8)"
</>
<8-9>
1:1
2:4102,1101
4:4102="ds3.sum(amount,years==2000 && monthes==8 && item==A8)"
</>
<8-10>
1:0
2:4102
3:4411="1.5"
4:4102="I8-ds3.sum(amount,years==1999 && monthes==8 && item==A8)"
</>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -