home *** CD-ROM | disk | FTP | other *** search
- VERSION 2.00
- Begin Report STPRDLST.REP
- Caption = "STPRDLST.REP"
- Width = 11460
- Height = 16185
- Reportheader = 1200
- Header = 480
- Transaction = 14220
- SubTotal = 0
- Footer = 0
- Pagefooter = 15960
- Replicate = 2490
- Style = 1
- Query = "STNAME CNPRODID=>^@0 & CNPRODID<=^@1 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 = "List of Products"
- 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 = 9450
- Top = 720
- Width = 1530
- 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 = 165
- 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 = 2265
- Top = 270
- Width = 975
- 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 = 2295
- Top = 345
- Width = 3390
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="0","Description Only",IF(STNAME.CNPRODTYPE="1","Product Only","Full Stock Product"))"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 2280
- Top = 615
- Width = 1215
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0","Group ID:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 120
- Top = 1410
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0","Unit Desc.:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 120
- Top = 1680
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0","VAT Code:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 120
- Top = 1950
- Width = 810
- 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 = 135
- Top = 345
- Width = 1230
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0","Disc. 1:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 2280
- Top = 1410
- Width = 540
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0","Disc. 2:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 2280
- Top = 1680
- Width = 540
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0","Disc. 3:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 2280
- Top = 1950
- Width = 540
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNANALHEAD,"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 1065
- Top = 1410
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNUNITDESC,"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 1065
- Top = 1680
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNVATCODE,"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 1065
- Top = 1950
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE1,"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 3900
- Top = 1410
- Width = 270
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE2,"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 3900
- Top = 1680
- Width = 270
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE3,"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 3900
- Top = 1950
- Width = 270
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC1<>0,STR(STNAME.CNDISC1,5,2)+"%","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 4305
- Top = 1410
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC2<>0,STR(STNAME.CNDISC2,5,2)+"%","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 4305
- Top = 1680
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC3<>0,STR(STNAME.CNDISC3,5,2)+"%","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 4305
- Top = 1950
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","Min. Stock:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 5520
- Top = 1410
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0","Selling Price:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 2280
- Top = 2220
- Width = 1350
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNMINSTOCK,10,2),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 6735
- Top = 1410
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","Re-Ord Level:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 5520
- Top = 1140
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNREOLEVEL,10,2),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 6735
- Top = 1140
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","In Stock:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 5520
- Top = 1680
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYINST,10,2),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 6735
- Top = 1680
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","Allocated:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 5520
- Top = 1950
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYALLOC,10,2),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 6735
- Top = 1950
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","Cost Price:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 5520
- Top = 2220
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNCOSPRICE,10,2),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 6735
- Top = 2220
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","Supplier ID:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 5520
- Top = 870
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE="2",TRIM(STNAME.CNSUPPID),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 6735
- Top = 870
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE<>"0","Last Issued:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 5520
- Top = 600
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNLASTISS<>NULLDATE,DTOC(STNAME.CNLASTISS),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 6735
- Top = 600
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","Location:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 7815
- Top = 600
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE="2",STNAME.CNLOC),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 9165
- Top = 600
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","Part No.:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 7815
- Top = 870
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2",STNAME.CNSPARTNO),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 9165
- Top = 870
- Width = 1215
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","Free Stock:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 7815
- Top = 1410
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYINST-STNAME.CNQTYALLOC,10,2),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 9165
- Top = 1410
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","On Order:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 7815
- Top = 1680
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYONORD,10,2),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 9165
- Top = 1680
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","Proj. Stock:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 7815
- Top = 1950
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYINST+STNAME.CNQTYONORD-STNAME.CNQTYALLOC,10,2),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 9165
- Top = 1950
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","Re-Ord Qty:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 7815
- Top = 1140
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNREOQTY,10,2),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 9165
- Top = 1140
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "IF(STNAME.CNPRODTYPE="2","Average Cost:","")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 7815
- Top = 2220
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNAVGCOS,10,2),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 9165
- Top = 2220
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "IF(STNAME.CNPRODTYPE<>"0",STR(STNAME.CNSELPRICE,10,2),"")"
- Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 4305
- Top = 2220
- Width = 810
- End
-