home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / STMOVE.REP < prev    next >
Text File  |  1996-03-07  |  9KB  |  269 lines
  1. VERSION 2.00
  2. Begin Report STMOVE.REP
  3.       Caption      =   "STMOVE.REP"
  4.       Width        =   11490
  5.       Height       =   16185
  6.       Reportheader =   1200
  7.       Header       =   615
  8.       Transaction  =   10155
  9.       SubTotal     =   3150
  10.       Footer       =   0
  11.       Pagefooter   =   15960
  12.       Replicate    =   330
  13.       Style        =   12
  14.       Query        =   "STTRND CDPRODTYPE="2" ORDER BY CDPRODID+CDTYPE"
  15.       Macro        =   "2CD:When STTRND.CDTYPE="4"|STTRND.CDTYPE="5" then REPTOT(0)=REPTOT(0)+STTRND.CDPROFIT"
  16.       Macro        =   "2LU:Select from STTRNH where CHTRANNO=STTRND.CDTRANNO"
  17.       Macro        =   "2LU:Select from STNAME where CNPRODID=STTRND.CDPRODID"
  18.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  19.       Special      =   "TXNRANGE(CDTRANNO,CDCREATION)"
  20. End
  21. Begin Control LABEL
  22.       Type         =   "Label"
  23.       Style        =   12
  24.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  25.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  26.       Location     =   "Reportheader Block"
  27.       Height       =   270
  28.       Left         =   -15
  29.       Top          =   405
  30.       Width        =   11070
  31. End
  32. Begin Control LABEL
  33.       Type         =   "Label"
  34.       Style        =   4
  35.       Caption      =   "Stock Movements"
  36.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  37.       Location     =   "Reportheader Block"
  38.       Height       =   285
  39.       Left         =   135
  40.       Top          =   675
  41.       Width        =   11025
  42. End
  43. Begin Control LABEL
  44.       Type         =   "Label"
  45.       Style        =   9
  46.       Caption      =   "DTOC(DATE())"
  47.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  48.       Location     =   "Reportheader Block"
  49.       Height       =   285
  50.       Left         =   135
  51.       Top          =   705
  52.       Width        =   3555
  53. End
  54. Begin Control LABEL
  55.       Type         =   "Label"
  56.       Style        =   10
  57.       Caption      =   ""Page: "+PAGENUM()"
  58.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  59.       Location     =   "Reportheader Block"
  60.       Height       =   285
  61.       Left         =   9585
  62.       Top          =   720
  63.       Width        =   1395
  64. End
  65. Begin Control LABEL
  66.       Type         =   "Label"
  67.       Style        =   1
  68.       Caption      =   "Product ID"
  69.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  70.       Location     =   "Header Block"
  71.       Height       =   285
  72.       Left         =   30
  73.       Top          =   270
  74.       Width        =   945
  75. End
  76. Begin Control LABEL
  77.       Type         =   "Label"
  78.       Style        =   1
  79.       Caption      =   "Description"
  80.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  81.       Location     =   "Header Block"
  82.       Height       =   285
  83.       Left         =   1860
  84.       Top          =   270
  85.       Width        =   1110
  86. End
  87. Begin Control LABEL
  88.       Type         =   "Label"
  89.       Style        =   1
  90.       Caption      =   "Reference"
  91.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  92.       Location     =   "Header Block"
  93.       Height       =   285
  94.       Left         =   6270
  95.       Top          =   270
  96.       Width        =   990
  97. End
  98. Begin Control LABEL
  99.       Type         =   "Label"
  100.       Style        =   2
  101.       Caption      =   "Qty"
  102.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  103.       Location     =   "Header Block"
  104.       Height       =   285
  105.       Left         =   7485
  106.       Top          =   270
  107.       Width        =   375
  108. End
  109. Begin Control LABEL
  110.       Type         =   "Label"
  111.       Style        =   4
  112.       Caption      =   "Type"
  113.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  114.       Location     =   "Header Block"
  115.       Height       =   285
  116.       Left         =   4365
  117.       Top          =   270
  118.       Width        =   600
  119. End
  120. Begin Control LABEL
  121.       Type         =   "Label"
  122.       Style        =   1
  123.       Caption      =   "Date"
  124.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  125.       Location     =   "Header Block"
  126.       Height       =   285
  127.       Left         =   5190
  128.       Top          =   270
  129.       Width        =   585
  130. End
  131. Begin Control LABEL
  132.       Type         =   "Label"
  133.       Style        =   1
  134.       Caption      =   "Unit"
  135.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  136.       Location     =   "Header Block"
  137.       Height       =   285
  138.       Left         =   8160
  139.       Top          =   270
  140.       Width        =   375
  141. End
  142. Begin Control CDPRODID
  143.       Type         =   "Text"
  144.       Style        =   0
  145.       Fieldname    =   "CDPRODID"
  146.       Filename     =   "STTRND"
  147.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  148.       Location     =   "Transaction Block"
  149.       Height       =   270
  150.       Left         =   30
  151.       Top          =   60
  152.       Width        =   1770
  153. End
  154. Begin Control CDDESC
  155.       Type         =   "Text"
  156.       Style        =   0
  157.       Fieldname    =   "CDDESC"
  158.       Filename     =   "STTRND"
  159.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  160.       Location     =   "Transaction Block"
  161.       Height       =   270
  162.       Left         =   1875
  163.       Top          =   60
  164.       Width        =   2625
  165. End
  166. Begin Control CDDOCNO
  167.       Type         =   "Text"
  168.       Style        =   0
  169.       Fieldname    =   "CDDOCNO"
  170.       Filename     =   "STTRND"
  171.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  172.       Location     =   "Transaction Block"
  173.       Height       =   270
  174.       Left         =   6255
  175.       Top          =   60
  176.       Width        =   1005
  177. End
  178. Begin Control CDQUANTITY
  179.       Type         =   "Text"
  180.       Style        =   0
  181.       Fieldname    =   "CDQUANTITY"
  182.       Filename     =   "STTRND"
  183.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  184.       Location     =   "Transaction Block"
  185.       Height       =   270
  186.       Left         =   7275
  187.       Top          =   60
  188.       Width        =   735
  189. End
  190. Begin Control LABEL
  191.       Type         =   "Label"
  192.       Style        =   9
  193.       Caption      =   "MID("       ReceiptIssue  Adjust Return CmPO   POrd   CmSO   SOrd   Prof   Quot   ",(INSTR("3485019BEF",STTRND.CDTYPE)*7)+1,7)"
  194.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  195.       Location     =   "Transaction Block"
  196.       Height       =   270
  197.       Left         =   4485
  198.       Top          =   60
  199.       Width        =   675
  200. End
  201. Begin Control CDTXNDATE
  202.       Type         =   "Text"
  203.       Style        =   0
  204.       Fieldname    =   "CDTXNDATE"
  205.       Filename     =   "STTRND"
  206.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  207.       Location     =   "Transaction Block"
  208.       Height       =   270
  209.       Left         =   5175
  210.       Top          =   60
  211.       Width        =   1005
  212. End
  213. Begin Control CNUNITDESC
  214.       Type         =   "Text"
  215.       Style        =   0
  216.       Fieldname    =   "CNUNITDESC"
  217.       Filename     =   "STNAME"
  218.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  219.       Location     =   "Transaction Block"
  220.       Height       =   270
  221.       Left         =   8220
  222.       Top          =   60
  223.       Width        =   465
  224. End
  225. Begin Control LABEL
  226.       Type         =   "Label"
  227.       Style        =   9
  228.       Caption      =   "IF(STTRND.CDTYPE="3","Cost =",IF(STTRND.CDTYPE="4"|STTRND.CDTYPE="5","Profit =",IF(STTRND.CDTYPE="0"|STTRND.CDTYPE="9","Completed ",IF(STTRND.CDTYPE="1"|STTRND.CDTYPE="B"|STTRND.CDTYPE="E"|STTRND.CDTYPE="F","Due "+IF(STTRNH.CHDUEDEL<>NULLDATE,DTOC(STTRNH.CHDUEDEL),""),""))))"
  229.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  230.       Location     =   "Transaction Block"
  231.       Height       =   270
  232.       Left         =   8760
  233.       Top          =   60
  234.       Width        =   1080
  235. End
  236. Begin Control LABEL
  237.       Type         =   "Label"
  238.       Style        =   9
  239.       Caption      =   "IF(STTRND.CDTYPE="3",LTRIM(STR(STTRND.CDPRICE,10,2)),IF(STTRND.CDTYPE="4"|STTRND.CDTYPE="5",LTRIM(STR(STTRND.CDPROFIT,10,2)),IF(STTRND.CDTYPE="0"|STTRND.CDTYPE="1","From "+STTRND.CDACCID,IF(STTRND.CDTYPE="9"|STTRND.CDTYPE="B"|STTRND.CDTYPE="E"|STTRND.CDTYPE="F","To  "+STTRND.CDACCID,""))))"
  240.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  241.       Location     =   "Transaction Block"
  242.       Height       =   270
  243.       Left         =   9720
  244.       Top          =   60
  245.       Width        =   1830
  246. End
  247. Begin Control LABEL
  248.       Type         =   "Label"
  249.       Style        =   9
  250.       Caption      =   "STR(REPTOT(0),10,2)"
  251.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  252.       Location     =   "Subtotal Block"
  253.       Height       =   270
  254.       Left         =   2220
  255.       Top          =   2340
  256.       Width        =   1620
  257. End
  258. Begin Control LABEL
  259.       Type         =   "Label"
  260.       Style        =   1
  261.       Caption      =   "Total Expected Profit  ="
  262.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  263.       Location     =   "Subtotal Block"
  264.       Height       =   270
  265.       Left         =   135
  266.       Top          =   2340
  267.       Width        =   2025
  268. End
  269.