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

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

<SHAZAM REPORT WIZARD>
BEGIN REPORT
  FileVersion = 3.50
  ProductVersion = 3.50
  ProductRevision = M
  Password =
  PixelsPerInch = 120
  Distinct = 0
  Count = 13
  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 = 7
  Left = 0
  Height = 132
  Width = 155
END TABLE
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 = 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 FILTER
  FieldAlias = REORDLEV
  TableAlias = Stock
  FieldExpr = REORDLEV
  Show = 0
  Sort = 0
  FilterDisplay1 = >  0
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = REORDLEV
  DataType = 6
  Width = 10
  FilterValues1 = 0|2|0|||||
  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 = COSTPRICE
  TableAlias = Stock
  FieldExpr = COSTPRICE
  Show = 0
  Sort = 0
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = COSTPRICE
  DataType = 6
  Width = 10
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 2
  Format =
END FILTER
BEGIN FILTER
  FieldAlias = PROJSTOCK
  TableAlias =
  FieldExpr = (Stock.INSTOCK +  Stock.ONORDER )
  Show = 0
  Sort = 0
  FilterDisplay1 = <  Stock.ReordLev
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = (Stock.INSTOCK +  Stock.ONORDER )
  DataType = 0
  Width = 10
  FilterValues1 = 0|4|Stock.ReordLev|||||
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 0
  Format =
END FILTER
BEGIN FILTER
  FieldAlias = REORDVAL
  TableAlias =
  FieldExpr = (Stock.REORDQUAN *  Stock.COSTPRICE )
  Show = 0
  Sort = 0
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = (Stock.REORDQUAN *  Stock.COSTPRICE )
  DataType = 0
  Width = 10
  FilterValues1 =
  FilterValues2 =
  FilterValues3 =
  FilterValues4 =
  FilterValues5 =
  Alignment = 0
  Format = 0.00
END FILTER
BEGIN FILTER
  FieldAlias = SUPPLIER
  TableAlias = Stock
  FieldExpr = SUPPLIER
  Show = 0
  Sort = 0
  FilterDisplay1 =
  FilterDisplay2 =
  FilterDisplay3 =
  FilterDisplay4 =
  FilterDisplay5 =
  FieldName = SUPPLIER
  DataType = 1
  Width = 10
  FilterValues1 =
  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 = 59
  KeepGroup = 0
  NewPage = 0
  NewPageNo = 0
  PrintSection = 1
END SECTION
BEGIN SHAPE
  Type = 3
  Name = Rectangle1
  Left = 760
  Top = 365
  Height = 36
  Width = 237
  BrushColor = clWhite
  BrushStyle = 1
  PenColor = clBlack
  PenMode = 4
  PenStyle = 0
  PenWidth = 1
END SHAPE
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 = STOCKCODE
  Left = 32
  Top = 326
  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 = 536
  Top = 326
  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 = INSTOCK Caption
  Left = 620
  Top = 298
  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 = INSTOCK
  Left = 620
  Top = 326
  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 = REORDQUAN
  Left = 705
  Top = 326
  Height = 22
  Width = 80
  Caption = [REORDQUAN]
  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 = COSTPRICE
  Left = 790
  Top = 326
  Height = 22
  Width = 100
  Caption = [COSTPRICE]
  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 = Label30
  Left = 32
  Top = 298
  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 = REORDLEV Caption
  Left = 536
  Top = 280
  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 = COSTPRICE Caption
  Left = 790
  Top = 298
  Height = 22
  Width = 100
  Caption = Cost Price
  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 = Label7
  Left = 197
  Top = 298
  Height = 22
  Width = 335
  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 = 894
  Top = 280
  Height = 40
  Width = 100
  Caption = Reorder Value
  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 = REORDVAL
  Left = 895
  Top = 326
  Height = 22
  Width = 100
  Caption = [REORDVAL]
  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 = REORDVAL1
  Left = 884
  Top = 372
  Height = 22
  Width = 110
  Caption = @Sum([REORDVAL])
  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 = REORDQUAN Caption
  Left = 705
  Top = 280
  Height = 40
  Width = 80
  Caption = Reorder Qty
  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 = 767
  Top = 372
  Height = 22
  Width = 108
  Caption = Reorder Total
  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 = 197
  Top = 326
  Height = 22
  Width = 335
  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 = StProdGrp
  Left = 115
  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 = SuppLbl
  Left = 436
  Top = 217
  Height = 22
  Width = 110
  Caption =
  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 = 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 = 866
  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 = Label25
  Left = 37
  Top = 115
  Height = 45
  Width = 407
  Caption = Stock Reorder 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 = FinProdGrp
  Left = 275
  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 = Label9
  Left = 115
  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 = 275
  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
BEGIN LABEL
  Type = 0
  Name = SuppHdr
  Left = 437
  Top = 192
  Height = 22
  Width = 110
  Caption = Supplier
  Alignment = 0
  Color = clWhite
  Transparent = 1
  FontName = Arial
  FontSize = 9
  FontColor = clBlack
  FontBold = 0
  FontItalic = 0
  FontUnderline = 1
  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