home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / STPRDLST.REP < prev    next >
Text File  |  1997-10-28  |  19KB  |  546 lines
  1. VERSION 2.00
  2. Begin Report STPRDLST.REP
  3.       Caption      =   "STPRDLST.REP"
  4.       Width        =   11460
  5.       Height       =   16185
  6.       Reportheader =   1200
  7.       Header       =   480
  8.       Transaction  =   14220
  9.       SubTotal     =   0
  10.       Footer       =   0
  11.       Pagefooter   =   15960
  12.       Replicate    =   2505
  13.       Style        =   1
  14.       Query        =   "STNAME CNPRODID=>^@0 & CNPRODID<=^@1 ORDER BY CNPRODID"
  15. End
  16. Begin Control LABEL
  17.       Type         =   "Label"
  18.       Style        =   12
  19.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  20.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  21.       Location     =   "Reportheader Block"
  22.       Height       =   270
  23.       Left         =   -15
  24.       Top          =   405
  25.       Width        =   11070
  26. End
  27. Begin Control LABEL
  28.       Type         =   "Label"
  29.       Style        =   4
  30.       Caption      =   "List of Products"
  31.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  32.       Location     =   "Reportheader Block"
  33.       Height       =   420
  34.       Left         =   135
  35.       Top          =   675
  36.       Width        =   11025
  37. End
  38. Begin Control LABEL
  39.       Type         =   "Label"
  40.       Style        =   9
  41.       Caption      =   "DTOC(DATE())"
  42.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  43.       Location     =   "Reportheader Block"
  44.       Height       =   285
  45.       Left         =   135
  46.       Top          =   705
  47.       Width        =   1800
  48. End
  49. Begin Control LABEL
  50.       Type         =   "Label"
  51.       Style        =   10
  52.       Caption      =   ""Page: "+PAGENUM()"
  53.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  54.       Location     =   "Reportheader Block"
  55.       Height       =   285
  56.       Left         =   9450
  57.       Top          =   720
  58.       Width        =   1530
  59. End
  60. Begin Control LABEL
  61.       Type         =   "Label"
  62.       Style        =   1
  63.       Caption      =   "Product ID"
  64.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  65.       Location     =   "Header Block"
  66.       Height       =   285
  67.       Left         =   165
  68.       Top          =   270
  69.       Width        =   945
  70. End
  71. Begin Control LABEL
  72.       Type         =   "Label"
  73.       Style        =   1
  74.       Caption      =   "Description"
  75.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  76.       Location     =   "Header Block"
  77.       Height       =   285
  78.       Left         =   2265
  79.       Top          =   270
  80.       Width        =   975
  81. End
  82. Begin Control CNDESC
  83.       Type         =   "Text"
  84.       Style        =   0
  85.       Fieldname    =   "CNDESC"
  86.       Filename     =   "STNAME"
  87.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  88.       Location     =   "Transaction Block"
  89.       Height       =   270
  90.       Left         =   2295
  91.       Top          =   345
  92.       Width        =   3390
  93. End
  94. Begin Control LABEL
  95.       Type         =   "Label"
  96.       Style        =   9
  97.       Caption      =   "IF(STNAME.CNPRODTYPE="0","Description Only",IF(STNAME.CNPRODTYPE="1","Product Only","Full Stock Product"))"
  98.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  99.       Location     =   "Transaction Block"
  100.       Height       =   270
  101.       Left         =   2280
  102.       Top          =   615
  103.       Width        =   1215
  104. End
  105. Begin Control LABEL
  106.       Type         =   "Label"
  107.       Style        =   9
  108.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Group ID:","")"
  109.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  110.       Location     =   "Transaction Block"
  111.       Height       =   270
  112.       Left         =   120
  113.       Top          =   1410
  114.       Width        =   810
  115. End
  116. Begin Control LABEL
  117.       Type         =   "Label"
  118.       Style        =   9
  119.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Unit Desc.:","")"
  120.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  121.       Location     =   "Transaction Block"
  122.       Height       =   270
  123.       Left         =   120
  124.       Top          =   1680
  125.       Width        =   810
  126. End
  127. Begin Control LABEL
  128.       Type         =   "Label"
  129.       Style        =   9
  130.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","VAT Code:","")"
  131.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  132.       Location     =   "Transaction Block"
  133.       Height       =   270
  134.       Left         =   120
  135.       Top          =   1950
  136.       Width        =   810
  137. End
  138. Begin Control CNPRODID
  139.       Type         =   "Text"
  140.       Style        =   0
  141.       Fieldname    =   "CNPRODID"
  142.       Filename     =   "STNAME"
  143.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  144.       Location     =   "Transaction Block"
  145.       Height       =   270
  146.       Left         =   135
  147.       Top          =   345
  148.       Width        =   1770
  149. End
  150. Begin Control LABEL
  151.       Type         =   "Label"
  152.       Style        =   9
  153.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Disc. 1:","")"
  154.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  155.       Location     =   "Transaction Block"
  156.       Height       =   270
  157.       Left         =   2280
  158.       Top          =   1410
  159.       Width        =   540
  160. End
  161. Begin Control LABEL
  162.       Type         =   "Label"
  163.       Style        =   9
  164.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Disc. 2:","")"
  165.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  166.       Location     =   "Transaction Block"
  167.       Height       =   270
  168.       Left         =   2280
  169.       Top          =   1680
  170.       Width        =   540
  171. End
  172. Begin Control LABEL
  173.       Type         =   "Label"
  174.       Style        =   9
  175.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Disc. 3:","")"
  176.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  177.       Location     =   "Transaction Block"
  178.       Height       =   270
  179.       Left         =   2280
  180.       Top          =   1950
  181.       Width        =   540
  182. End
  183. Begin Control LABEL
  184.       Type         =   "Label"
  185.       Style        =   10
  186.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNANALHEAD,"")"
  187.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  188.       Location     =   "Transaction Block"
  189.       Height       =   270
  190.       Left         =   1335
  191.       Top          =   1410
  192.       Width        =   810
  193. End
  194. Begin Control LABEL
  195.       Type         =   "Label"
  196.       Style        =   10
  197.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNUNITDESC,"")"
  198.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  199.       Location     =   "Transaction Block"
  200.       Height       =   270
  201.       Left         =   1335
  202.       Top          =   1680
  203.       Width        =   810
  204. End
  205. Begin Control LABEL
  206.       Type         =   "Label"
  207.       Style        =   10
  208.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNVATCODE,"")"
  209.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  210.       Location     =   "Transaction Block"
  211.       Height       =   270
  212.       Left         =   1335
  213.       Top          =   1950
  214.       Width        =   810
  215. End
  216. Begin Control LABEL
  217.       Type         =   "Label"
  218.       Style        =   9
  219.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE1,"")"
  220.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  221.       Location     =   "Transaction Block"
  222.       Height       =   270
  223.       Left         =   3900
  224.       Top          =   1410
  225.       Width        =   270
  226. End
  227. Begin Control LABEL
  228.       Type         =   "Label"
  229.       Style        =   9
  230.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE2,"")"
  231.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  232.       Location     =   "Transaction Block"
  233.       Height       =   270
  234.       Left         =   3900
  235.       Top          =   1680
  236.       Width        =   270
  237. End
  238. Begin Control LABEL
  239.       Type         =   "Label"
  240.       Style        =   9
  241.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE3,"")"
  242.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  243.       Location     =   "Transaction Block"
  244.       Height       =   270
  245.       Left         =   3900
  246.       Top          =   1950
  247.       Width        =   270
  248. End
  249. Begin Control LABEL
  250.       Type         =   "Label"
  251.       Style        =   10
  252.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC1<>0,STR(STNAME.CNDISC1,5,2)+"%","")"
  253.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  254.       Location     =   "Transaction Block"
  255.       Height       =   270
  256.       Left         =   4305
  257.       Top          =   1410
  258.       Width        =   810
  259. End
  260. Begin Control LABEL
  261.       Type         =   "Label"
  262.       Style        =   10
  263.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC2<>0,STR(STNAME.CNDISC2,5,2)+"%","")"
  264.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  265.       Location     =   "Transaction Block"
  266.       Height       =   270
  267.       Left         =   4305
  268.       Top          =   1680
  269.       Width        =   810
  270. End
  271. Begin Control LABEL
  272.       Type         =   "Label"
  273.       Style        =   10
  274.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC3<>0,STR(STNAME.CNDISC3,5,2)+"%","")"
  275.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  276.       Location     =   "Transaction Block"
  277.       Height       =   270
  278.       Left         =   4305
  279.       Top          =   1950
  280.       Width        =   810
  281. End
  282. Begin Control LABEL
  283.       Type         =   "Label"
  284.       Style        =   9
  285.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Min. Stock:","")"
  286.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  287.       Location     =   "Transaction Block"
  288.       Height       =   270
  289.       Left         =   5520
  290.       Top          =   1410
  291.       Width        =   945
  292. End
  293. Begin Control LABEL
  294.       Type         =   "Label"
  295.       Style        =   9
  296.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Selling Price:","")"
  297.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  298.       Location     =   "Transaction Block"
  299.       Height       =   270
  300.       Left         =   2280
  301.       Top          =   2220
  302.       Width        =   1350
  303. End
  304. Begin Control LABEL
  305.       Type         =   "Label"
  306.       Style        =   10
  307.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNMINSTOCK,10,2),"")"
  308.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  309.       Location     =   "Transaction Block"
  310.       Height       =   270
  311.       Left         =   6735
  312.       Top          =   1410
  313.       Width        =   810
  314. End
  315. Begin Control LABEL
  316.       Type         =   "Label"
  317.       Style        =   9
  318.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Re-Ord Level:","")"
  319.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  320.       Location     =   "Transaction Block"
  321.       Height       =   270
  322.       Left         =   5520
  323.       Top          =   1140
  324.       Width        =   945
  325. End
  326. Begin Control LABEL
  327.       Type         =   "Label"
  328.       Style        =   10
  329.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNREOLEVEL,10,2),"")"
  330.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  331.       Location     =   "Transaction Block"
  332.       Height       =   270
  333.       Left         =   6735
  334.       Top          =   1140
  335.       Width        =   810
  336. End
  337. Begin Control LABEL
  338.       Type         =   "Label"
  339.       Style        =   9
  340.       Caption      =   "IF(STNAME.CNPRODTYPE="2","In Stock:","")"
  341.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  342.       Location     =   "Transaction Block"
  343.       Height       =   270
  344.       Left         =   5520
  345.       Top          =   1680
  346.       Width        =   945
  347. End
  348. Begin Control LABEL
  349.       Type         =   "Label"
  350.       Style        =   10
  351.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYINST,10,2),"")"
  352.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  353.       Location     =   "Transaction Block"
  354.       Height       =   270
  355.       Left         =   6735
  356.       Top          =   1680
  357.       Width        =   810
  358. End
  359. Begin Control LABEL
  360.       Type         =   "Label"
  361.       Style        =   9
  362.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Cost Price:","")"
  363.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  364.       Location     =   "Transaction Block"
  365.       Height       =   270
  366.       Left         =   5520
  367.       Top          =   2220
  368.       Width        =   945
  369. End
  370. Begin Control LABEL
  371.       Type         =   "Label"
  372.       Style        =   10
  373.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNCOSPRICE,10,2),"")"
  374.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  375.       Location     =   "Transaction Block"
  376.       Height       =   270
  377.       Left         =   6735
  378.       Top          =   2220
  379.       Width        =   810
  380. End
  381. Begin Control LABEL
  382.       Type         =   "Label"
  383.       Style        =   9
  384.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Supplier ID:","")"
  385.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  386.       Location     =   "Transaction Block"
  387.       Height       =   270
  388.       Left         =   5520
  389.       Top          =   870
  390.       Width        =   945
  391. End
  392. Begin Control LABEL
  393.       Type         =   "Label"
  394.       Style        =   10
  395.       Caption      =   "IF(STNAME.CNPRODTYPE="2",TRIM(STNAME.CNSUPPID),"")"
  396.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  397.       Location     =   "Transaction Block"
  398.       Height       =   270
  399.       Left         =   6735
  400.       Top          =   870
  401.       Width        =   810
  402. End
  403. Begin Control LABEL
  404.       Type         =   "Label"
  405.       Style        =   9
  406.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Last Issued:","")"
  407.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  408.       Location     =   "Transaction Block"
  409.       Height       =   270
  410.       Left         =   5520
  411.       Top          =   600
  412.       Width        =   945
  413. End
  414. Begin Control LABEL
  415.       Type         =   "Label"
  416.       Style        =   10
  417.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNLASTISS<>NULLDATE,DTOC(STNAME.CNLASTISS),"")"
  418.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  419.       Location     =   "Transaction Block"
  420.       Height       =   270
  421.       Left         =   6735
  422.       Top          =   600
  423.       Width        =   810
  424. End
  425. Begin Control LABEL
  426.       Type         =   "Label"
  427.       Style        =   9
  428.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Location:","")"
  429.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  430.       Location     =   "Transaction Block"
  431.       Height       =   270
  432.       Left         =   7815
  433.       Top          =   600
  434.       Width        =   945
  435. End
  436. Begin Control LABEL
  437.       Type         =   "Label"
  438.       Style        =   10
  439.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STNAME.CNLOC),"")"
  440.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  441.       Location     =   "Transaction Block"
  442.       Height       =   270
  443.       Left         =   9165
  444.       Top          =   600
  445.       Width        =   810
  446. End
  447. Begin Control LABEL
  448.       Type         =   "Label"
  449.       Style        =   9
  450.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Part No.:","")"
  451.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  452.       Location     =   "Transaction Block"
  453.       Height       =   270
  454.       Left         =   7815
  455.       Top          =   870
  456.       Width        =   945
  457. End
  458. Begin Control LABEL
  459.       Type         =   "Label"
  460.       Style        =   9
  461.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STNAME.CNSPARTNO),"")"
  462.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  463.       Location     =   "Transaction Block"
  464.       Height       =   270
  465.       Left         =   9165
  466.       Top          =   870
  467.       Width        =   1215
  468. End
  469. Begin Control LABEL
  470.       Type         =   "Label"
  471.       Style        =   9
  472.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Re-Ord Qty:","")"
  473.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  474.       Location     =   "Transaction Block"
  475.       Height       =   270
  476.       Left         =   7815
  477.       Top          =   1140
  478.       Width        =   945
  479. End
  480. Begin Control LABEL
  481.       Type         =   "Label"
  482.       Style        =   10
  483.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNREOQTY,10,2),"")"
  484.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  485.       Location     =   "Transaction Block"
  486.       Height       =   270
  487.       Left         =   9165
  488.       Top          =   1140
  489.       Width        =   810
  490. End
  491. Begin Control LABEL
  492.       Type         =   "Label"
  493.       Style        =   9
  494.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Average Cost:","")"
  495.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  496.       Location     =   "Transaction Block"
  497.       Height       =   270
  498.       Left         =   7815
  499.       Top          =   2220
  500.       Width        =   945
  501. End
  502. Begin Control LABEL
  503.       Type         =   "Label"
  504.       Style        =   10
  505.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNAVGCOS,10,2),"")"
  506.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  507.       Location     =   "Transaction Block"
  508.       Height       =   270
  509.       Left         =   9165
  510.       Top          =   2220
  511.       Width        =   810
  512. End
  513. Begin Control LABEL
  514.       Type         =   "Label"
  515.       Style        =   10
  516.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STR(STNAME.CNSELPRICE,10,2),"")"
  517.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  518.       Location     =   "Transaction Block"
  519.       Height       =   270
  520.       Left         =   4305
  521.       Top          =   2220
  522.       Width        =   810
  523. End
  524. Begin Control LABEL
  525.       Type         =   "Label"
  526.       Style        =   9
  527.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","VAT Inclusive:","")"
  528.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  529.       Location     =   "Transaction Block"
  530.       Height       =   270
  531.       Left         =   135
  532.       Top          =   2235
  533.       Width        =   1080
  534. End
  535. Begin Control LABEL
  536.       Type         =   "Label"
  537.       Style        =   10
  538.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STR(STNAME.CNVATPRICE,10,2),"")"
  539.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  540.       Location     =   "Transaction Block"
  541.       Height       =   270
  542.       Left         =   1350
  543.       Top          =   2235
  544.       Width        =   810
  545. End
  546.