home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 September
/
Dpcb0999.iso
/
Business
/
Empire
/
_SETUP.1
/
SR_CustTurnover.SRW
< prev
next >
Wrap
Text File
|
1999-04-07
|
15KB
|
883 lines
<SHAZAM REPORT WIZARD>
BEGIN REPORT
FileVersion = 3.50
ProductVersion = 3.50
ProductRevision = M
Password =
PixelsPerInch = 120
Distinct = 0
Count = 6
DateFormat = 1
DateSeparator = /
DecimalSeparator = .
DataModel = 0
END REPORT
BEGIN PAGE
PaperType = 1
PaperHeight = 11.00
PaperWidth = 8.50
PaperOrientation = 0
MarginTop = 0.20
MarginBottom = 0.20
MarginRight = 0.20
MarginLeft = 0.20
LabelsActive = 0
LabelsAcross = 0
LabelsDown = 0
LabelsGapHorz = 0.000
LabelsGapVert = 0.000
LabelsHeight = 0.000
LabelsWidth = 0.000
END PAGE
BEGIN TITLE
Caption = Report
FontName = Arial
FontSize = 24
FontColor = clBlack
FontBold = 1
FontItalic = 1
FontUnderline = 0
FontStrikeOut = 0
END TITLE
BEGIN SUBTITLE
Caption =
FontName = Arial
FontSize = 14
FontColor = clBlack
FontBold = 1
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END SUBTITLE
BEGIN FOOTER
Caption =
FontName = Arial
FontSize = 10
FontColor = clBlack
FontBold = 1
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END FOOTER
BEGIN RECORD
FontName = Arial
FontSize = 10
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END RECORD
BEGIN TABLE
DatabaseName = EmpireBuilder
TableName = Customer.DBF
TableAlias = Customer
Top = 6
Left = 6
Height = 182
Width = 139
END TABLE
BEGIN FILTER
FieldAlias = ACCREF
TableAlias = Customer
FieldExpr = ACCREF
Show = 0
Sort = 1
FilterDisplay1 =
FilterDisplay2 =
FilterDisplay3 =
FilterDisplay4 =
FilterDisplay5 =
FieldName = ACCREF
DataType = 1
Width = 10
FilterValues1 =
FilterValues2 =
FilterValues3 =
FilterValues4 =
FilterValues5 =
Alignment = 0
Format =
END FILTER
BEGIN FILTER
FieldAlias = NAME
TableAlias = Customer
FieldExpr = NAME
Show = 0
Sort = 0
FilterDisplay1 =
FilterDisplay2 =
FilterDisplay3 =
FilterDisplay4 =
FilterDisplay5 =
FieldName = NAME
DataType = 1
Width = 40
FilterValues1 =
FilterValues2 =
FilterValues3 =
FilterValues4 =
FilterValues5 =
Alignment = 0
Format =
END FILTER
BEGIN FILTER
FieldAlias = MTOVER
TableAlias = Customer
FieldExpr = MTOVER
Show = 0
Sort = 0
FilterDisplay1 =
FilterDisplay2 =
FilterDisplay3 =
FilterDisplay4 =
FilterDisplay5 =
FieldName = MTOVER
DataType = 6
Width = 10
FilterValues1 =
FilterValues2 =
FilterValues3 =
FilterValues4 =
FilterValues5 =
Alignment = 2
Format = 0.00
END FILTER
BEGIN FILTER
FieldAlias = YTOVER
TableAlias = Customer
FieldExpr = YTOVER
Show = 0
Sort = 0
FilterDisplay1 =
FilterDisplay2 =
FilterDisplay3 =
FilterDisplay4 =
FilterDisplay5 =
FieldName = YTOVER
DataType = 6
Width = 10
FilterValues1 =
FilterValues2 =
FilterValues3 =
FilterValues4 =
FilterValues5 =
Alignment = 2
Format = 0.00
END FILTER
BEGIN FILTER
FieldAlias = REP_T_VAL1
TableAlias = Customer
FieldExpr = REP_T_VAL1
Show = 0
Sort = 0
FilterDisplay1 =
FilterDisplay2 =
FilterDisplay3 =
FilterDisplay4 =
FilterDisplay5 =
FieldName = REP_T_VAL1
DataType = 6
Width = 10
FilterValues1 =
FilterValues2 =
FilterValues3 =
FilterValues4 =
FilterValues5 =
Alignment = 2
Format = 0.00
END FILTER
BEGIN SECTION
Index = 2
Type = 1
Mode = 0
Field =
Height = 299
KeepGroup = 0
NewPage = 0
NewPageNo = 0
PrintSection = 1
END SECTION
BEGIN SECTION
Index = 13
Type = 3
Mode = 0
Field =
Height = 29
KeepGroup = 0
NewPage = 0
NewPageNo = 0
PrintSection = 1
END SECTION
BEGIN SECTION
Index = 28
Type = 0
Mode = 1
Field =
Height = 49
KeepGroup = 0
NewPage = 0
NewPageNo = 0
PrintSection = 1
END SECTION
BEGIN SHAPE
Type = 3
Name = Rectangle1
Left = 492
Top = 357
Height = 31
Width = 375
BrushColor = clWhite
BrushStyle = 1
PenColor = clBlack
PenMode = 4
PenStyle = 0
PenWidth = 1
END SHAPE
BEGIN LABEL
Type = 0
Name = Time
Left = 869
Top = 94
Height = 22
Width = 100
Caption = @Time
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 10
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label3
Left = 770
Top = 68
Height = 22
Width = 91
Caption = Date
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 10
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label1
Left = 33
Top = 327
Height = 22
Width = 100
Caption = [ACCREF]
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 8
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label25
Left = 36
Top = 114
Height = 45
Width = 437
Caption = Customer Turnover Report
Alignment = 0
Color = clBlue
Transparent = 1
FontName = Arial
FontSize = 20
FontColor = clWhite
FontBold = 1
FontItalic = 1
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = ABOVE
Left = 770
Top = 217
Height = 22
Width = 86
Caption =
Alignment = 1
Color = clWhite
Transparent = 1
FontName = MS Sans Serif
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label7
Left = 145
Top = 279
Height = 41
Width = 112
Caption = Customer Name
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 1
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = TOStartDate
Left = 371
Top = 217
Height = 22
Width = 110
Caption =
Alignment = 0
Color = clWhite
Transparent = 1
FontName = MS Sans Serif
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = PageNo
Left = 869
Top = 41
Height = 22
Width = 81
Caption = @PageNo
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 10
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label2
Left = 770
Top = 42
Height = 22
Width = 91
Caption = Page No.
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 10
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = INCLUDE
Left = 622
Top = 217
Height = 22
Width = 135
Caption =
Alignment = 0
Color = clWhite
Transparent = 1
FontName = MS Sans Serif
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = TOFinDate
Left = 497
Top = 217
Height = 22
Width = 110
Caption =
Alignment = 0
Color = clWhite
Transparent = 1
FontName = MS Sans Serif
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = FinCustRef
Left = 223
Top = 217
Height = 22
Width = 135
Caption =
Alignment = 0
Color = clWhite
Transparent = 1
FontName = MS Sans Serif
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = StartCustRef
Left = 76
Top = 216
Height = 22
Width = 135
Caption =
Alignment = 0
Color = clWhite
Transparent = 1
FontName = MS Sans Serif
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label6
Left = 76
Top = 190
Height = 22
Width = 135
Caption = Start Customer Ref.
Alignment = 0
Color = clWhite
Transparent = 1
FontName = MS Sans Serif
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 1
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label8
Left = 223
Top = 191
Height = 22
Width = 135
Caption = Finish Customer Ref.
Alignment = 0
Color = clWhite
Transparent = 1
FontName = MS Sans Serif
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 1
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label11
Left = 372
Top = 191
Height = 22
Width = 110
Caption = T/O Start Date
Alignment = 0
Color = clWhite
Transparent = 1
FontName = MS Sans Serif
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 1
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label12
Left = 497
Top = 191
Height = 22
Width = 110
Caption = T/O Finish Date
Alignment = 0
Color = clWhite
Transparent = 1
FontName = MS Sans Serif
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 1
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label24
Left = 622
Top = 191
Height = 22
Width = 135
Caption = Include ...
Alignment = 0
Color = clWhite
Transparent = 1
FontName = MS Sans Serif
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 1
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = AboveLabel
Left = 770
Top = 191
Height = 22
Width = 86
Caption = Above
Alignment = 1
Color = clWhite
Transparent = 1
FontName = MS Sans Serif
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 1
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label30
Left = 32
Top = 279
Height = 41
Width = 100
Caption = Customer Ref.
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 1
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label4
Left = 771
Top = 94
Height = 22
Width = 89
Caption = Time
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 10
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = PeriodTOLabel
Left = 750
Top = 278
Height = 41
Width = 110
Caption = Period Turnover
Alignment = 1
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 1
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = REP_T_VAL1
Left = 750
Top = 326
Height = 22
Width = 110
Caption = [REP_T_VAL1]
Alignment = 1
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label5
Left = 627
Top = 278
Height = 41
Width = 110
Caption = Turnover This Year
Alignment = 1
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 1
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = YTOVER
Left = 627
Top = 326
Height = 22
Width = 110
Caption = [YTOVER]
Alignment = 1
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = MTOVER
Left = 502
Top = 326
Height = 22
Width = 110
Caption = [MTOVER]
Alignment = 1
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = YTOVER1
Left = 627
Top = 361
Height = 22
Width = 110
Caption = @Sum([YTOVER])
Alignment = 1
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = MTOVER1
Left = 502
Top = 361
Height = 22
Width = 110
Caption = @Sum([MTOVER])
Alignment = 1
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = MTOVER Caption
Left = 502
Top = 278
Height = 41
Width = 110
Caption = Turnover This Month
Alignment = 1
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 1
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label9
Left = 147
Top = 326
Height = 22
Width = 337
Caption = [NAME]
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 8
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = Label10
Left = 400
Top = 360
Height = 22
Width = 82
Caption = Totals
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 1
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = REP_T_VAL11
Left = 750
Top = 361
Height = 22
Width = 110
Caption = @Sum([REP_T_VAL1])
Alignment = 1
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = SysDate
Left = 869
Top = 68
Height = 22
Width = 100
Caption =
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 10
FontColor = clBlack
FontBold = 0
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL
BEGIN LABEL
Type = 0
Name = CompName
Left = 36
Top = 38
Height = 32
Width = 656
Caption = Company Name
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 14
FontColor = clBlack
FontBold = 1
FontItalic = 0
FontUnderline = 1
FontStrikeOut = 0
END LABEL