Computer Buyer 1999 September/Dpcb0999.iso/Business/Empire/_SETUP.1/sr_stkcheck2.srw

Text File | 1999-04-07 | 17KB | 984 lines

<SHAZAM REPORT WIZARD>
BEGIN REPORT
  FileVersion = 3.50
  ProductVersion = 3.50
  ProductRevision = M
  Password =
  PixelsPerInch = 120
  Distinct = 0
  Count = 12
  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 = Stock.DBF
  TableAlias = Stock
  Top = 2
  Left = 134
  Height = 132
  Width = 155
END TABLE
BEGIN TABLE
  DatabaseName = EmpireBuilder
  TableName = StkCats.DBF
  TableAlias = StkCats
  Top = 3
  Left = 0
  Height = 100
  Width = 113
END TABLE
BEGIN JOIN
  LeftTable = Stock
  LeftField = PRODGROUP
  JoinOperator = 0
  RightTable = StkCats
  RightField = PRODCODE
  JoinType = 0
END JOIN
BEGIN FILTER
  FieldAlias = PRODCODE
  TableAlias = StkCats
  FieldExpr = PRODCODE
  Show = 0
  Sort = 1
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = PRODCODE
  DataType = 1
  Width = 10
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 0
  Format =
END FILTER
BEGIN FILTER
  FieldAlias = STOCKCODE
  TableAlias = Stock
  FieldExpr = STOCKCODE
  Show = 0
  Sort = 1
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = STOCKCODE
  DataType = 1
  Width = 16
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 0
  Format =
END FILTER
BEGIN FILTER
  FieldAlias = DESC
  TableAlias = Stock
  FieldExpr = DESC
  Show = 0
  Sort = 0
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = DESC
  DataType = 1
  Width = 40
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 0
  Format =
END FILTER
BEGIN FILTER
  FieldAlias = REORDLEV
  TableAlias = Stock
  FieldExpr = REORDLEV
  Show = 0
  Sort = 0
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = REORDLEV
  DataType = 6
  Width = 10
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 2
  Format =
END FILTER
BEGIN FILTER
  FieldAlias = REORDQUAN
  TableAlias = Stock
  FieldExpr = REORDQUAN
  Show = 0
  Sort = 0
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = REORDQUAN
  DataType = 6
  Width = 10
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 2
  Format =
END FILTER
BEGIN FILTER
  FieldAlias = LOCATION
  TableAlias = Stock
  FieldExpr = LOCATION
  Show = 0
  Sort = 0
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = LOCATION
  DataType = 1
  Width = 15
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 0
  Format =
END FILTER
BEGIN FILTER
  FieldAlias = INSTOCK
  TableAlias = Stock
  FieldExpr = INSTOCK
  Show = 0
  Sort = 0
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = INSTOCK
  DataType = 6
  Width = 10
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 2
  Format =
END FILTER
BEGIN FILTER
  FieldAlias = ONORDER
  TableAlias = Stock
  FieldExpr = ONORDER
  Show = 0
  Sort = 0
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = ONORDER
  DataType = 6
  Width = 10
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 2
  Format =
END FILTER
BEGIN FILTER
  FieldAlias = PGDESC
  TableAlias =
  FieldExpr = (StkCats."DESC")
  Show = 0
  Sort = 0
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = (StkCats."DESC")
  DataType = 0
  Width = 10
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 0
  Format =
END FILTER
BEGIN FILTER
  FieldAlias = LEVELS
  TableAlias = Stock
  FieldExpr = LEVELS
  Show = 0
  Sort = 0
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = LEVELS
  DataType = 5
  Width = 6
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 0
  Format =
END FILTER
BEGIN FILTER
  FieldAlias = PRODGROUP
  TableAlias = Stock
  FieldExpr = PRODGROUP
  Show = 0
  Sort = 0
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = PRODGROUP
  DataType = 1
  Width = 10
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 0
  Format =
END FILTER
BEGIN SECTION
  Index = 2
  Type = 1
  Mode = 0
  Field =
  Height = 251
  KeepGroup = 0
  NewPage = 0
  NewPageNo = 0
  PrintSection = 1
