📄 季度统计.grf
字号:
Object Report
Version='3.6'
Title='Grid++Report'
Object Font
Name='宋体'
Size=105000,0
Weight=400
Charset=134
End
Object Printer
Size=256
Width=18
Height=20
LeftMargin=0.5
TopMargin=0.5
RightMargin=0.5
BottomMargin=0.5
End
Object DetailGrid
BorderWidth=2
SelectionBackColor=InfoText
LineColor=InfoText
AppendBlankRow=T
Object Recordset
ConnectionString=
driver={SQL Server};server=datacentre2;database=sdf
^~MLT@EOF
QuerySQL=
select a.用户编号,a.姓名, a.本月水电费 as 水电费1 ,a.欠款 as 应缴1, a.本月交费 as 实缴1,a.上月欠费 as 欠费1 ,b.本月水电费 as 水电费2,b.欠款 as 应缴2, b.本月交费 as 实缴2,b.上月欠费 as 欠费2 ,c.本月水电费 as 水电费3,c.欠款 as 应缴3, c.本月交费 as 实缴3,c.上月欠费 as 欠费3
FROM f_sdfcount('0607') a inner join f_sdfcount('0607') b on a.用户编号=b.用户编号
inner join f_sdfcount('0609') c on a.用户编号=c.用户编号
^~MLT@EOF
Items Field
Item
Name='姓名'
End
Item
Name='水电费1'
End
Item
Name='应缴1'
End
Item
Name='实缴1'
End
Item
Name='欠费1'
End
Item
Name='水电费2'
End
Item
Name='应缴2'
End
Item
Name='实缴2'
End
Item
Name='欠费2'
End
Item
Name='水电费3'
End
Item
Name='应缴3'
End
Item
Name='实缴3'
End
Item
Name='欠费3'
End
Item
Name='用户编号'
End
End
End
Items Column
Item
Name='姓名'
Width=1.24354
End
Item
Name='水电费1'
Width=1.2
End
Item
Name='应缴1'
Width=1.2
End
Item
Name='实缴1'
Width=1.2
End
Item
Name='欠费1'
Width=1.2
End
Item
Name='水电费2'
Width=1.2
End
Item
Name='应缴2'
Width=1.2
End
Item
Name='实缴2'
Width=1.2
End
Item
Name='欠费2'
Width=1.2
End
Item
Name='水电费3'
Width=1.2
End
Item
Name='应缴3'
Width=1.2
End
Item
Name='实缴3'
Width=1.2
End
Item
Name='欠费3'
Width=1.2
End
Item
Name='用户编号'
Width=1.13771
End
End
Object ColumnContent
Height=0.608542
Items ColumnContentCell
Item
Column='姓名'
DataField='姓名'
End
Item
Column='水电费1'
TextAlign=MiddleCenter
DataField='水电费1'
End
Item
Column='应缴1'
TextAlign=MiddleCenter
DataField='应缴1'
End
Item
Column='实缴1'
TextAlign=MiddleCenter
DataField='实缴1'
End
Item
Column='欠费1'
TextAlign=MiddleCenter
DataField='欠费1'
End
Item
Column='水电费2'
TextAlign=MiddleCenter
DataField='水电费2'
End
Item
Column='应缴2'
TextAlign=MiddleCenter
DataField='应缴2'
End
Item
Column='实缴2'
TextAlign=MiddleCenter
DataField='实缴2'
End
Item
Column='欠费2'
TextAlign=MiddleCenter
DataField='欠费2'
End
Item
Column='水电费3'
TextAlign=MiddleCenter
DataField='水电费3'
End
Item
Column='应缴3'
TextAlign=MiddleCenter
DataField='应缴3'
End
Item
Column='实缴3'
TextAlign=MiddleCenter
DataField='实缴3'
End
Item
Column='欠费3'
TextAlign=MiddleCenter
DataField='欠费3'
End
Item
Column='用户编号'
TextAlign=MiddleCenter
DataField='用户编号'
End
End
End
Object ColumnTitle
Height=1.19063
RepeatStyle=OnPage
Items ColumnTitleCell
Item
GroupTitle=F
Column='用户编号'
WordWrap=T
TextAlign=MiddleCenter
Text='用户编号'
End
Item
GroupTitle=F
Column='姓名'
TextAlign=MiddleCenter
Text='姓名'
End
Item
GroupTitle=T
Name='y1'
Items ColumnTitleCell
Item
GroupTitle=F
Column='水电费1'
TextAlign=MiddleCenter
Text='水电费'
End
Item
GroupTitle=F
Column='应缴1'
TextAlign=MiddleCenter
Text='应缴'
End
Item
GroupTitle=F
Column='实缴1'
TextAlign=MiddleCenter
Text='实缴'
End
Item
GroupTitle=F
Column='欠费1'
TextAlign=MiddleCenter
Text='欠费'
End
End
FreeCell=T
Items Control
Item
Type=StaticBox
Width=4.73604
Height=0.555625
TextAlign=MiddleCenter
End
Item
Type=StaticBox
Name='m1'
Anchor=[Left|Top|Bottom]
Left=1.8
Top=0.1
Width=1.00542
Height=0.423333
Text='1月'
End
End
End
Item
GroupTitle=T
Name='y2'
Items ColumnTitleCell
Item
GroupTitle=F
Column='水电费2'
TextAlign=MiddleCenter
Text='水电费'
End
Item
GroupTitle=F
Column='应缴2'
TextAlign=MiddleCenter
Text='应缴'
End
Item
GroupTitle=F
Column='实缴2'
TextAlign=MiddleCenter
Text='实缴'
End
Item
GroupTitle=F
Column='欠费2'
TextAlign=MiddleCenter
Text='欠费'
End
End
FreeCell=T
Items Control
Item
Type=StaticBox
Width=4.73604
Height=0.555625
TextAlign=MiddleCenter
End
Item
Type=StaticBox
Name='m2'
Anchor=[Left|Top|Bottom]
Left=1.8
Top=0.1
Width=1.00542
Height=0.423333
Text='2月'
End
End
End
Item
GroupTitle=T
Name='y3'
Items ColumnTitleCell
Item
GroupTitle=F
Column='水电费3'
TextAlign=MiddleCenter
Text='水电费'
End
Item
GroupTitle=F
Column='应缴3'
TextAlign=MiddleCenter
Text='应缴'
End
Item
GroupTitle=F
Column='实缴3'
TextAlign=MiddleCenter
Text='实缴'
End
Item
GroupTitle=F
Column='欠费3'
TextAlign=MiddleCenter
Text='欠费'
End
End
FreeCell=T
Items Control
Item
Type=StaticBox
Width=4.73604
Height=0.555625
TextAlign=MiddleCenter
End
Item
Type=StaticBox
Name='m3'
Anchor=[Left|Top|Bottom]
Left=1.79917
Top=0.1
Width=1.00542
Height=0.423333
Text='3月'
End
End
End
End
End
End
Items Section
Item
Type=ReportHeader
Name='ReportHeader1'
Height=1.32292
Items Control
Item
Type=StaticBox
Name='title'
Object Font
Name='宋体'
Size=142500,0
Weight=400
Charset=134
End
Center=Both
Left=5.90021
Top=0.370417
Width=5.15938
Height=0.555625
Text='第 季度水电费统计'
End
Item
Type=SystemVarBox
Name='SystemVarBox1'
AlignColumnSide=Left
AlignColumn='欠费3'
Left=15.4781
Top=0.79375
Width=0.79375
Height=0.582083
TextAlign=MiddleCenter
End
Item
Type=SystemVarBox
Name='SystemVarBox2'
AlignColumnSide=Left
AlignColumn='应缴3'
Left=13.0969
Top=0.79375
Width=0.608542
Height=0.582083
TextAlign=MiddleCenter
SystemVar=PageCount
End
Item
Type=StaticBox
Name='StaticBox1'
AlignColumnSide=Right
AlignColumn='实缴3'
Left=14.9754
Top=0.79375
Width=0.502708
Height=0.582083
Text='第'
End
Item
Type=StaticBox
Name='StaticBox2'
AlignColumnSide=Right
AlignColumn='水电费3'
Left=12.7
Top=0.79375
Width=0.396875
Height=0.582083
Text='共'
End
Item
Type=StaticBox
Name='StaticBox3'
AlignColumnSide=Right
AlignColumn='欠费3'
Left=16.2719
Top=0.79375
Width=0.396875
Height=0.582083
Text='页'
End
Item
Type=StaticBox
Name='StaticBox4'
AlignColumnSide=Right
AlignColumn='应缴3'
Left=13.8906
Top=0.79375
Width=0.396875
Height=0.582083
Text='页'
End
End
RepeatOnPage=T
End
End
End
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -