home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / INUNIN.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  9.2 KB  |  295 lines
  1. VERSION 2.00
  2. Begin Report INUNIN.REP
  3.       Caption      =   "INUNIN.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        =   "STTRNH CHTYPE="4" & CHSTATUS<>"2" ORDER BY CHDOCNO"
  15.       Macro        =   "2SQ:Select from STTRND where CDTRANNO=STTRNH.CHTRANNO & CDPRODTYPE<>"0""
  16.       Macro        =   "2PP:@REPVARS.REPTOT(0) = REPTOT(0)+STTRND.CDGOODSOVR"
  17.       Macro        =   "3OF:@REPVARS.REPTOT(1) = REPTOT(1)+REPTOT(0)"
  18.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  19.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  20.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  21.       BreakOn      =   "STTRNH.CHTRANNO"
  22.       Special      =   "TXNRANGE(CHTRANNO,CHCREATION)"
  23. End
  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. End
  35. Begin Control LABEL
  36.       Type         =   "Label"
  37.       Style        =   4
  38.       Caption      =   "Uninvoiced Released Sales Orders"
  39.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  40.       Location     =   "Reportheader Block"
  41.       Height       =   420
  42.       Left         =   135
  43.       Top          =   675
  44.       Width        =   11025
  45. End
  46. Begin Control LABEL
  47.       Type         =   "Label"
  48.       Style        =   9
  49.       Caption      =   "DTOC(DATE())"
  50.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  51.       Location     =   "Reportheader Block"
  52.       Height       =   285
  53.       Left         =   135
  54.       Top          =   705
  55.       Width        =   3015
  56. End
  57. Begin Control LABEL
  58.       Type         =   "Label"
  59.       Style        =   10
  60.       Caption      =   ""Page: "+PAGENUM()"
  61.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  62.       Location     =   "Reportheader Block"
  63.       Height       =   285
  64.       Left         =   9585
  65.       Top          =   720
  66.       Width        =   1395
  67. End
  68. Begin Control LABEL
  69.       Type         =   "Label"
  70.       Style        =   1
  71.       Caption      =   "Product ID"
  72.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  73.       Location     =   "Header Block"
  74.       Height       =   285
  75.       Left         =   30
  76.       Top          =   675
  77.       Width        =   945
  78. End
  79. Begin Control LABEL
  80.       Type         =   "Label"
  81.       Style        =   1
  82.       Caption      =   "Description"
  83.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  84.       Location     =   "Header Block"
  85.       Height       =   285
  86.       Left         =   1725
  87.       Top          =   675
  88.       Width        =   1110
  89. End
  90. Begin Control LABEL
  91.       Type         =   "Label"
  92.       Style        =   2
  93.       Caption      =   "Quantity"
  94.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  95.       Location     =   "Header Block"
  96.       Height       =   285
  97.       Left         =   5055
  98.       Top          =   675
  99.       Width        =   780
  100. End
  101. Begin Control LABEL
  102.       Type         =   "Label"
  103.       Style        =   4
  104.       Caption      =   "Value"
  105.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  106.       Location     =   "Header Block"
  107.       Height       =   285
  108.       Left         =   6360
  109.       Top          =   675
  110.       Width        =   1050
  111. End
  112. Begin Control CHDOCNO
  113.       Type         =   "Text"
  114.       Style        =   0
  115.       Fieldname    =   "CHDOCNO"
  116.       Filename     =   "STTRNH"
  117.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  118.       Location     =   "Header Block"
  119.       Height       =   270
  120.       Left         =   1080
  121.       Top          =   270
  122.       Width        =   1275
  123. End
  124. Begin Control LABEL
  125.       Type         =   "Label"
  126.       Style        =   1
  127.       Caption      =   "Order No. :"
  128.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  129.       Location     =   "Header Block"
  130.       Height       =   285
  131.       Left         =   30
  132.       Top          =   270
  133.       Width        =   945
  134. End
  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         =   2460
  143.       Top          =   270
  144.       Width        =   1080
  145. End
  146. Begin Control LABEL
  147.       Type         =   "Label"
  148.       Style        =   10
  149.       Caption      =   ""Invoice Date : ""
  150.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  151.       Location     =   "Header Block"
  152.       Height       =   285
  153.       Left         =   4890
  154.       Top          =   270
  155.       Width        =   1080
  156. End
  157. Begin Control CHTXNDATE
  158.       Type         =   "Text"
  159.       Style        =   0
  160.       Fieldname    =   "CHTXNDATE"
  161.       Filename     =   "STTRNH"
  162.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  163.       Location     =   "Header Block"
  164.       Height       =   270
  165.       Left         =   6060
  166.       Top          =   270
  167.       Width        =   870
  168. End
  169. Begin Control CHACCID
  170.       Type         =   "Text"
  171.       Style        =   0
  172.       Fieldname    =   "CHACCID"
  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         =   3570
  178.       Top          =   270
  179.       Width        =   1140
  180. End
  181. Begin Control LABEL
  182.       Type         =   "Label"
  183.       Style        =   10
  184.       Caption      =   ""Due Date : ""
  185.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  186.       Location     =   "Header Block"
  187.       Height       =   285
  188.       Left         =   7050
  189.       Top          =   270
  190.       Width        =   945
  191. End
  192. Begin Control LABEL
  193.       Type         =   "Label"
  194.       Style        =   9
  195.       Caption      =   "IF(STTRNH.CHDUEDEL<>NULLDATE,DTOC(STTRNH.CHDUEDEL),"")"
  196.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  197.       Location     =   "Header Block"
  198.       Height       =   270
  199.       Left         =   8100
  200.       Top          =   270
  201.       Width        =   810
  202. End
  203. Begin Control CDPRODID
  204.       Type         =   "Text"
  205.       Style        =   0
  206.       Fieldname    =   "CDPRODID"
  207.       Filename     =   "STTRND"
  208.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  209.       Location     =   "Transaction Block"
  210.       Height       =   270
  211.       Left         =   30
  212.       Top          =   165
  213.       Width        =   1230
  214. End
  215. Begin Control CDDESC
  216.       Type         =   "Text"
  217.       Style        =   0
  218.       Fieldname    =   "CDDESC"
  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         =   1275
  224.       Top          =   165
  225.       Width        =   3435
  226. End
  227. Begin Control CDQUANTITY
  228.       Type         =   "Text"
  229.       Style        =   0
  230.       Fieldname    =   "CDQUANTITY"
  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         =   4965
  236.       Top          =   165
  237.       Width        =   870
  238. End
  239. Begin Control CDGOODSOVR
  240.       Type         =   "Text"
  241.       Style        =   0
  242.       Fieldname    =   "CDGOODSOVR"
  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         =   6315
  248.       Top          =   165
  249.       Width        =   870
  250. End
  251. Begin Control LABEL
  252.       Type         =   "Label"
  253.       Style        =   9
  254.       Caption      =   ""Total Value for Order = ""
  255.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  256.       Location     =   "Subtotal Block"
  257.       Height       =   270
  258.       Left         =   4500
  259.       Top          =   570
  260.       Width        =   1755
  261. End
  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. End
  273. Begin Control LABEL
  274.       Type         =   "Label"
  275.       Style        =   9
  276.       Caption      =   ""Total Value  = ""
  277.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  278.       Location     =   "Footer Block"
  279.       Height       =   270
  280.       Left         =   4500
  281.       Top          =   300
  282.       Width        =   1755
  283. End
  284. Begin Control LABEL
  285.       Type         =   "Label"
  286.       Style        =   10
  287.       Caption      =   "STR(REPTOT(1),10,2)"
  288.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  289.       Location     =   "Footer Block"
  290.       Height       =   270
  291.       Left         =   6315
  292.       Top          =   300
  293.       Width        =   870
  294. End
  295.