END SECTION
BEGIN SECTION
  Index = 3
  Type = 2
  Mode = 0
  Field = PRODCODE
  Height = 143
  KeepGroup = 0
  NewPage = 0
  NewPageNo = 0
  PrintSection = 1
END SECTION
BEGIN SECTION
  Index = 13
  Type = 3
  Mode = 0
  Field =
  Height = 31
  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 LINE
  Type = 5
  Name = Horizontal Line1
  Left = 907
  Top = 434
  Height = 10
  Width = 90
  PenColor = clBlack
  PenMode = 4
  PenStyle = 0
  PenWidth = 1
END LINE
BEGIN LABEL
  Type = 0
  Name = Time
  Left = 867
  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 = 768
  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 = Label2
  Left = 769
  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 = 867
  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 = Label25
  Left = 37
  Top = 115
  Height = 45
  Width = 324
  Caption = Stock Check 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 = Label6
  Left = 85
  Top = 192
  Height = 22
  Width = 175
  Caption = Start Stock Code
  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 = 278
  Top = 192
  Height = 22
  Width = 175
  Caption = Finish Stock Code
  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 = STOCKCODE
  Left = 51
  Top = 422
  Height = 22
  Width = 160
  Caption = [STOCKCODE]
  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 = REORDLEV
  Left = 556
  Top = 422
  Height = 22
  Width = 80
  Caption = [REORDLEV]
  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 = LOCATION
  Left = 646
  Top = 422
  Height = 22
  Width = 162
  Caption = [LOCATION]
  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 = INSTOCK
  Left = 816
  Top = 422
  Height = 22
  Width = 80
  Caption = [INSTOCK]
  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 = Label14
  Left = 28
  Top = 346
  Height = 22
  Width = 118
  Caption = Description
  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 = Label13
  Left = 28
  Top = 317
  Height = 22
  Width = 117
  Caption = Product Group
  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 = DESC
  Left = 218
  Top = 422
  Height = 22
  Width = 330
  Caption = [DESC]
  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 = PRODCODE
  Left = 153
  Top = 317
  Height = 22
  Width = 168
  Caption = [PRODCODE]
  Alignment = 0
  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 = PGDESC
  Left = 153
  Top = 346
  Height = 22
  Width = 274
  Caption = [PGDESC]
  Alignment = 0
  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 = Label30
  Left = 51
  Top = 393
  Height = 22
  Width = 160
  Caption = Stock 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 = Label7
  Left = 219
  Top = 393
  Height = 22
  Width = 330
  Caption = Description
  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 = Label1
  Left = 556
  Top = 375
  Height = 40
  Width = 80
  Caption = Reorder Level
  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 = 648
  Top = 393
  Height = 22
  Width = 160
  Caption = Location
  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 = Label11
  Left = 817
  Top = 393
  Height = 22
  Width = 80
  Caption = In Stock
  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 = Label12
  Left = 903
  Top = 393
  Height = 22
  Width = 93
  Caption = Stock Check
  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 = StStkCode
  Left = 85
  Top = 217
  Height = 22
  Width = 175
  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 = FinStkCode
  Left = 278
  Top = 217
  Height = 22
  Width = 175
  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 = StProdGrp
  Left = 473
  Top = 217
  Height = 22
  Width = 150
  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 = FinProdGrp
  Left = 642
  Top = 217
  Height = 22
  Width = 150
  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 = Label4
  Left = 769
  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 = SysDate
  Left = 867
  Top = 67
  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 = 658
  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 = Label9
  Left = 473
  Top = 192
  Height = 22
  Width = 150
  Caption = Start Product Group
  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 = Label10
  Left = 642
  Top = 192
  Height = 22
  Width = 150
  Caption = Finish Product Group
  Alignment = 0
  Color = clWhite
  Transparent = 1
  FontName = MS Sans Serif
  FontSize = 9
  FontColor = clBlack
  FontBold = 0
  FontItalic = 0
  FontUnderline = 1
  FontStrikeOut = 0
END LABEL