home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / INPROF.REP (.txt) < prev    next >
Encoding:
Visual Basic Form  |  1995-06-21  |  10.0 KB  |  292 lines
  1. VERSION 2.00
  2. Begin Report INPROF.REP
  3.       Caption      =   "INPROF.REP"
  4.       Width        =   11460
  5.       Height       =   16185
  6.       Reportheader =   1200
  7.       Header       =   1185
  8.       Transaction  =   9585
  9.       SubTotal     =   1620
  10.       Footer       =   570
  11.       Pagefooter   =   15960
  12.       Replicate    =   435
  13.       Style        =   8
  14.       Query        =   "STTRND CDTYPE="E"&CDPRODTYPE<>"0" ORDER BY CDDOCNO"
  15.       Macro        =   "1LU:Select from STTRNH where CHTRANNO=STTRND.CDTRANNO"
  16.       Macro        =   "2OF:@REPVARS.REPTOT(0) = REPTOT(0)+STTRND.CDGOODSOVR"
  17.       Macro        =   "2LU:Select from STNAME where CNPRODID=STTRND.CDPRODID"
  18.       Macro        =   "3OF:@REPVARS.REPTOT(1) = REPTOT(1)+REPTOT(0)"
  19.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  20.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  21.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  22.       BreakOn      =   "STTRND.CDTRANNO"
  23.       Special      =   "TXNRANGE(CDTRANNO,CDCREATION)"
  24. Begin Control LABEL
  25.       Type         =   "Label"
  26.       Style        =   12
  27.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  28.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  29.       Location     =   "Reportheader Block"
  30.       Height       =   270
  31.       Left         =   -15
  32.       Top          =   405
  33.       Width        =   11070
  34. Begin Control LABEL
  35.       Type         =   "Label"
  36.       Style        =   4
  37.       Caption      =   "Proformas"
  38.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  39.       Location     =   "Reportheader Block"
  40.       Height       =   420
  41.       Left         =   135
  42.       Top          =   675
  43.       Width        =   11025
  44. Begin Control LABEL
  45.       Type         =   "Label"
  46.       Style        =   9
  47.       Caption      =   "DTOC(DATE())"
  48.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  49.       Location     =   "Reportheader Block"
  50.       Height       =   285
  51.       Left         =   135
  52.       Top          =   705
  53.       Width        =   3555
  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. Begin Control LABEL
  65.       Type         =   "Label"
  66.       Style        =   1
  67.       Caption      =   "Product ID"
  68.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  69.       Location     =   "Header Block"
  70.       Height       =   285
  71.       Left         =   30
  72.       Top          =   675
  73.       Width        =   945
  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         =   1725
  82.       Top          =   675
  83.       Width        =   1110
  84. Begin Control LABEL
  85.       Type         =   "Label"
  86.       Style        =   2
  87.       Caption      =   "Quantity"
  88.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  89.       Location     =   "Header Block"
  90.       Height       =   285
  91.       Left         =   5055
  92.       Top          =   675
  93.       Width        =   780
  94. Begin Control LABEL
  95.       Type         =   "Label"
  96.       Style        =   1
  97.       Caption      =   "Unit"
  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         =   4245
  102.       Top          =   675
  103.       Width        =   510
  104. Begin Control LABEL
  105.       Type         =   "Label"
  106.       Style        =   4
  107.       Caption      =   "Value"
  108.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  109.       Location     =   "Header Block"
  110.       Height       =   285
  111.       Left         =   6360
  112.       Top          =   675
  113.       Width        =   1050
  114. Begin Control CHDOCNO
  115.       Type         =   "Text"
  116.       Style        =   0
  117.       Fieldname    =   "CHDOCNO"
  118.       Filename     =   "STTRNH"
  119.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  120.       Location     =   "Header Block"
  121.       Height       =   270
  122.       Left         =   1350
  123.       Top          =   270
  124.       Width        =   1275
  125. Begin Control LABEL
  126.       Type         =   "Label"
  127.       Style        =   1
  128.       Caption      =   "Proforma No. :"
  129.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  130.       Location     =   "Header Block"
  131.       Height       =   285
  132.       Left         =   30
  133.       Top          =   270
  134.       Width        =   1215
  135. Begin Control LABEL
  136.       Type         =   "Label"
  137.       Style        =   1
  138.       Caption      =   "Customer ID :"
  139.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  140.       Location     =   "Header Block"
  141.       Height       =   285
  142.       Left         =   2730
  143.       Top          =   270
  144.       Width        =   1080
  145. Begin Control LABEL
  146.       Type         =   "Label"
  147.       Style        =   1
  148.       Caption      =   "Date :"
  149.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  150.       Location     =   "Header Block"
  151.       Height       =   285
  152.       Left         =   5295
  153.       Top          =   270
  154.       Width        =   675
  155. Begin Control CHTXNDATE
  156.       Type         =   "Text"
  157.       Style        =   0
  158.       Fieldname    =   "CHTXNDATE"
  159.       Filename     =   "STTRNH"
  160.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  161.       Location     =   "Header Block"
  162.       Height       =   270
  163.       Left         =   6060
  164.       Top          =   270
  165.       Width        =   870
  166. Begin Control CHACCID
  167.       Type         =   "Text"
  168.       Style        =   0
  169.       Fieldname    =   "CHACCID"
  170.       Filename     =   "STTRNH"
  171.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  172.       Location     =   "Header Block"
  173.       Height       =   270
  174.       Left         =   3840
  175.       Top          =   270
  176.       Width        =   1140
  177. Begin Control LABEL
  178.       Type         =   "Label"
  179.       Style        =   1
  180.       Caption      =   "Due Date :"
  181.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  182.       Location     =   "Header Block"
  183.       Height       =   285
  184.       Left         =   7050
  185.       Top          =   270
  186.       Width        =   945
  187. Begin Control LABEL
  188.       Type         =   "Label"
  189.       Style        =   9
  190.       Caption      =   "IF(STTRNH.CHDUEDEL<>NULLDATE,DTOC(STTRNH.CHDUEDEL),"")"
  191.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  192.       Location     =   "Header Block"
  193.       Height       =   270
  194.       Left         =   8100
  195.       Top          =   270
  196.       Width        =   810
  197. Begin Control CDPRODID
  198.       Type         =   "Text"
  199.       Style        =   0
  200.       Fieldname    =   "CDPRODID"
  201.       Filename     =   "STTRND"
  202.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  203.       Location     =   "Transaction Block"
  204.       Height       =   270
  205.       Left         =   30
  206.       Top          =   165
  207.       Width        =   1230
  208. Begin Control CDDESC
  209.       Type         =   "Text"
  210.       Style        =   0
  211.       Fieldname    =   "CDDESC"
  212.       Filename     =   "STTRND"
  213.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  214.       Location     =   "Transaction Block"
  215.       Height       =   270
  216.       Left         =   1275
  217.       Top          =   165
  218.       Width        =   2760
  219. Begin Control CDQUANTITY
  220.       Type         =   "Text"
  221.       Style        =   0
  222.       Fieldname    =   "CDQUANTITY"
  223.       Filename     =   "STTRND"
  224.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  225.       Location     =   "Transaction Block"
  226.       Height       =   270
  227.       Left         =   4965
  228.       Top          =   165
  229.       Width        =   870
  230. Begin Control CNUNITDESC
  231.       Type         =   "Text"
  232.       Style        =   0
  233.       Fieldname    =   "CNUNITDESC"
  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         =   4215
  239.       Top          =   165
  240.       Width        =   510
  241. Begin Control CDGOODSOVR
  242.       Type         =   "Text"
  243.       Style        =   0
  244.       Fieldname    =   "CDGOODSOVR"
  245.       Filename     =   "STTRND"
  246.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  247.       Location     =   "Transaction Block"
  248.       Height       =   270
  249.       Left         =   6315
  250.       Top          =   165
  251.       Width        =   870
  252. Begin Control LABEL
  253.       Type         =   "Label"
  254.       Style        =   9
  255.       Caption      =   ""Total Value for Proforma = ""
  256.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  257.       Location     =   "Subtotal Block"
  258.       Height       =   270
  259.       Left         =   4230
  260.       Top          =   570
  261.       Width        =   2025
  262. Begin Control LABEL
  263.       Type         =   "Label"
  264.       Style        =   10
  265.       Caption      =   "STR(REPTOT(0),10,2)"
  266.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  267.       Location     =   "Subtotal Block"
  268.       Height       =   270
  269.       Left         =   6315
  270.       Top          =   570
  271.       Width        =   870
  272. Begin Control LABEL
  273.       Type         =   "Label"
  274.       Style        =   9
  275.       Caption      =   ""Total Value  = ""
  276.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  277.       Location     =   "Footer Block"
  278.       Height       =   270
  279.       Left         =   4230
  280.       Top          =   300
  281.       Width        =   2025
  282. Begin Control LABEL
  283.       Type         =   "Label"
  284.       Style        =   10
  285.       Caption      =   "STR(REPTOT(1),10,2)"
  286.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  287.       Location     =   "Footer Block"
  288.       Height       =   270
  289.       Left         =   6315
  290.       Top          =   300
  291.       Width        =   870
  292.