home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / INPROF.REP < prev    next >
Text File  |  1996-03-06  |  10KB  |  319 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. End
  25. Begin Control LABEL
  26.       Type         =   "Label"
  27.       Style        =   12
  28.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  29.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  30.       Location     =   "Reportheader Block"
  31.       Height       =   270
  32.       Left         =   -15
  33.       Top          =   405
  34.       Width        =   11070
  35. End
  36. Begin Control LABEL
  37.       Type         =   "Label"
  38.       Style        =   4
  39.       Caption      =   "Proformas"
  40.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  41.       Location     =   "Reportheader Block"
  42.       Height       =   420
  43.       Left         =   135
  44.       Top          =   675
  45.       Width        =   11025
  46. End
  47. Begin Control LABEL
  48.       Type         =   "Label"
  49.       Style        =   9
  50.       Caption      =   "DTOC(DATE())"
  51.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  52.       Location     =   "Reportheader Block"
  53.       Height       =   285
  54.       Left         =   135
  55.       Top          =   705
  56.       Width        =   3555
  57. End
  58. Begin Control LABEL
  59.       Type         =   "Label"
  60.       Style        =   10
  61.       Caption      =   ""Page: "+PAGENUM()"
  62.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  63.       Location     =   "Reportheader Block"
  64.       Height       =   285
  65.       Left         =   9585
  66.       Top          =   720
  67.       Width        =   1395
  68. End
  69. Begin Control LABEL
  70.       Type         =   "Label"
  71.       Style        =   1
  72.       Caption      =   "Product ID"
  73.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  74.       Location     =   "Header Block"
  75.       Height       =   285
  76.       Left         =   30
  77.       Top          =   675
  78.       Width        =   945
  79. End
  80. Begin Control LABEL
  81.       Type         =   "Label"
  82.       Style        =   1
  83.       Caption      =   "Description"
  84.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  85.       Location     =   "Header Block"
  86.       Height       =   285
  87.       Left         =   2670
  88.       Top          =   675
  89.       Width        =   1110
  90. End
  91. Begin Control LABEL
  92.       Type         =   "Label"
  93.       Style        =   2
  94.       Caption      =   "Quantity"
  95.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  96.       Location     =   "Header Block"
  97.       Height       =   285
  98.       Left         =   6135
  99.       Top          =   675
  100.       Width        =   780
  101. End
  102. Begin Control LABEL
  103.       Type         =   "Label"
  104.       Style        =   1
  105.       Caption      =   "Unit"
  106.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  107.       Location     =   "Header Block"
  108.       Height       =   285
  109.       Left         =   5460
  110.       Top          =   675
  111.       Width        =   510
  112. End
  113. Begin Control LABEL
  114.       Type         =   "Label"
  115.       Style        =   4
  116.       Caption      =   "Value"
  117.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  118.       Location     =   "Header Block"
  119.       Height       =   285
  120.       Left         =   7305
  121.       Top          =   675
  122.       Width        =   1050
  123. End
  124. Begin Control CHDOCNO
  125.       Type         =   "Text"
  126.       Style        =   0
  127.       Fieldname    =   "CHDOCNO"
  128.       Filename     =   "STTRNH"
  129.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  130.       Location     =   "Header Block"
  131.       Height       =   270
  132.       Left         =   1350
  133.       Top          =   270
  134.       Width        =   1275
  135. End
  136. Begin Control LABEL
  137.       Type         =   "Label"
  138.       Style        =   1
  139.       Caption      =   "Proforma No. :"
  140.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  141.       Location     =   "Header Block"
  142.       Height       =   285
  143.       Left         =   30
  144.       Top          =   270
  145.       Width        =   1215
  146. End
  147. Begin Control LABEL
  148.       Type         =   "Label"
  149.       Style        =   1
  150.       Caption      =   "Customer ID :"
  151.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  152.       Location     =   "Header Block"
  153.       Height       =   285
  154.       Left         =   2730
  155.       Top          =   270
  156.       Width        =   1080
  157. End
  158. Begin Control LABEL
  159.       Type         =   "Label"
  160.       Style        =   1
  161.       Caption      =   "Date :"
  162.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  163.       Location     =   "Header Block"
  164.       Height       =   285
  165.       Left         =   5295
  166.       Top          =   270
  167.       Width        =   675
  168. End
  169. Begin Control CHTXNDATE
  170.       Type         =   "Text"
  171.       Style        =   0
  172.       Fieldname    =   "CHTXNDATE"
  173.       Filename     =   "STTRNH"
  174.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  175.       Location     =   "Header Block"
  176.       Height       =   270
  177.       Left         =   6060
  178.       Top          =   270
  179.       Width        =   870
  180. End
  181. Begin Control CHACCID
  182.       Type         =   "Text"
  183.       Style        =   0
  184.       Fieldname    =   "CHACCID"
  185.       Filename     =   "STTRNH"
  186.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  187.       Location     =   "Header Block"
  188.       Height       =   270
  189.       Left         =   3840
  190.       Top          =   270
  191.       Width        =   1140
  192. End
  193. Begin Control LABEL
  194.       Type         =   "Label"
  195.       Style        =   1
  196.       Caption      =   "Due Date :"
  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         =   7050
  201.       Top          =   270
  202.       Width        =   945
  203. End
  204. Begin Control LABEL
  205.       Type         =   "Label"
  206.       Style        =   9
  207.       Caption      =   "IF(STTRNH.CHDUEDEL<>NULLDATE,DTOC(STTRNH.CHDUEDEL),"")"
  208.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  209.       Location     =   "Header Block"
  210.       Height       =   270
  211.       Left         =   8100
  212.       Top          =   270
  213.       Width        =   810
  214. End
  215. Begin Control CDPRODID
  216.       Type         =   "Text"
  217.       Style        =   0
  218.       Fieldname    =   "CDPRODID"
  219.       Filename     =   "STTRND"
  220.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  221.       Location     =   "Transaction Block"
  222.       Height       =   270
  223.       Left         =   30
  224.       Top          =   165
  225.       Width        =   1905
  226. End
  227. Begin Control CDDESC
  228.       Type         =   "Text"
  229.       Style        =   0
  230.       Fieldname    =   "CDDESC"
  231.       Filename     =   "STTRND"
  232.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  233.       Location     =   "Transaction Block"
  234.       Height       =   270
  235.       Left         =   2355
  236.       Top          =   165
  237.       Width        =   2760
  238. End
  239. Begin Control CDQUANTITY
  240.       Type         =   "Text"
  241.       Style        =   0
  242.       Fieldname    =   "CDQUANTITY"
  243.       Filename     =   "STTRND"
  244.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  245.       Location     =   "Transaction Block"
  246.       Height       =   270
  247.       Left         =   6180
  248.       Top          =   165
  249.       Width        =   870
  250. End
  251. Begin Control CNUNITDESC
  252.       Type         =   "Text"
  253.       Style        =   0
  254.       Fieldname    =   "CNUNITDESC"
  255.       Filename     =   "STNAME"
  256.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  257.       Location     =   "Transaction Block"
  258.       Height       =   270
  259.       Left         =   5430
  260.       Top          =   165
  261.       Width        =   510
  262. End
  263. Begin Control CDGOODSOVR
  264.       Type         =   "Text"
  265.       Style        =   0
  266.       Fieldname    =   "CDGOODSOVR"
  267.       Filename     =   "STTRND"
  268.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  269.       Location     =   "Transaction Block"
  270.       Height       =   270
  271.       Left         =   7260
  272.       Top          =   165
  273.       Width        =   870
  274. End
  275. Begin Control LABEL
  276.       Type         =   "Label"
  277.       Style        =   9
  278.       Caption      =   ""Total Value for Proforma = ""
  279.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  280.       Location     =   "Subtotal Block"
  281.       Height       =   270
  282.       Left         =   5175
  283.       Top          =   570
  284.       Width        =   2025
  285. End
  286. Begin Control LABEL
  287.       Type         =   "Label"
  288.       Style        =   10
  289.       Caption      =   "STR(REPTOT(0),10,2)"
  290.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  291.       Location     =   "Subtotal Block"
  292.       Height       =   270
  293.       Left         =   7260
  294.       Top          =   570
  295.       Width        =   870
  296. End
  297. Begin Control LABEL
  298.       Type         =   "Label"
  299.       Style        =   9
  300.       Caption      =   ""Total Value  = ""
  301.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  302.       Location     =   "Footer Block"
  303.       Height       =   270
  304.       Left         =   5175
  305.       Top          =   300
  306.       Width        =   2025
  307. End
  308. Begin Control LABEL
  309.       Type         =   "Label"
  310.       Style        =   10
  311.       Caption      =   "STR(REPTOT(1),10,2)"
  312.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  313.       Location     =   "Footer Block"
  314.       Height       =   270
  315.       Left         =   7260
  316.       Top          =   300
  317.       Width        =   870
  318. End
  319.