home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 September
/
Dpcb0999.iso
/
Business
/
Empire
/
_SETUP.1
/
SR_SuppTurnover.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 = Supplier.DBF
TableAlias = Supplier
Top = 10
Left = 10
Height = 170
Width = 145
END TABLE
BEGIN FILTER
FieldAlias = ACCREF
TableAlias = Supplier
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 = Supplier
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 = Supplier
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 = Supplier
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 = Supplier
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 = 485
Top = 358
Height = 31
Width = 378
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 = MTOVER1
Left = 498
Top = 363
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 = 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 = 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 = 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 = 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 = 746
Top = 280
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 = Label5
Left = 621
Top = 280
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 = MTOVER Caption
Left = 497
Top = 280
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 = MTOVER
Left = 498
Top = 328
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 = Label10
Left = 398
Top = 364
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 = Label25
Left = 36
Top = 114
Height = 45
Width = 437
Caption = Supplier 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 = Label6
Left = 76
Top = 190
Height = 22
Width = 135
Caption = Start Supplier 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 Supplier 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 = Label9
Left = 146
Top = 328
Height = 22
Width = 343
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 = Label7
Left = 145
Top = 299
Height = 22
Width = 344
Caption = Supplier 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 = Label30
Left = 33
Top = 299
Height = 22
Width = 100
Caption = Supplier 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 = YTOVER1
Left = 622
Top = 363
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 = YTOVER
Left = 622
Top = 328
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 = REP_T_VAL1
Left = 746
Top = 328
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 = REP_T_VAL11
Left = 746
Top = 363
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 = 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 = 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 = 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 = 659
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