home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / NLBNKENQ.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  8.3 KB  |  260 lines
  1. VERSION 2.00
  2. Begin Report NLBNKENQ.REP
  3.       Caption      =   "NLBNKENQ.REP"
  4.       Width        =   11175
  5.       Height       =   16395
  6.       Reportheader =   795
  7.       Header       =   1080
  8.       Transaction  =   3165
  9.       SubTotal     =   3150
  10.       Footer       =   0
  11.       Pagefooter   =   15690
  12.       Replicate    =   435
  13.       Style        =   1
  14.       Query        =   "NLTRAN NTCODE=^@0 ORDER BY NTTXNDATE"
  15.       Macro        =   "1OF:@REPVARS.REPTOT(0) = 0"
  16.       Macro        =   "1LU:Select from NLNAME where NNACCOUNT=NLTRAN.NTCODE"
  17.       Macro        =   "2CD:When NLTRAN.NTVALUE>0 then REPTOT(1)=REPTOT(1)+NLTRAN.NTVALUE"
  18.       Macro        =   "2CD:When NLTRAN.NTVALUE<0 then REPTOT(2)=REPTOT(2)-NLTRAN.NTVALUE"
  19.       Macro        =   "2OF:@REPVARS.REPTOT(0) = REPTOT(0)+NLTRAN.NTVALUE"
  20.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  21.       Macro        =   "3PP:@REPVARS.REPTOT(1) = 0"
  22.       Macro        =   "3PP:@REPVARS.REPTOT(2) = 0"
  23.       Special      =   "TXNRANGE(NTENTRYNO,NTPOSTDATE)"
  24. End
  25. Begin Control LABEL
  26.       Type         =   "Label"
  27.       Style        =   4
  28.       Caption      =   "Bank Account Enquiry"
  29.       Font         =   "-315|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  30.       Location     =   "Reportheader Block"
  31.       Height       =   420
  32.       Left         =   135
  33.       Top          =   540
  34.       Width        =   10890
  35. End
  36. Begin Control LABEL
  37.       Type         =   "Label"
  38.       Style        =   9
  39.       Caption      =   "DTOC(DATE())"
  40.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  41.       Location     =   "Reportheader Block"
  42.       Height       =   285
  43.       Left         =   135
  44.       Top          =   720
  45.       Width        =   3555
  46. End
  47. Begin Control LABEL
  48.       Type         =   "Label"
  49.       Style        =   10
  50.       Caption      =   ""Page "+PAGENUM()"
  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         =   9210
  55.       Top          =   705
  56.       Width        =   1800
  57. End
  58. Begin Control LABEL
  59.       Type         =   "Label"
  60.       Style        =   12
  61.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  62.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  63.       Location     =   "Reportheader Block"
  64.       Height       =   420
  65.       Left         =   135
  66.       Top          =   135
  67.       Width        =   10890
  68. End
  69. Begin Control LABEL
  70.       Type         =   "Label"
  71.       Style        =   1
  72.       Caption      =   "Date"
  73.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  74.       Location     =   "Header Block"
  75.       Height       =   285
  76.       Left         =   135
  77.       Top          =   960
  78.       Width        =   1140
  79. End
  80. Begin Control LABEL
  81.       Type         =   "Label"
  82.       Style        =   1
  83.       Caption      =   "Reference"
  84.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  85.       Location     =   "Header Block"
  86.       Height       =   285
  87.       Left         =   1575
  88.       Top          =   960
  89.       Width        =   1140
  90. End
  91. Begin Control LABEL
  92.       Type         =   "Label"
  93.       Style        =   2
  94.       Caption      =   "Payments"
  95.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  96.       Location     =   "Header Block"
  97.       Height       =   285
  98.       Left         =   5835
  99.       Top          =   960
  100.       Width        =   1410
  101. End
  102. Begin Control LABEL
  103.       Type         =   "Label"
  104.       Style        =   2
  105.       Caption      =   "Balance"
  106.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  107.       Location     =   "Header Block"
  108.       Height       =   285
  109.       Left         =   9030
  110.       Top          =   960
  111.       Width        =   1275
  112. End
  113. Begin Control LABEL
  114.       Type         =   "Label"
  115.       Style        =   2
  116.       Caption      =   "Receipts"
  117.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  118.       Location     =   "Header Block"
  119.       Height       =   285
  120.       Left         =   7455
  121.       Top          =   960
  122.       Width        =   1410
  123. End
  124. Begin Control NNACCOUNT
  125.       Type         =   "Text"
  126.       Style        =   0
  127.       Fieldname    =   "NNACCOUNT"
  128.       Filename     =   "NLNAME"
  129.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  130.       Location     =   "Header Block"
  131.       Height       =   270
  132.       Left         =   1485
  133.       Top          =   420
  134.       Width        =   810
  135. End
  136. Begin Control LABEL
  137.       Type         =   "Label"
  138.       Style        =   1
  139.       Caption      =   "Bank Account:"
  140.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  141.       Location     =   "Header Block"
  142.       Height       =   270
  143.       Left         =   135
  144.       Top          =   420
  145.       Width        =   1350
  146. End
  147. Begin Control LABEL
  148.       Type         =   "Label"
  149.       Style        =   1
  150.       Caption      =   "Details"
  151.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  152.       Location     =   "Header Block"
  153.       Height       =   285
  154.       Left         =   3465
  155.       Top          =   960
  156.       Width        =   1140
  157. End
  158. Begin Control NNACCNAME
  159.       Type         =   "Text"
  160.       Style        =   0
  161.       Fieldname    =   "NNACCNAME"
  162.       Filename     =   "NLNAME"
  163.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  164.       Location     =   "Header Block"
  165.       Height       =   270
  166.       Left         =   2430
  167.       Top          =   420
  168.       Width        =   3510
  169. End
  170. Begin Control NTTXNDATE
  171.       Type         =   "Text"
  172.       Style        =   0
  173.       Fieldname    =   "NTTXNDATE"
  174.       Filename     =   "NLTRAN"
  175.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  176.       Location     =   "Transaction Block"
  177.       Height       =   270
  178.       Left         =   135
  179.       Top          =   135
  180.       Width        =   1275
  181. End
  182. Begin Control NTCOMMENT
  183.       Type         =   "Text"
  184.       Style        =   0
  185.       Fieldname    =   "NTCOMMENT"
  186.       Filename     =   "NLTRAN"
  187.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  188.       Location     =   "Transaction Block"
  189.       Height       =   270
  190.       Left         =   1575
  191.       Top          =   135
  192.       Width        =   1275
  193. End
  194. Begin Control LABEL
  195.       Type         =   "Label"
  196.       Style        =   10
  197.       Caption      =   "CORD(NLTRAN.NTVALUE,10,2,-1)"
  198.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  199.       Location     =   "Transaction Block"
  200.       Height       =   285
  201.       Left         =   5835
  202.       Top          =   150
  203.       Width        =   1410
  204. End
  205. Begin Control LABEL
  206.       Type         =   "Label"
  207.       Style        =   10
  208.       Caption      =   "CORD(NLTRAN.NTVALUE,10,2,1)"
  209.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  210.       Location     =   "Transaction Block"
  211.       Height       =   285
  212.       Left         =   7455
  213.       Top          =   150
  214.       Width        =   1410
  215. End
  216. Begin Control LABEL
  217.       Type         =   "Label"
  218.       Style        =   10
  219.       Caption      =   "STR(REPTOT(0),10,2)"
  220.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  221.       Location     =   "Transaction Block"
  222.       Height       =   285
  223.       Left         =   8940
  224.       Top          =   150
  225.       Width        =   1410
  226. End
  227. Begin Control LABEL
  228.       Type         =   "Label"
  229.       Style        =   9
  230.       Caption      =   "MID("               Journal         Sales Receipt   Purchase PaymentJournal         Cash Book       Brought Forward ",NLTRAN.NTTXNTYPE*16,16)"
  231.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  232.       Location     =   "Transaction Block"
  233.       Height       =   270
  234.       Left         =   3375
  235.       Top          =   150
  236.       Width        =   2025
  237. End
  238. Begin Control LABEL
  239.       Type         =   "Label"
  240.       Style        =   10
  241.       Caption      =   "STR(REPTOT(1),10,2)"
  242.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  243.       Location     =   "Subtotal Block"
  244.       Height       =   285
  245.       Left         =   7455
  246.       Top          =   495
  247.       Width        =   1410
  248. End
  249. Begin Control LABEL
  250.       Type         =   "Label"
  251.       Style        =   10
  252.       Caption      =   "STR(REPTOT(2),10,2)"
  253.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  254.       Location     =   "Subtotal Block"
  255.       Height       =   285
  256.       Left         =   5835
  257.       Top          =   495
  258.       Width        =   1410
  259. End
  260.