PC Plus SuperCD (UK) 1995 September/Image.iso/working/pegasus/setup.2/REPORTS/STREORD.REP

Text File | 1995-06-21 | 9.0 KB | 287 lines

VERSION 2.00
Begin Report STREORD.REP
      Caption      =   "STREORD.REP"
      Width        =   11460
      Height       =   16185
      Reportheader =   1200
      Header       =   825
      Transaction  =   10125
      SubTotal     =   135
      Footer       =   0
      Pagefooter   =   15960
      Replicate    =   390
      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          =   270
      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         =   1725
      Top          =   270
      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         =   4110
      Top          =   270
      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         =   4110
      Top          =   540
      Width        =   780
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         =   4920
      Top          =   270
      Width        =   915
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "Allocated"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   4920
      Top          =   540
      Width        =   915
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "On"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   6000
      Top          =   270
      Width        =   780
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "Order"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   6000
      Top          =   540
      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         =   6810
      Top          =   270
      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         =   6810
      Top          =   540
      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         =   7620
      Top          =   270
      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          =   120
      Width        =   1230
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         =   1290
      Top          =   120
      Width        =   2490
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         =   3900
      Top          =   120
      Width        =   870
End
Begin Control CNQTYALLOC
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNQTYALLOC"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   4845
      Top          =   120
      Width        =   870
End
Begin Control CNQTYONORD
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNQTYONORD"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   5790
      Top          =   120
      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         =   8235
      Top          =   120
      Width        =   1620
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         =   6735
      Top          =   120
      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         =   7680
      Top          =   120
      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          =   120
      Width        =   1215
End