home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 September
/
Dpcb0999.iso
/
Business
/
Empire
/
_SETUP.1
/
SR_CustECList.SRW
< prev
next >
Wrap
Text File
|
1999-04-02
|
13KB
|
715 lines
<SHAZAM REPORT WIZARD>
BEGIN REPORT
FileVersion = 3.50
ProductVersion = 3.50
ProductRevision = M
Password =
PixelsPerInch = 120
Distinct = 0
Count = 7
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 = 10
Left = 10
Height = 173
Width = 138
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 = VATID
TableAlias = Customer
FieldExpr = VATID
Show = 0
Sort = 0
FilterDisplay1 =
FilterDisplay2 =
FilterDisplay3 =
FilterDisplay4 =
FilterDisplay5 =
FieldName = VATID
DataType = 1
Width = 15
FilterValues1 =
FilterValues2 =
FilterValues3 =
FilterValues4 =
FilterValues5 =
Alignment = 0
Format =
END FILTER
BEGIN FILTER
FieldAlias = VATCODE
TableAlias = Customer
FieldExpr = VATCODE
Show = 0
Sort = 0
FilterDisplay1 =
FilterDisplay2 =
FilterDisplay3 =
FilterDisplay4 =
FilterDisplay5 =
FieldName = VATCODE
DataType = 1
Width = 7
FilterValues1 =
FilterValues2 =
FilterValues3 =
FilterValues4 =
FilterValues5 =
Alignment = 0
Format =
END FILTER
BEGIN FILTER
FieldAlias = REP_T_VAL1
TableAlias = Customer
FieldExpr = REP_T_VAL1
Show = 0
Sort = 0
FilterDisplay1 = Not Equals 0
FilterDisplay2 =
FilterDisplay3 =
FilterDisplay4 =
FilterDisplay5 =
FieldName = REP_T_VAL1
DataType = 6
Width = 10
FilterValues1 = 0|7|0|||||
FilterValues2 =
FilterValues3 =
FilterValues4 =
FilterValues5 =
Alignment = 2
Format = 0.00
END FILTER
BEGIN FILTER
FieldAlias = ECCODE
TableAlias = Customer
FieldExpr = ECCODE
Show = 0
Sort = 0
FilterDisplay1 = Not Equals BLANK
FilterDisplay2 =
FilterDisplay3 =
FilterDisplay4 =
FilterDisplay5 =
FieldName = ECCODE
DataType = 1
Width = 6
FilterValues1 = 0|7|BLANK|||||
FilterValues2 =
FilterValues3 =
FilterValues4 =
FilterValues5 =
Alignment = 0
Format =
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 = 28
KeepGroup = 0
NewPage = 0
NewPageNo = 0
PrintSection = 1
END SECTION
BEGIN SECTION
Index = 28
Type = 0
Mode = 1
Field =
Height = 41
KeepGroup = 0
NewPage = 0
NewPageNo = 0
PrintSection = 1
END SECTION
BEGIN SHAPE
Type = 3
Name = Rectangle1
Left = 750
Top = 360
Height = 28
Width = 120
BrushColor = clWhite
BrushStyle = 1
PenColor = clBlack
PenMode = 4
PenStyle = 0
PenWidth = 1
END SHAPE
BEGIN LABEL
Type = 0
Name = Time
Left = 871
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 = Label25
Left = 37
Top = 115
Height = 45
Width = 296
Caption = VAT EC Sales List
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 = Label2
Left = 772
Top = 41
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 = PageNo
Left = 871
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 = Label3
Left = 772
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 = Label4
Left = 773
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 = CompName
Left = 37
Top = 38
Height = 32
Width = 643
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
BEGIN LABEL
Type = 0
Name = SysDate
Left = 871
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 = Label8
Left = 210
Top = 190
Height = 22
Width = 107
Caption = 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 = FinDate
Left = 210
Top = 216
Height = 22
Width = 107
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 = 85
Top = 191
Height = 22
Width = 109
Caption = 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 = StartDate
Left = 86
Top = 217
Height = 22
Width = 108
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 = REP_T_VAL11
Left = 755
Top = 363
Height = 22
Width = 110
Caption = @Sum([REP_T_VAL1])
Alignment = 1
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 = Label1
Left = 37
Top = 326
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 = ECCODE
Left = 502
Top = 326
Height = 22
Width = 55
Caption = [ECCODE]
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 = VATID
Left = 575
Top = 326
Height = 22
Width = 162
Caption = [VATID]
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 = REP_T_VAL1
Left = 755
Top = 326
Height = 22
Width = 110
Caption = [REP_T_VAL1]
Alignment = 1
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 = TELNO Caption
Left = 502
Top = 279
Height = 41
Width = 55
Caption = EC Code
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 = 37
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 = CONTACT Caption
Left = 754
Top = 298
Height = 22
Width = 110
Caption = Total Net Sales
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 = 150
Top = 326
Height = 22
Width = 342
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 = 150
Top = 298
Height = 22
Width = 342
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 = FAXNO Caption
Left = 575
Top = 298
Height = 22
Width = 162
Caption = VAT Reg. No.
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 = Label5
Left = 687
Top = 363
Height = 22
Width = 50
Caption = Total
Alignment = 0
Color = clWhite
Transparent = 1
FontName = Arial
FontSize = 9
FontColor = clBlack
FontBold = 1
FontItalic = 0
FontUnderline = 0
FontStrikeOut = 0
END LABEL