Computer Buyer 1999 March/Dpcb0399.iso/MONEY/Capital/SETUP.2/REPORTS/STREORD.REP

Text File | 1996-07-03 | 7KB | 219 lines

VERSION 2.00
Begin Report STREORD.REP
      Caption      =   "STREORD.REP"
      Width        =   11475
      Height       =   16185
      Reportheader =   1200
      Header       =   1065
      Transaction  =   9885
      SubTotal     =   135
      Footer       =   0
      Pagefooter   =   15960
      Replicate    =   420
      Style        =   8
      Query        =   "STNAME CNPRODTYPE="2"&((CNQTYINST+CNQTYONORD-CNQTYALLOC)<CNREOLEVEL)&CNREOQTY<>0 ORDER BY CNPRODID"
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   12
      Caption      =   "TRIM(SYSTEM.COMPNAME)"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Reportheader Block"
      Height       =   270
      Left         =   -15
      Top          =   405
      Width        =   11070
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "Stock Re-Order"
      Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Reportheader Block"
      Height       =   420
      Left         =   135
      Top          =   675
      Width        =   11025
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   "DTOC(DATE())"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Reportheader Block"
      Height       =   285
      Left         =   135
      Top          =   705
      Width        =   1800
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   10
      Caption      =   ""Page: "+PAGENUM()"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Reportheader Block"
      Height       =   285
      Left         =   9585
      Top          =   720
      Width        =   1395
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   1
      Caption      =   "Product ID"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   30
      Top          =   540
      Width        =   945
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   1
      Caption      =   "Description"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   2265
      Top          =   540
      Width        =   1245
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "Quantity"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   4380
      Top          =   540
      Width        =   780
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "In Stock"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   4380
      Top          =   810
      Width        =   780
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   2
      Caption      =   "Re-Order"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   5190
      Top          =   540
      Width        =   780
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   10
      Caption      =   ""Quantity ""
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   5065
      Top          =   810
      Width        =   915
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "Unit"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   6100
      Top          =   540
      Width        =   510
End
Begin Control CNPRODID
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNPRODID"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   30
      Top          =   150
      Width        =   1635
End
Begin Control CNDESC
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNDESC"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   1830
      Top          =   150
      Width        =   2355
End
Begin Control CNQTYINST
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNQTYINST"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   4170
      Top          =   150
      Width        =   870
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   "IF(((STNAME.CNQTYINST-STNAME.CNQTYALLOC)<0),"Free Stock Exceeded",IF(((STNAME.CNQTYINST-STNAME.CNQTYALLOC)=0),"Down to Zero Free Stock",IF(((STNAME.CNQTYINST-STNAME.CNQTYALLOC)<STNAME.CNMINSTOCK),"Down to Min. Stock","")))"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   8505
      Top          =   150
      Width        =   1485
End
Begin Control CNREOQTY
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNREOQTY"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   5115
      Top          =   150
      Width        =   870
End
Begin Control CNUNITDESC
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNUNITDESC"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   6100
      Top          =   150
      Width        =   600
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   "IF((STNAME.CNQTYINST+STNAME.CNREOQTY+STNAME.CNQTYONORD-STNAME.CNQTYALLOC)<STNAME.CNREOLEVEL,"<<Below Re-Ord>>","")"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   9990
      Top          =   150
      Width        =   1215
End