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