home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / STPRDENQ.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  25.8 KB  |  769 lines
  1. VERSION 2.00
  2. Begin Report STPRDENQ.REP
  3.       Caption      =   "STPRDENQ.REP"
  4.       Width        =   11460
  5.       Height       =   16185
  6.       Reportheader =   1200
  7.       Header       =   3210
  8.       Transaction  =   7560
  9.       SubTotal     =   270
  10.       Footer       =   0
  11.       Pagefooter   =   15960
  12.       Replicate    =   315
  13.       Style        =   1
  14.       Query        =   "STTRND CDPRODID>=^@0 & CDPRODID<=^@1 ORDER BY CDPRODID+CDTYPE"
  15.       Macro        =   "1LU:Select from STNAME where CNPRODID=STTRND.CDPRODID"
  16.       Macro        =   "2LU:Select from STTRNH where CHTRANNO=STTRND.CDTRANNO"
  17.       BreakOn      =   "STTRND.CDPRODID"
  18. End
  19. Begin Control LABEL
  20.       Type         =   "Label"
  21.       Style        =   12
  22.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  23.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  24.       Location     =   "Reportheader Block"
  25.       Height       =   270
  26.       Left         =   -15
  27.       Top          =   405
  28.       Width        =   11070
  29. End
  30. Begin Control LABEL
  31.       Type         =   "Label"
  32.       Style        =   4
  33.       Caption      =   "Product Enquiry"
  34.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  35.       Location     =   "Reportheader Block"
  36.       Height       =   420
  37.       Left         =   135
  38.       Top          =   675
  39.       Width        =   11025
  40. End
  41. Begin Control LABEL
  42.       Type         =   "Label"
  43.       Style        =   9
  44.       Caption      =   "DTOC(DATE())"
  45.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  46.       Location     =   "Reportheader Block"
  47.       Height       =   285
  48.       Left         =   135
  49.       Top          =   705
  50.       Width        =   1800
  51. End
  52. Begin Control LABEL
  53.       Type         =   "Label"
  54.       Style        =   10
  55.       Caption      =   ""Page: "+PAGENUM()"
  56.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  57.       Location     =   "Reportheader Block"
  58.       Height       =   285
  59.       Left         =   9585
  60.       Top          =   720
  61.       Width        =   1395
  62. End
  63. Begin Control LABEL
  64.       Type         =   "Label"
  65.       Style        =   1
  66.       Caption      =   "Product ID"
  67.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  68.       Location     =   "Header Block"
  69.       Height       =   285
  70.       Left         =   165
  71.       Top          =   270
  72.       Width        =   945
  73. End
  74. Begin Control LABEL
  75.       Type         =   "Label"
  76.       Style        =   1
  77.       Caption      =   "Description"
  78.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  79.       Location     =   "Header Block"
  80.       Height       =   285
  81.       Left         =   2400
  82.       Top          =   270
  83.       Width        =   1110
  84. End
  85. Begin Control LABEL
  86.       Type         =   "Label"
  87.       Style        =   1
  88.       Caption      =   "Reference"
  89.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  90.       Location     =   "Header Block"
  91.       Height       =   285
  92.       Left         =   2415
  93.       Top          =   2820
  94.       Width        =   990
  95. End
  96. Begin Control LABEL
  97.       Type         =   "Label"
  98.       Style        =   2
  99.       Caption      =   "Qty"
  100.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  101.       Location     =   "Header Block"
  102.       Height       =   285
  103.       Left         =   3795
  104.       Top          =   2835
  105.       Width        =   510
  106. End
  107. Begin Control LABEL
  108.       Type         =   "Label"
  109.       Style        =   1
  110.       Caption      =   "Type"
  111.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  112.       Location     =   "Header Block"
  113.       Height       =   285
  114.       Left         =   120
  115.       Top          =   2835
  116.       Width        =   600
  117. End
  118. Begin Control LABEL
  119.       Type         =   "Label"
  120.       Style        =   1
  121.       Caption      =   "Date"
  122.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  123.       Location     =   "Header Block"
  124.       Height       =   285
  125.       Left         =   1200
  126.       Top          =   2835
  127.       Width        =   585
  128. End
  129. Begin Control LABEL
  130.       Type         =   "Label"
  131.       Style        =   2
  132.       Caption      =   "Qty Bal"
  133.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  134.       Location     =   "Header Block"
  135.       Height       =   285
  136.       Left         =   4740
  137.       Top          =   2835
  138.       Width        =   645
  139. End
  140. Begin Control CNPRODID
  141.       Type         =   "Text"
  142.       Style        =   0
  143.       Fieldname    =   "CNPRODID"
  144.       Filename     =   "STNAME"
  145.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  146.       Location     =   "Header Block"
  147.       Height       =   270
  148.       Left         =   135
  149.       Top          =   555
  150.       Width        =   1230
  151. End
  152. Begin Control CNDESC
  153.       Type         =   "Text"
  154.       Style        =   0
  155.       Fieldname    =   "CNDESC"
  156.       Filename     =   "STNAME"
  157.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  158.       Location     =   "Header Block"
  159.       Height       =   270
  160.       Left         =   2430
  161.       Top          =   555
  162.       Width        =   3390
  163. End
  164. Begin Control LABEL
  165.       Type         =   "Label"
  166.       Style        =   9
  167.       Caption      =   "IF(STNAME.CNPRODTYPE="0","Description Only",IF(STNAME.CNPRODTYPE="1","Product Only","Full Stock Product"))"
  168.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  169.       Location     =   "Header Block"
  170.       Height       =   270
  171.       Left         =   2415
  172.       Top          =   825
  173.       Width        =   1485
  174. End
  175. Begin Control LABEL
  176.       Type         =   "Label"
  177.       Style        =   9
  178.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Group ID:","")"
  179.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  180.       Location     =   "Header Block"
  181.       Height       =   270
  182.       Left         =   120
  183.       Top          =   1620
  184.       Width        =   810
  185. End
  186. Begin Control LABEL
  187.       Type         =   "Label"
  188.       Style        =   9
  189.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Unit Desc.:","")"
  190.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  191.       Location     =   "Header Block"
  192.       Height       =   270
  193.       Left         =   120
  194.       Top          =   1890
  195.       Width        =   810
  196. End
  197. Begin Control LABEL
  198.       Type         =   "Label"
  199.       Style        =   9
  200.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","VAT Code:","")"
  201.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  202.       Location     =   "Header Block"
  203.       Height       =   270
  204.       Left         =   120
  205.       Top          =   2160
  206.       Width        =   810
  207. End
  208. Begin Control LABEL
  209.       Type         =   "Label"
  210.       Style        =   9
  211.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Disc. 1:","")"
  212.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  213.       Location     =   "Header Block"
  214.       Height       =   270
  215.       Left         =   2415
  216.       Top          =   1620
  217.       Width        =   540
  218. End
  219. Begin Control LABEL
  220.       Type         =   "Label"
  221.       Style        =   9
  222.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Disc. 2:","")"
  223.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  224.       Location     =   "Header Block"
  225.       Height       =   270
  226.       Left         =   2415
  227.       Top          =   1890
  228.       Width        =   540
  229. End
  230. Begin Control LABEL
  231.       Type         =   "Label"
  232.       Style        =   9
  233.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Disc. 3:","")"
  234.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  235.       Location     =   "Header Block"
  236.       Height       =   270
  237.       Left         =   2415
  238.       Top          =   2160
  239.       Width        =   540
  240. End
  241. Begin Control LABEL
  242.       Type         =   "Label"
  243.       Style        =   9
  244.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNANALHEAD,"")"
  245.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  246.       Location     =   "Header Block"
  247.       Height       =   270
  248.       Left         =   1200
  249.       Top          =   1620
  250.       Width        =   810
  251. End
  252. Begin Control LABEL
  253.       Type         =   "Label"
  254.       Style        =   9
  255.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNUNITDESC,"")"
  256.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  257.       Location     =   "Header Block"
  258.       Height       =   270
  259.       Left         =   1200
  260.       Top          =   1890
  261.       Width        =   810
  262. End
  263. Begin Control LABEL
  264.       Type         =   "Label"
  265.       Style        =   9
  266.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNVATCODE,"")"
  267.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  268.       Location     =   "Header Block"
  269.       Height       =   270
  270.       Left         =   1200
  271.       Top          =   2160
  272.       Width        =   810
  273. End
  274. Begin Control LABEL
  275.       Type         =   "Label"
  276.       Style        =   10
  277.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE1,"")"
  278.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  279.       Location     =   "Header Block"
  280.       Height       =   270
  281.       Left         =   4035
  282.       Top          =   1620
  283.       Width        =   270
  284. End
  285. Begin Control LABEL
  286.       Type         =   "Label"
  287.       Style        =   10
  288.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE2,"")"
  289.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  290.       Location     =   "Header Block"
  291.       Height       =   270
  292.       Left         =   4035
  293.       Top          =   1890
  294.       Width        =   270
  295. End
  296. Begin Control LABEL
  297.       Type         =   "Label"
  298.       Style        =   10
  299.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE3,"")"
  300.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  301.       Location     =   "Header Block"
  302.       Height       =   270
  303.       Left         =   4035
  304.       Top          =   2160
  305.       Width        =   270
  306. End
  307. Begin Control LABEL
  308.       Type         =   "Label"
  309.       Style        =   10
  310.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC1<>0,STR(STNAME.CNDISC1,5,2)+"%","")"
  311.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  312.       Location     =   "Header Block"
  313.       Height       =   270
  314.       Left         =   4575
  315.       Top          =   1620
  316.       Width        =   810
  317. End
  318. Begin Control LABEL
  319.       Type         =   "Label"
  320.       Style        =   10
  321.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC2<>0,STR(STNAME.CNDISC2,5,2)+"%","")"
  322.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  323.       Location     =   "Header Block"
  324.       Height       =   270
  325.       Left         =   4575
  326.       Top          =   1890
  327.       Width        =   810
  328. End
  329. Begin Control LABEL
  330.       Type         =   "Label"
  331.       Style        =   10
  332.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC3<>0,STR(STNAME.CNDISC3,5,2)+"%","")"
  333.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  334.       Location     =   "Header Block"
  335.       Height       =   270
  336.       Left         =   4575
  337.       Top          =   2160
  338.       Width        =   810
  339. End
  340. Begin Control LABEL
  341.       Type         =   "Label"
  342.       Style        =   9
  343.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Min. Stock:","")"
  344.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  345.       Location     =   "Header Block"
  346.       Height       =   270
  347.       Left         =   5655
  348.       Top          =   1620
  349.       Width        =   945
  350. End
  351. Begin Control LABEL
  352.       Type         =   "Label"
  353.       Style        =   9
  354.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Selling Price:","")"
  355.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  356.       Location     =   "Header Block"
  357.       Height       =   270
  358.       Left         =   2415
  359.       Top          =   2430
  360.       Width        =   1080
  361. End
  362. Begin Control LABEL
  363.       Type         =   "Label"
  364.       Style        =   10
  365.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STR(STNAME.CNSELPRICE,10,2),"")"
  366.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  367.       Location     =   "Header Block"
  368.       Height       =   270
  369.       Left         =   4575
  370.       Top          =   2430
  371.       Width        =   810
  372. End
  373. Begin Control LABEL
  374.       Type         =   "Label"
  375.       Style        =   10
  376.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNMINSTOCK,10,2),"")"
  377.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  378.       Location     =   "Header Block"
  379.       Height       =   270
  380.       Left         =   7005
  381.       Top          =   1620
  382.       Width        =   810
  383. End
  384. Begin Control LABEL
  385.       Type         =   "Label"
  386.       Style        =   9
  387.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Re-Ord Level:","")"
  388.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  389.       Location     =   "Header Block"
  390.       Height       =   270
  391.       Left         =   5655
  392.       Top          =   1350
  393.       Width        =   945
  394. End
  395. Begin Control LABEL
  396.       Type         =   "Label"
  397.       Style        =   10
  398.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNREOLEVEL,10,2),"")"
  399.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  400.       Location     =   "Header Block"
  401.       Height       =   270
  402.       Left         =   7005
  403.       Top          =   1350
  404.       Width        =   810
  405. End
  406. Begin Control LABEL
  407.       Type         =   "Label"
  408.       Style        =   9
  409.       Caption      =   "IF(STNAME.CNPRODTYPE="2","In Stock:","")"
  410.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  411.       Location     =   "Header Block"
  412.       Height       =   270
  413.       Left         =   5655
  414.       Top          =   1890
  415.       Width        =   945
  416. End
  417. Begin Control LABEL
  418.       Type         =   "Label"
  419.       Style        =   10
  420.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYINST,10,2),"")"
  421.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  422.       Location     =   "Header Block"
  423.       Height       =   270
  424.       Left         =   7005
  425.       Top          =   1890
  426.       Width        =   810
  427. End
  428. Begin Control LABEL
  429.       Type         =   "Label"
  430.       Style        =   9
  431.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Allocated:","")"
  432.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  433.       Location     =   "Header Block"
  434.       Height       =   270
  435.       Left         =   5655
  436.       Top          =   2160
  437.       Width        =   945
  438. End
  439. Begin Control LABEL
  440.       Type         =   "Label"
  441.       Style        =   10
  442.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYALLOC,10,2),"")"
  443.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  444.       Location     =   "Header Block"
  445.       Height       =   270
  446.       Left         =   7005
  447.       Top          =   2160
  448.       Width        =   810
  449. End
  450. Begin Control LABEL
  451.       Type         =   "Label"
  452.       Style        =   9
  453.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Cost Price:","")"
  454.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  455.       Location     =   "Header Block"
  456.       Height       =   270
  457.       Left         =   5655
  458.       Top          =   2430
  459.       Width        =   945
  460. End
  461. Begin Control LABEL
  462.       Type         =   "Label"
  463.       Style        =   10
  464.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNCOSPRICE,10,2),"")"
  465.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  466.       Location     =   "Header Block"
  467.       Height       =   270
  468.       Left         =   7005
  469.       Top          =   2430
  470.       Width        =   810
  471. End
  472. Begin Control LABEL
  473.       Type         =   "Label"
  474.       Style        =   9
  475.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Supplier ID:","")"
  476.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  477.       Location     =   "Header Block"
  478.       Height       =   270
  479.       Left         =   5655
  480.       Top          =   1080
  481.       Width        =   945
  482. End
  483. Begin Control LABEL
  484.       Type         =   "Label"
  485.       Style        =   10
  486.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STNAME.CNSUPPID,"")"
  487.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  488.       Location     =   "Header Block"
  489.       Height       =   270
  490.       Left         =   7005
  491.       Top          =   1080
  492.       Width        =   810
  493. End
  494. Begin Control LABEL
  495.       Type         =   "Label"
  496.       Style        =   9
  497.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Last Issued:","")"
  498.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  499.       Location     =   "Header Block"
  500.       Height       =   270
  501.       Left         =   5640
  502.       Top          =   810
  503.       Width        =   945
  504. End
  505. Begin Control LABEL
  506.       Type         =   "Label"
  507.       Style        =   10
  508.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNLASTISS<>NULLDATE,DTOC(STNAME.CNLASTISS),"")"
  509.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  510.       Location     =   "Header Block"
  511.       Height       =   270
  512.       Left         =   7005
  513.       Top          =   810
  514.       Width        =   810
  515. End
  516. Begin Control LABEL
  517.       Type         =   "Label"
  518.       Style        =   9
  519.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Location:","")"
  520.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  521.       Location     =   "Header Block"
  522.       Height       =   270
  523.       Left         =   8085
  524.       Top          =   810
  525.       Width        =   945
  526. End
  527. Begin Control LABEL
  528.       Type         =   "Label"
  529.       Style        =   10
  530.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STNAME.CNLOC),"")"
  531.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  532.       Location     =   "Header Block"
  533.       Height       =   270
  534.       Left         =   9570
  535.       Top          =   810
  536.       Width        =   810
  537. End
  538. Begin Control LABEL
  539.       Type         =   "Label"
  540.       Style        =   9
  541.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Part No.:","")"
  542.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  543.       Location     =   "Header Block"
  544.       Height       =   270
  545.       Left         =   8085
  546.       Top          =   1080
  547.       Width        =   945
  548. End
  549. Begin Control LABEL
  550.       Type         =   "Label"
  551.       Style        =   10
  552.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STNAME.CNSPARTNO),"")"
  553.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  554.       Location     =   "Header Block"
  555.       Height       =   270
  556.       Left         =   9165
  557.       Top          =   1080
  558.       Width        =   1215
  559. End
  560. Begin Control LABEL
  561.       Type         =   "Label"
  562.       Style        =   9
  563.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Free Stock:","")"
  564.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  565.       Location     =   "Header Block"
  566.       Height       =   270
  567.       Left         =   8085
  568.       Top          =   1620
  569.       Width        =   945
  570. End
  571. Begin Control LABEL
  572.       Type         =   "Label"
  573.       Style        =   10
  574.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYINST-STNAME.CNQTYALLOC,10,2),"")"
  575.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  576.       Location     =   "Header Block"
  577.       Height       =   270
  578.       Left         =   9570
  579.       Top          =   1620
  580.       Width        =   810
  581. End
  582. Begin Control LABEL
  583.       Type         =   "Label"
  584.       Style        =   9
  585.       Caption      =   "IF(STNAME.CNPRODTYPE="2","On Order:","")"
  586.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  587.       Location     =   "Header Block"
  588.       Height       =   270
  589.       Left         =   8085
  590.       Top          =   1890
  591.       Width        =   945
  592. End
  593. Begin Control LABEL
  594.       Type         =   "Label"
  595.       Style        =   10
  596.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYONORD,10,2),"")"
  597.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  598.       Location     =   "Header Block"
  599.       Height       =   270
  600.       Left         =   9570
  601.       Top          =   1890
  602.       Width        =   810
  603. End
  604. Begin Control LABEL
  605.       Type         =   "Label"
  606.       Style        =   9
  607.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Proj. Stock:","")"
  608.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  609.       Location     =   "Header Block"
  610.       Height       =   270
  611.       Left         =   8085
  612.       Top          =   2160
  613.       Width        =   945
  614. End
  615. Begin Control LABEL
  616.       Type         =   "Label"
  617.       Style        =   10
  618.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYINST+STNAME.CNQTYONORD-STNAME.CNQTYALLOC,10,2),"")"
  619.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  620.       Location     =   "Header Block"
  621.       Height       =   270
  622.       Left         =   9570
  623.       Top          =   2160
  624.       Width        =   810
  625. End
  626. Begin Control LABEL
  627.       Type         =   "Label"
  628.       Style        =   9
  629.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Re-Ord Qty:","")"
  630.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  631.       Location     =   "Header Block"
  632.       Height       =   270
  633.       Left         =   8085
  634.       Top          =   1350
  635.       Width        =   945
  636. End
  637. Begin Control LABEL
  638.       Type         =   "Label"
  639.       Style        =   10
  640.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNREOQTY,10,2),"")"
  641.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  642.       Location     =   "Header Block"
  643.       Height       =   270
  644.       Left         =   9570
  645.       Top          =   1350
  646.       Width        =   810
  647. End
  648. Begin Control LABEL
  649.       Type         =   "Label"
  650.       Style        =   9
  651.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Average Cost:","")"
  652.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  653.       Location     =   "Header Block"
  654.       Height       =   270
  655.       Left         =   8085
  656.       Top          =   2430
  657.       Width        =   945
  658. End
  659. Begin Control LABEL
  660.       Type         =   "Label"
  661.       Style        =   10
  662.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNAVGCOS,10,2),"")"
  663.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  664.       Location     =   "Header Block"
  665.       Height       =   270
  666.       Left         =   9570
  667.       Top          =   2430
  668.       Width        =   810
  669. End
  670. Begin Control LABEL
  671.       Type         =   "Label"
  672.       Style        =   9
  673.       Caption      =   "IF(STTRND.CDTYPE="3","Cost =",IF((STTRND.CDTYPE="4"|STTRND.CDTYPE="5")&STTRND.CDPRODTYPE="2","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),""),""))))"
  674.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  675.       Location     =   "Transaction Block"
  676.       Height       =   270
  677.       Left         =   5655
  678.       Top          =   30
  679.       Width        =   1620
  680. End
  681. Begin Control LABEL
  682.       Type         =   "Label"
  683.       Style        =   9
  684.       Caption      =   "IF(STTRND.CDTYPE="3",LTRIM(STR(STTRND.CDPRICE,10,2)),IF((STTRND.CDTYPE="4"|STTRND.CDTYPE="5")&STTRND.CDPRODTYPE="2",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,""))))"
  685.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  686.       Location     =   "Transaction Block"
  687.       Height       =   270
  688.       Left         =   8160
  689.       Top          =   45
  690.       Width        =   1290
  691. End
  692. Begin Control CDDOCNO
  693.       Type         =   "Text"
  694.       Style        =   0
  695.       Fieldname    =   "CDDOCNO"
  696.       Filename     =   "STTRND"
  697.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  698.       Location     =   "Transaction Block"
  699.       Height       =   270
  700.       Left         =   2415
  701.       Top          =   30
  702.       Width        =   1140
  703. End
  704. Begin Control LABEL
  705.       Type         =   "Label"
  706.       Style        =   9
  707.       Caption      =   "MID("       ReceiptIssue  Adjust Return CmPO   POrd   CmSO   SOrd   Prof   Quot   ",(INSTR("3485019BEF",STTRND.CDTYPE)*7)+1,7)"
  708.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  709.       Location     =   "Transaction Block"
  710.       Height       =   270
  711.       Left         =   120
  712.       Top          =   30
  713.       Width        =   675
  714. End
  715. Begin Control CDTXNDATE
  716.       Type         =   "Text"
  717.       Style        =   0
  718.       Fieldname    =   "CDTXNDATE"
  719.       Filename     =   "STTRND"
  720.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  721.       Location     =   "Transaction Block"
  722.       Height       =   270
  723.       Left         =   1215
  724.       Top          =   30
  725.       Width        =   870
  726. End
  727. Begin Control LABEL
  728.       Type         =   "Label"
  729.       Style        =   10
  730.       Caption      =   "IF((STTRND.CDTYPE="1"|STTRND.CDTYPE="B")&STTRND.CDQTYBAL<>0,STR(STTRND.CDQTYBAL,10,2),"")"
  731.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  732.       Location     =   "Transaction Block"
  733.       Height       =   270
  734.       Left         =   4545
  735.       Top          =   45
  736.       Width        =   870
  737. End
  738. Begin Control LABEL
  739.       Type         =   "Label"
  740.       Style        =   10
  741.       Caption      =   "IF(STTRND.CDQUANTITY<>0,STR(STTRND.CDQUANTITY,10,2),"")"
  742.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  743.       Location     =   "Transaction Block"
  744.       Height       =   270
  745.       Left         =   3495
  746.       Top          =   45
  747.       Width        =   810
  748. End
  749. Begin Control LABEL
  750.       Type         =   "Label"
  751.       Style        =   10
  752.       Caption      =   "" ""
  753.       Location     =   "Transaction Block"
  754.       Height       =   270
  755.       Left         =   9720
  756.       Top          =   45
  757.       Width        =   675
  758. End
  759. Begin Control LABEL
  760.       Type         =   "Label"
  761.       Style        =   10
  762.       Caption      =   "" ""
  763.       Location     =   "Transaction Block"
  764.       Height       =   270
  765.       Left         =   7425
  766.       Top          =   45
  767.       Width        =   405
  768. End
  769.