📄 xykrep.dfm
字号:
44.9791666666667
402.166666666667
0
161.395833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
DataSet = ADOQuery1
DataField = #20184#27454#32534#30721
Transparent = False
WordWrap = True
FontSize = 11
end
object QRDBSalesDate: TQRDBText
Left = 240
Top = 0
Width = 61
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
635
0
161.395833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
DataSet = ADOQuery1
DataField = #21345#31867#21517#31216
Transparent = False
WordWrap = True
FontSize = 11
end
end
object QRGroupCust: TQRGroup
Left = 48
Top = 140
Width = 592
Height = 5
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
AlignToBottom = False
Color = clWhite
ForceNewColumn = False
ForceNewPage = False
Size.Values = (
13.2291666666667
1566.33333333333)
Expression = 'qryCustomer.CustNo'
Master = QuickRep2
ReprintOnNewPage = True
end
object GroupFooterBand1: TQRBand
Left = 48
Top = 201
Width = 592
Height = 5
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
AlignToBottom = False
Color = clWhite
ForceNewColumn = False
ForceNewPage = False
Size.Values = (
13.2291666666667
1566.33333333333)
BandType = rbGroupFooter
end
object QRLabel15: TQRLabel
Left = 64
Top = 94
Width = 46
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
169.333333333333
248.708333333333
121.708333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = #26085#26399#65306
Color = clWhite
Transparent = False
WordWrap = True
FontSize = 11
end
object ColumnHeaderBand2: TQRBand
Left = 48
Top = 113
Width = 592
Height = 27
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
AlignToBottom = False
Color = clWhite
ForceNewColumn = False
ForceNewPage = False
Size.Values = (
71.4375
1566.33333333333)
BandType = rbColumnHeader
object QRLabel17: TQRLabel
Left = 72
Top = 6
Width = 71
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
190.5
15.875
187.854166666667)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = #24215' '#21517
Color = clWhite
Transparent = False
WordWrap = True
FontSize = 11
end
object QRLabel18: TQRLabel
Left = 16
Top = 6
Width = 31
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
42.3333333333333
15.875
82.0208333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = #24207#21495
Color = clWhite
Transparent = False
WordWrap = True
FontSize = 11
end
object QRLabel19: TQRLabel
Left = 168
Top = 6
Width = 61
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
444.5
15.875
161.395833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = #20132#26131#25968#37327
Color = clWhite
Transparent = False
WordWrap = True
FontSize = 11
end
object QRLabel20: TQRLabel
Left = 272
Top = 6
Width = 61
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
719.666666666667
15.875
161.395833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = #20132#26131#37329#39069
Color = clWhite
Transparent = False
WordWrap = True
FontSize = 11
end
object QRShape4: TQRShape
Left = 0
Top = 1
Width = 610
Height = 2
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
5.29166666666667
0
2.64583333333333
1613.95833333333)
Shape = qrsRectangle
end
object QRShape5: TQRShape
Left = 0
Top = 24
Width = 610
Height = 2
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
5.29166666666667
0
63.5
1613.95833333333)
Shape = qrsRectangle
end
end
object SummaryBand2: TQRBand
Left = 48
Top = 206
Width = 592
Height = 31
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
AlignToBottom = False
Color = clWhite
ForceNewColumn = False
ForceNewPage = False
Size.Values = (
82.0208333333333
1566.33333333333)
BandType = rbSummary
object QRExpr1: TQRExpr
Left = 120
Top = 8
Width = 105
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
317.5
21.1666666666667
277.8125)
Alignment = taRightJustify
AlignToBand = False
AutoSize = False
AutoStretch = False
Color = clWhite
ResetAfterPrint = False
Transparent = False
WordWrap = True
Expression = 'SUM(ADOQuery2.'#20132#26131#25968')'
FontSize = 11
end
object QRLabel13: TQRLabel
Left = 40
Top = 8
Width = 34
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
105.833333333333
21.1666666666667
89.9583333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = #24635#35745
Color = clWhite
Font.Charset = GB2312_CHARSET
Font.Color = clWindowText
Font.Height = -15
Font.Name = #23435#20307
Font.Style = [fsBold]
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 11
end
object QRExpr2: TQRExpr
Left = 240
Top = 8
Width = 105
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
635
21.1666666666667
277.8125)
Alignment = taRightJustify
AlignToBand = False
AutoSize = False
AutoStretch = False
Color = clWhite
ResetAfterPrint = False
Transparent = False
WordWrap = True
Expression = 'SUM(ADOQuery2.'#20132#26131#37329#39069')'
FontSize = 11
end
object QRShape6: TQRShape
Left = 0
Top = 1
Width = 610
Height = 2
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
5.29166666666667
0
2.64583333333333
1613.95833333333)
Shape = qrsRectangle
end
end
end
end
object DataSource1: TDataSource
DataSet = ADOQuery1
Left = 384
Top = 96
end
object ADOQuery1: TADOQuery
Connection = mainForm.RJSADO
CursorType = ctStatic
Parameters = <
item
Name = 'cs1'
Attributes = [paNullable]
DataType = ftDateTime
Precision = 16
Size = 16
Value = Null
end
item
Name = 'cs2'
Attributes = [paNullable]
DataType = ftDateTime
Precision = 16
Size = 16
Value = Null
end>
SQL.Strings = (
'select szdd as '#24215#21517',fkfsbm as '#20184#27454#32534#30721', fkfsmc as '#21345#31867#21517#31216', count(distinct' +
' djh) as '#20132#26131#25968', sum(fkje) as '#20132#26131#37329#39069' '
'from fkwj'
'where left(fkfsbm,1)='#39'1'#39' and rq>=:cs1 and rq<=:cs2'
'group by szdd, fkfsbm,fkfsmc'
'order by szdd,'#20132#26131#37329#39069' desc')
Left = 424
Top = 96
object ADOQuery1DSDesigner: TStringField
DisplayWidth = 31
FieldName = #24215#21517
Size = 50
end
object ADOQuery1DSDesigner2: TStringField
DisplayWidth = 10
FieldName = #20184#27454#32534#30721
Size = 10
end
object ADOQuery1DSDesigner3: TStringField
DisplayWidth = 40
FieldName = #21345#31867#21517#31216
Size = 50
end
object ADOQuery1DSDesigner5: TBCDField
DisplayWidth = 20
FieldName = #20132#26131#37329#39069
ReadOnly = True
Precision = 19
end
object ADOQuery1DSDesigner4: TIntegerField
FieldName = #20132#26131#25968
ReadOnly = True
end
end
object ADOQuery2: TADOQuery
Connection = mainForm.RJSADO
CursorType = ctStatic
Parameters = <
item
Name = 'cs1'
Attributes = [paNullable]
DataType = ftDateTime
Precision = 16
Size = 16
Value = Null
end
item
Name = 'cs2'
Attributes = [paNullable]
DataType = ftDateTime
Precision = 16
Size = 16
Value = Null
end>
SQL.Strings = (
'select szdd as '#24215#21517',count(distinct djh) as '#20132#26131#25968', sum(fkje) as '#20132#26131#37329#39069' '
'from fkwj'
'where left(fkfsbm,1)='#39'1'#39' and rq>=:cs1 and rq<=:cs2'
'group by szdd'
'order by '#20132#26131#37329#39069' desc')
Left = 248
Top = 64
object ADOQuery2DSDesigner: TStringField
FieldName = #24215#21517
Size = 50
end
object ADOQuery2DSDesigner3: TBCDField
FieldName = #20132#26131#37329#39069
ReadOnly = True
Precision = 19
end
object ADOQuery2DSDesigner2: TIntegerField
FieldName = #20132#26131#25968
ReadOnly = True
end
end
end
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -