home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / STVALUE.REP < prev    next >
Text File  |  1996-03-07  |  14KB  |  440 lines
  1. VERSION 2.00
  2. Begin Report STVALUE.REP
  3.       Caption      =   "STVALUE.REP"
  4.       Width        =   11460
  5.       Height       =   16185
  6.       Reportheader =   1200
  7.       Header       =   900
  8.       Transaction  =   9915
  9.       SubTotal     =   1440
  10.       Footer       =   840
  11.       Pagefooter   =   15960
  12.       Replicate    =   450
  13.       Style        =   8
  14.       Query        =   "STNAME CNPRODTYPE="2" & CNPRODID => ^@0 & CNPRODID <= ^@1 ORDER BY CNPRODID"
  15.       Macro        =   "2OF:STTRND.CDPRODID = STNAME.CNPRODID"
  16.       Macro        =   "2CD:When STNAME.CNPRODTYPE="2" then REPTOT(0)=REPTOT(0)+(STNAME.CNQTYINST*STNAME.CNAVGCOS)"
  17.       Macro        =   "2CD:When STNAME.CNPRODTYPE="2" then REPTOT(1)=REPTOT(1)+(STNAME.CNQTYINST*STNAME.CNSELPRICE)"
  18.       Macro        =   "3PP:@REPVARS.REPTOT(3) = REPTOT(3)+REPTOT(0)"
  19.       Macro        =   "3PP:@REPVARS.REPTOT(4) = REPTOT(4)+REPTOT(1)"
  20.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  21.       Macro        =   "3PP:@REPVARS.REPTOT(1) = 0"
  22.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  23.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  24.       Macro        =   "4PP:@REPVARS.REPTOT(3) = 0"
  25.       Macro        =   "4PP:@REPVARS.REPTOT(4) = 0"
  26.       BreakOn      =   "LEFT(STNAME.CNPRODID,1)"
  27. End
  28. Begin Control LABEL
  29.       Type         =   "Label"
  30.       Style        =   12
  31.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  32.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  33.       Location     =   "Reportheader Block"
  34.       Height       =   270
  35.       Left         =   -15
  36.       Top          =   405
  37.       Width        =   11070
  38. End
  39. Begin Control LABEL
  40.       Type         =   "Label"
  41.       Style        =   4
  42.       Caption      =   "Stock Valuation"
  43.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  44.       Location     =   "Reportheader Block"
  45.       Height       =   420
  46.       Left         =   135
  47.       Top          =   675
  48.       Width        =   11025
  49. End
  50. Begin Control LABEL
  51.       Type         =   "Label"
  52.       Style        =   9
  53.       Caption      =   "DTOC(DATE())"
  54.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  55.       Location     =   "Reportheader Block"
  56.       Height       =   285
  57.       Left         =   135
  58.       Top          =   705
  59.       Width        =   1800
  60. End
  61. Begin Control LABEL
  62.       Type         =   "Label"
  63.       Style        =   10
  64.       Caption      =   ""Page: "+PAGENUM()"
  65.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  66.       Location     =   "Reportheader Block"
  67.       Height       =   285
  68.       Left         =   9585
  69.       Top          =   720
  70.       Width        =   1395
  71. End
  72. Begin Control LABEL
  73.       Type         =   "Label"
  74.       Style        =   1
  75.       Caption      =   "Product ID"
  76.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  77.       Location     =   "Header Block"
  78.       Height       =   285
  79.       Left         =   30
  80.       Top          =   270
  81.       Width        =   945
  82. End
  83. Begin Control LABEL
  84.       Type         =   "Label"
  85.       Style        =   1
  86.       Caption      =   "Description"
  87.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  88.       Location     =   "Header Block"
  89.       Height       =   285
  90.       Left         =   2265
  91.       Top          =   270
  92.       Width        =   1785
  93. End
  94. Begin Control LABEL
  95.       Type         =   "Label"
  96.       Style        =   4
  97.       Caption      =   "Quantity"
  98.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  99.       Location     =   "Header Block"
  100.       Height       =   285
  101.       Left         =   4515
  102.       Top          =   270
  103.       Width        =   915
  104. End
  105. Begin Control LABEL
  106.       Type         =   "Label"
  107.       Style        =   4
  108.       Caption      =   "In Stock"
  109.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  110.       Location     =   "Header Block"
  111.       Height       =   285
  112.       Left         =   4515
  113.       Top          =   540
  114.       Width        =   915
  115. End
  116. Begin Control LABEL
  117.       Type         =   "Label"
  118.       Style        =   4
  119.       Caption      =   "Average"
  120.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  121.       Location     =   "Header Block"
  122.       Height       =   285
  123.       Left         =   5460
  124.       Top          =   270
  125.       Width        =   915
  126. End
  127. Begin Control LABEL
  128.       Type         =   "Label"
  129.       Style        =   4
  130.       Caption      =   "Cost Price"
  131.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  132.       Location     =   "Header Block"
  133.       Height       =   285
  134.       Left         =   5460
  135.       Top          =   540
  136.       Width        =   915
  137. End
  138. Begin Control LABEL
  139.       Type         =   "Label"
  140.       Style        =   4
  141.       Caption      =   "Selling"
  142.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  143.       Location     =   "Header Block"
  144.       Height       =   285
  145.       Left         =   6540
  146.       Top          =   270
  147.       Width        =   780
  148. End
  149. Begin Control LABEL
  150.       Type         =   "Label"
  151.       Style        =   4
  152.       Caption      =   "Price"
  153.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  154.       Location     =   "Header Block"
  155.       Height       =   285
  156.       Left         =   6540
  157.       Top          =   540
  158.       Width        =   780
  159. End
  160. Begin Control LABEL
  161.       Type         =   "Label"
  162.       Style        =   4
  163.       Caption      =   "Cost"
  164.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  165.       Location     =   "Header Block"
  166.       Height       =   285
  167.       Left         =   7485
  168.       Top          =   270
  169.       Width        =   780
  170. End
  171. Begin Control LABEL
  172.       Type         =   "Label"
  173.       Style        =   4
  174.       Caption      =   "Value"
  175.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  176.       Location     =   "Header Block"
  177.       Height       =   285
  178.       Left         =   7485
  179.       Top          =   540
  180.       Width        =   780
  181. End
  182. Begin Control LABEL
  183.       Type         =   "Label"
  184.       Style        =   4
  185.       Caption      =   "Selling"
  186.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  187.       Location     =   "Header Block"
  188.       Height       =   285
  189.       Left         =   8430
  190.       Top          =   270
  191.       Width        =   915
  192. End
  193. Begin Control LABEL
  194.       Type         =   "Label"
  195.       Style        =   4
  196.       Caption      =   "Value"
  197.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  198.       Location     =   "Header Block"
  199.       Height       =   285
  200.       Left         =   8430
  201.       Top          =   540
  202.       Width        =   915
  203. End
  204. Begin Control LABEL
  205.       Type         =   "Label"
  206.       Style        =   4
  207.       Caption      =   "Potential"
  208.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  209.       Location     =   "Header Block"
  210.       Height       =   285
  211.       Left         =   9510
  212.       Top          =   270
  213.       Width        =   915
  214. End
  215. Begin Control LABEL
  216.       Type         =   "Label"
  217.       Style        =   4
  218.       Caption      =   "Profit"
  219.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  220.       Location     =   "Header Block"
  221.       Height       =   285
  222.       Left         =   9510
  223.       Top          =   540
  224.       Width        =   915
  225. End
  226. Begin Control LABEL
  227.       Type         =   "Label"
  228.       Style        =   4
  229.       Caption      =   "No. of"
  230.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  231.       Location     =   "Header Block"
  232.       Height       =   285
  233.       Left         =   10455
  234.       Top          =   270
  235.       Width        =   780
  236. End
  237. Begin Control LABEL
  238.       Type         =   "Label"
  239.       Style        =   4
  240.       Caption      =   "Days"
  241.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  242.       Location     =   "Header Block"
  243.       Height       =   285
  244.       Left         =   10455
  245.       Top          =   540
  246.       Width        =   780
  247. End
  248. Begin Control CNPRODID
  249.       Type         =   "Text"
  250.       Style        =   0
  251.       Fieldname    =   "CNPRODID"
  252.       Filename     =   "STNAME"
  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         =   30
  257.       Top          =   180
  258.       Width        =   1635
  259. End
  260. Begin Control CNDESC
  261.       Type         =   "Text"
  262.       Style        =   0
  263.       Fieldname    =   "CNDESC"
  264.       Filename     =   "STNAME"
  265.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  266.       Location     =   "Transaction Block"
  267.       Height       =   270
  268.       Left         =   1830
  269.       Top          =   180
  270.       Width        =   2490
  271. End
  272. Begin Control CNQTYINST
  273.       Type         =   "Text"
  274.       Style        =   0
  275.       Fieldname    =   "CNQTYINST"
  276.       Filename     =   "STNAME"
  277.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  278.       Location     =   "Transaction Block"
  279.       Height       =   270
  280.       Left         =   4440
  281.       Top          =   180
  282.       Width        =   870
  283. End
  284. Begin Control LABEL
  285.       Type         =   "Label"
  286.       Style        =   10
  287.       Caption      =   "STR((STNAME.CNQTYINST*STNAME.CNAVGCOS),10,2)"
  288.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  289.       Location     =   "Transaction Block"
  290.       Height       =   270
  291.       Left         =   7290
  292.       Top          =   180
  293.       Width        =   870
  294. End
  295. Begin Control CNAVGCOS
  296.       Type         =   "Text"
  297.       Style        =   0
  298.       Fieldname    =   "CNAVGCOS"
  299.       Filename     =   "STNAME"
  300.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  301.       Location     =   "Transaction Block"
  302.       Height       =   270
  303.       Left         =   5385
  304.       Top          =   180
  305.       Width        =   870
  306. End
  307. Begin Control CNSELPRICE
  308.       Type         =   "Text"
  309.       Style        =   0
  310.       Fieldname    =   "CNSELPRICE"
  311.       Filename     =   "STNAME"
  312.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  313.       Location     =   "Transaction Block"
  314.       Height       =   270
  315.       Left         =   6330
  316.       Top          =   180
  317.       Width        =   870
  318. End
  319. Begin Control LABEL
  320.       Type         =   "Label"
  321.       Style        =   10
  322.       Caption      =   "STR((STNAME.CNQTYINST*STNAME.CNSELPRICE),10,2)"
  323.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  324.       Location     =   "Transaction Block"
  325.       Height       =   270
  326.       Left         =   8370
  327.       Top          =   180
  328.       Width        =   870
  329. End
  330. Begin Control LABEL
  331.       Type         =   "Label"
  332.       Style        =   10
  333.       Caption      =   "STR(((STNAME.CNQTYINST*STNAME.CNSELPRICE)-(STNAME.CNQTYINST*STNAME.CNAVGCOS)),10,2)"
  334.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  335.       Location     =   "Transaction Block"
  336.       Height       =   270
  337.       Left         =   9450
  338.       Top          =   180
  339.       Width        =   870
  340. End
  341. Begin Control LABEL
  342.       Type         =   "Label"
  343.       Style        =   10
  344.       Caption      =   "IF(STNAME.CNLASTISS<>NULLDATE & STNAME.CNLASTISS<DATE(),IF(DATE()-STNAME.CNLASTISS>364,"1 Year+",(STR(DATE()-STNAME.CNLASTISS,3,0)),"")"
  345.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  346.       Location     =   "Transaction Block"
  347.       Height       =   270
  348.       Left         =   10395
  349.       Top          =   180
  350.       Width        =   675
  351. End
  352. Begin Control LABEL
  353.       Type         =   "Label"
  354.       Style        =   9
  355.       Caption      =   ""Actual Stock Value For Group "+LEFT(STTRND.CDPRODID,1)+" =""
  356.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  357.       Location     =   "Subtotal Block"
  358.       Height       =   405
  359.       Left         =   4995
  360.       Top          =   525
  361.       Width        =   2565
  362. End
  363. Begin Control LABEL
  364.       Type         =   "Label"
  365.       Style        =   10
  366.       Caption      =   "STR(REPTOT(0),10,2)"
  367.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  368.       Location     =   "Subtotal Block"
  369.       Height       =   270
  370.       Left         =   7290
  371.       Top          =   525
  372.       Width        =   870
  373. End
  374. Begin Control LABEL
  375.       Type         =   "Label"
  376.       Style        =   10
  377.       Caption      =   "STR(REPTOT(1),10,2)"
  378.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  379.       Location     =   "Subtotal Block"
  380.       Height       =   270
  381.       Left         =   8370
  382.       Top          =   525
  383.       Width        =   870
  384. End
  385. Begin Control LABEL
  386.       Type         =   "Label"
  387.       Style        =   10
  388.       Caption      =   "STR(REPTOT(1)-REPTOT(0),10,2)"
  389.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  390.       Location     =   "Subtotal Block"
  391.       Height       =   270
  392.       Left         =   9450
  393.       Top          =   525
  394.       Width        =   870
  395. End
  396. Begin Control LABEL
  397.       Type         =   "Label"
  398.       Style        =   9
  399.       Caption      =   ""Total Stock Value =""
  400.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  401.       Location     =   "Footer Block"
  402.       Height       =   270
  403.       Left         =   4995
  404.       Top          =   525
  405.       Width        =   1755
  406. End
  407. Begin Control LABEL
  408.       Type         =   "Label"
  409.       Style        =   10
  410.       Caption      =   "STR(REPTOT(3),10,2)"
  411.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  412.       Location     =   "Footer Block"
  413.       Height       =   270
  414.       Left         =   7290
  415.       Top          =   570
  416.       Width        =   870
  417. End
  418. Begin Control LABEL
  419.       Type         =   "Label"
  420.       Style        =   10
  421.       Caption      =   "STR(REPTOT(4),10,2)"
  422.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  423.       Location     =   "Footer Block"
  424.       Height       =   270
  425.       Left         =   8370
  426.       Top          =   570
  427.       Width        =   870
  428. End
  429. Begin Control LABEL
  430.       Type         =   "Label"
  431.       Style        =   10
  432.       Caption      =   "STR(REPTOT(4)-REPTOT(3),10,2)"
  433.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  434.       Location     =   "Footer Block"
  435.       Height       =   270
  436.       Left         =   9450
  437.       Top          =   570
  438.       Width        =   870
  439. End
  440.