home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / STISSUEH.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  17.1 KB  |  561 lines
  1. VERSION 2.00
  2. Begin Report STISSUEH.REP
  3.       Caption      =   "STISSUEH.REP"
  4.       Width        =   11460
  5.       Height       =   16185
  6.       Reportheader =   1200
  7.       Header       =   1920
  8.       Transaction  =   8895
  9.       SubTotal     =   225
  10.       Footer       =   0
  11.       Pagefooter   =   15960
  12.       Replicate    =   375
  13.       Style        =   8
  14.       Query        =   "STNAME CNPRODTYPE<>"0" ORDER BY CNPRODID"
  15.       Macro        =   "2OF:@REPVARS.REPTOT(0) = ((STNAME.CNQTYISS0*STNAME.CNSELPRICE)-(STNAME.CNQTYISS0*STNAME.CNAVGCOS))"
  16.       Macro        =   "2PP:@REPVARS.REPTOT(0) = 0"
  17.       BreakOn      =   "STNAME.CNPRODID"
  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      =   "Issues History"
  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         =   30
  71.       Top          =   405
  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         =   1590
  82.       Top          =   405
  83.       Width        =   1785
  84. End
  85. Begin Control LABEL
  86.       Type         =   "Label"
  87.       Style        =   4
  88.       Caption      =   "This"
  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         =   255
  93.       Top          =   1350
  94.       Width        =   870
  95. End
  96. Begin Control LABEL
  97.       Type         =   "Label"
  98.       Style        =   4
  99.       Caption      =   "Period"
  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         =   255
  104.       Top          =   1620
  105.       Width        =   870
  106. End
  107. Begin Control CNPRODID
  108.       Type         =   "Text"
  109.       Style        =   0
  110.       Fieldname    =   "CNPRODID"
  111.       Filename     =   "STNAME"
  112.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  113.       Location     =   "Header Block"
  114.       Height       =   270
  115.       Left         =   30
  116.       Top          =   810
  117.       Width        =   1230
  118. End
  119. Begin Control CNDESC
  120.       Type         =   "Text"
  121.       Style        =   0
  122.       Fieldname    =   "CNDESC"
  123.       Filename     =   "STNAME"
  124.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  125.       Location     =   "Header Block"
  126.       Height       =   270
  127.       Left         =   1425
  128.       Top          =   810
  129.       Width        =   3030
  130. End
  131. Begin Control LABEL
  132.       Type         =   "Label"
  133.       Style        =   4
  134.       Caption      =   "Period"
  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         =   1125
  139.       Top          =   1620
  140.       Width        =   870
  141. End
  142. Begin Control LABEL
  143.       Type         =   "Label"
  144.       Style        =   4
  145.       Caption      =   "Last"
  146.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  147.       Location     =   "Header Block"
  148.       Height       =   285
  149.       Left         =   1125
  150.       Top          =   1350
  151.       Width        =   870
  152. End
  153. Begin Control LABEL
  154.       Type         =   "Label"
  155.       Style        =   4
  156.       Caption      =   "Periods"
  157.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  158.       Location     =   "Header Block"
  159.       Height       =   285
  160.       Left         =   1995
  161.       Top          =   1620
  162.       Width        =   870
  163. End
  164. Begin Control LABEL
  165.       Type         =   "Label"
  166.       Style        =   4
  167.       Caption      =   "2"
  168.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  169.       Location     =   "Header Block"
  170.       Height       =   285
  171.       Left         =   1995
  172.       Top          =   1350
  173.       Width        =   870
  174. End
  175. Begin Control LABEL
  176.       Type         =   "Label"
  177.       Style        =   4
  178.       Caption      =   "Periods"
  179.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  180.       Location     =   "Header Block"
  181.       Height       =   285
  182.       Left         =   2865
  183.       Top          =   1620
  184.       Width        =   870
  185. End
  186. Begin Control LABEL
  187.       Type         =   "Label"
  188.       Style        =   4
  189.       Caption      =   "3"
  190.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  191.       Location     =   "Header Block"
  192.       Height       =   285
  193.       Left         =   2865
  194.       Top          =   1350
  195.       Width        =   870
  196. End
  197. Begin Control LABEL
  198.       Type         =   "Label"
  199.       Style        =   4
  200.       Caption      =   "Periods"
  201.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  202.       Location     =   "Header Block"
  203.       Height       =   285
  204.       Left         =   3735
  205.       Top          =   1620
  206.       Width        =   870
  207. End
  208. Begin Control LABEL
  209.       Type         =   "Label"
  210.       Style        =   4
  211.       Caption      =   "4"
  212.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  213.       Location     =   "Header Block"
  214.       Height       =   285
  215.       Left         =   3735
  216.       Top          =   1350
  217.       Width        =   870
  218. End
  219. Begin Control LABEL
  220.       Type         =   "Label"
  221.       Style        =   4
  222.       Caption      =   "Periods"
  223.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  224.       Location     =   "Header Block"
  225.       Height       =   285
  226.       Left         =   4605
  227.       Top          =   1620
  228.       Width        =   870
  229. End
  230. Begin Control LABEL
  231.       Type         =   "Label"
  232.       Style        =   4
  233.       Caption      =   "Periods"
  234.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  235.       Location     =   "Header Block"
  236.       Height       =   285
  237.       Left         =   5475
  238.       Top          =   1620
  239.       Width        =   870
  240. End
  241. Begin Control LABEL
  242.       Type         =   "Label"
  243.       Style        =   4
  244.       Caption      =   "Periods"
  245.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  246.       Location     =   "Header Block"
  247.       Height       =   285
  248.       Left         =   6345
  249.       Top          =   1620
  250.       Width        =   870
  251. End
  252. Begin Control LABEL
  253.       Type         =   "Label"
  254.       Style        =   4
  255.       Caption      =   "Periods"
  256.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  257.       Location     =   "Header Block"
  258.       Height       =   285
  259.       Left         =   7215
  260.       Top          =   1620
  261.       Width        =   870
  262. End
  263. Begin Control LABEL
  264.       Type         =   "Label"
  265.       Style        =   4
  266.       Caption      =   "Periods"
  267.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  268.       Location     =   "Header Block"
  269.       Height       =   285
  270.       Left         =   8085
  271.       Top          =   1620
  272.       Width        =   870
  273. End
  274. Begin Control LABEL
  275.       Type         =   "Label"
  276.       Style        =   4
  277.       Caption      =   "Periods"
  278.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  279.       Location     =   "Header Block"
  280.       Height       =   285
  281.       Left         =   8955
  282.       Top          =   1620
  283.       Width        =   870
  284. End
  285. Begin Control LABEL
  286.       Type         =   "Label"
  287.       Style        =   4
  288.       Caption      =   "Periods"
  289.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  290.       Location     =   "Header Block"
  291.       Height       =   285
  292.       Left         =   9825
  293.       Top          =   1620
  294.       Width        =   870
  295. End
  296. Begin Control LABEL
  297.       Type         =   "Label"
  298.       Style        =   4
  299.       Caption      =   "5"
  300.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  301.       Location     =   "Header Block"
  302.       Height       =   285
  303.       Left         =   4605
  304.       Top          =   1350
  305.       Width        =   870
  306. End
  307. Begin Control LABEL
  308.       Type         =   "Label"
  309.       Style        =   4
  310.       Caption      =   "6"
  311.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  312.       Location     =   "Header Block"
  313.       Height       =   285
  314.       Left         =   5475
  315.       Top          =   1350
  316.       Width        =   870
  317. End
  318. Begin Control LABEL
  319.       Type         =   "Label"
  320.       Style        =   4
  321.       Caption      =   "7"
  322.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  323.       Location     =   "Header Block"
  324.       Height       =   285
  325.       Left         =   6345
  326.       Top          =   1350
  327.       Width        =   870
  328. End
  329. Begin Control LABEL
  330.       Type         =   "Label"
  331.       Style        =   4
  332.       Caption      =   "8"
  333.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  334.       Location     =   "Header Block"
  335.       Height       =   285
  336.       Left         =   7215
  337.       Top          =   1350
  338.       Width        =   870
  339. End
  340. Begin Control LABEL
  341.       Type         =   "Label"
  342.       Style        =   4
  343.       Caption      =   "9"
  344.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  345.       Location     =   "Header Block"
  346.       Height       =   285
  347.       Left         =   8085
  348.       Top          =   1350
  349.       Width        =   870
  350. End
  351. Begin Control LABEL
  352.       Type         =   "Label"
  353.       Style        =   4
  354.       Caption      =   "10"
  355.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  356.       Location     =   "Header Block"
  357.       Height       =   285
  358.       Left         =   8955
  359.       Top          =   1350
  360.       Width        =   870
  361. End
  362. Begin Control LABEL
  363.       Type         =   "Label"
  364.       Style        =   4
  365.       Caption      =   "11"
  366.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  367.       Location     =   "Header Block"
  368.       Height       =   285
  369.       Left         =   9825
  370.       Top          =   1350
  371.       Width        =   870
  372. End
  373. Begin Control LABEL
  374.       Type         =   "Label"
  375.       Style        =   10
  376.       Caption      =   "IF(STNAME.CNLASTISS<>NULLDATE,DTOC(STNAME.CNLASTISS),"")"
  377.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  378.       Location     =   "Header Block"
  379.       Height       =   285
  380.       Left         =   7425
  381.       Top          =   810
  382.       Width        =   810
  383. End
  384. Begin Control LABEL
  385.       Type         =   "Label"
  386.       Style        =   1
  387.       Caption      =   "Last Issued:"
  388.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  389.       Location     =   "Header Block"
  390.       Height       =   285
  391.       Left         =   6480
  392.       Top          =   810
  393.       Width        =   945
  394. End
  395. Begin Control LABEL
  396.       Type         =   "Label"
  397.       Style        =   9
  398.       Caption      =   "IF(STNAME.CNPRODTYPE="0","Description Only",IF(STNAME.CNPRODTYPE="1","Product Only","Full Stock Product"))"
  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         =   4590
  403.       Top          =   810
  404.       Width        =   1620
  405. End
  406. Begin Control LABEL
  407.       Type         =   "Label"
  408.       Style        =   1
  409.       Caption      =   "Product Type"
  410.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  411.       Location     =   "Header Block"
  412.       Height       =   285
  413.       Left         =   4695
  414.       Top          =   405
  415.       Width        =   1245
  416. End
  417. Begin Control CNQTYISS0
  418.       Type         =   "Text"
  419.       Style        =   0
  420.       Fieldname    =   "CNQTYISS0"
  421.       Filename     =   "STNAME"
  422.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  423.       Location     =   "Transaction Block"
  424.       Height       =   270
  425.       Left         =   120
  426.       Top          =   105
  427.       Width        =   870
  428. End
  429. Begin Control CNQTYISS1
  430.       Type         =   "Text"
  431.       Style        =   0
  432.       Fieldname    =   "CNQTYISS1"
  433.       Filename     =   "STNAME"
  434.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  435.       Location     =   "Transaction Block"
  436.       Height       =   270
  437.       Left         =   990
  438.       Top          =   105
  439.       Width        =   870
  440. End
  441. Begin Control CNQTYISS2
  442.       Type         =   "Text"
  443.       Style        =   0
  444.       Fieldname    =   "CNQTYISS2"
  445.       Filename     =   "STNAME"
  446.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  447.       Location     =   "Transaction Block"
  448.       Height       =   270
  449.       Left         =   1860
  450.       Top          =   105
  451.       Width        =   870
  452. End
  453. Begin Control CNQTYISS3
  454.       Type         =   "Text"
  455.       Style        =   0
  456.       Fieldname    =   "CNQTYISS3"
  457.       Filename     =   "STNAME"
  458.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  459.       Location     =   "Transaction Block"
  460.       Height       =   270
  461.       Left         =   2730
  462.       Top          =   105
  463.       Width        =   870
  464. End
  465. Begin Control CNQTYISS4
  466.       Type         =   "Text"
  467.       Style        =   0
  468.       Fieldname    =   "CNQTYISS4"
  469.       Filename     =   "STNAME"
  470.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  471.       Location     =   "Transaction Block"
  472.       Height       =   270
  473.       Left         =   3600
  474.       Top          =   105
  475.       Width        =   870
  476. End
  477. Begin Control CNQTYISS5
  478.       Type         =   "Text"
  479.       Style        =   0
  480.       Fieldname    =   "CNQTYISS5"
  481.       Filename     =   "STNAME"
  482.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  483.       Location     =   "Transaction Block"
  484.       Height       =   270
  485.       Left         =   4470
  486.       Top          =   105
  487.       Width        =   870
  488. End
  489. Begin Control CNQTYISS6
  490.       Type         =   "Text"
  491.       Style        =   0
  492.       Fieldname    =   "CNQTYISS6"
  493.       Filename     =   "STNAME"
  494.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  495.       Location     =   "Transaction Block"
  496.       Height       =   270
  497.       Left         =   5340
  498.       Top          =   105
  499.       Width        =   870
  500. End
  501. Begin Control CNQTYISS7
  502.       Type         =   "Text"
  503.       Style        =   0
  504.       Fieldname    =   "CNQTYISS7"
  505.       Filename     =   "STNAME"
  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         =   6210
  510.       Top          =   105
  511.       Width        =   870
  512. End
  513. Begin Control CNQTYISS8
  514.       Type         =   "Text"
  515.       Style        =   0
  516.       Fieldname    =   "CNQTYISS8"
  517.       Filename     =   "STNAME"
  518.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  519.       Location     =   "Transaction Block"
  520.       Height       =   270
  521.       Left         =   7080
  522.       Top          =   105
  523.       Width        =   870
  524. End
  525. Begin Control CNQTYISS9
  526.       Type         =   "Text"
  527.       Style        =   0
  528.       Fieldname    =   "CNQTYISS9"
  529.       Filename     =   "STNAME"
  530.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  531.       Location     =   "Transaction Block"
  532.       Height       =   270
  533.       Left         =   7950
  534.       Top          =   105
  535.       Width        =   870
  536. End
  537. Begin Control CNQTYISS10
  538.       Type         =   "Text"
  539.       Style        =   0
  540.       Fieldname    =   "CNQTYISS10"
  541.       Filename     =   "STNAME"
  542.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  543.       Location     =   "Transaction Block"
  544.       Height       =   270
  545.       Left         =   8820
  546.       Top          =   105
  547.       Width        =   870
  548. End
  549. Begin Control CNQTYISS11
  550.       Type         =   "Text"
  551.       Style        =   0
  552.       Fieldname    =   "CNQTYISS11"
  553.       Filename     =   "STNAME"
  554.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  555.       Location     =   "Transaction Block"
  556.       Height       =   270
  557.       Left         =   9690
  558.       Top          =   105
  559.       Width        =   870
  560. End
  561.