home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / NLTRANS.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  10.4 KB  |  329 lines
  1. VERSION 2.00
  2. rem     Rev 1.0   12 Jan 1995 16:27:56   capital_admin
  3. rem  Initial revision.
  4. rem
  5. Begin Report NLTRANS.REP
  6.       Caption      =   "NLTRANS.REP"
  7.       Width        =   11175
  8.       Height       =   15795
  9.       Reportheader =   1020
  10.       Header       =   825
  11.       Transaction  =   11505
  12.       SubTotal     =   1035
  13.       Footer       =   795
  14.       Pagefooter   =   15615
  15.       Replicate    =   330
  16.       Style        =   0
  17.       Query        =   "NLTRAN ALL ORDER BY RIGHT(NLTRAN.NTENTRYNO,5)"
  18.       Macro        =   "1LU:Select from NLJRNL where NJENTRYNO=NLTRAN.NTENTRYNO"
  19.       Macro        =   "2LU:Select from NLNAME where NNACCOUNT=NLTRAN.NTCODE"
  20.       Macro        =   "2CD:When NLTRAN.NTVALUE=>0 then REPTOT(0)=REPTOT(0)+NLTRAN.NTVALUE"
  21.       Macro        =   "2CD:When NLTRAN.NTVALUE<0 then REPTOT(1)=REPTOT(1)+(NLTRAN.NTVALUE*-1)"
  22.       Macro        =   "3PP:@REPVARS.REPTOT(2) = REPTOT(2)+REPTOT(0)"
  23.       Macro        =   "3PP:@REPVARS.REPTOT(3) = REPTOT(3)+REPTOT(1)"
  24.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  25.       Macro        =   "3PP:@REPVARS.REPTOT(1) = 0"
  26.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  27.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  28.       Macro        =   "4PP:@REPVARS.REPTOT(2) = 0"
  29.       Macro        =   "4PP:@REPVARS.REPTOT(3) = 0"
  30.       BreakOn      =   "NLTRAN.NTENTRYNO"
  31.       Special      =   "TXNRANGE(NTENTRYNO,NTPOSTDATE)"
  32. End
  33. Begin Control LABEL
  34.       Type         =   "Label"
  35.       Style        =   4
  36.       Caption      =   "Transaction List"
  37.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  38.       Location     =   "Reportheader Block"
  39.       Height       =   375
  40.       Left         =   0
  41.       Top          =   675
  42.       Width        =   11025
  43. End
  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. End
  55. Begin Control LABEL
  56.       Type         =   "Label"
  57.       Style        =   10
  58.       Caption      =   ""Page "+PAGENUM()"
  59.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  60.       Location     =   "Reportheader Block"
  61.       Height       =   285
  62.       Left         =   9180
  63.       Top          =   720
  64.       Width        =   1800
  65. End
  66. Begin Control LABEL
  67.       Type         =   "Label"
  68.       Style        =   12
  69.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  70.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  71.       Location     =   "Reportheader Block"
  72.       Height       =   270
  73.       Left         =   -15
  74.       Top          =   405
  75.       Width        =   11070
  76. End
  77. Begin Control LABEL
  78.       Type         =   "Label"
  79.       Style        =   2
  80.       Caption      =   "Debit"
  81.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  82.       Location     =   "Header Block"
  83.       Height       =   285
  84.       Left         =   4935
  85.       Top          =   510
  86.       Width        =   1275
  87. End
  88. Begin Control LABEL
  89.       Type         =   "Label"
  90.       Style        =   2
  91.       Caption      =   "Credit"
  92.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  93.       Location     =   "Header Block"
  94.       Height       =   285
  95.       Left         =   6555
  96.       Top          =   510
  97.       Width        =   1275
  98. End
  99. Begin Control LABEL
  100.       Type         =   "Label"
  101.       Style        =   1
  102.       Caption      =   "Entry:"
  103.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  104.       Location     =   "Header Block"
  105.       Height       =   285
  106.       Left         =   90
  107.       Top          =   165
  108.       Width        =   600
  109. End
  110. Begin Control NJDATE
  111.       Type         =   "Text"
  112.       Style        =   0
  113.       Fieldname    =   "NJDATE"
  114.       Filename     =   "NLJRNL"
  115.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  116.       Location     =   "Header Block"
  117.       Height       =   270
  118.       Left         =   2340
  119.       Top          =   180
  120.       Width        =   1005
  121. End
  122. Begin Control LABEL
  123.       Type         =   "Label"
  124.       Style        =   9
  125.       Caption      =   ""Type: "+MID("        Journal  Sales    Purchase Res/Prov Cash BookB/Fwd    ",NLTRAN.NTTXNTYPE*9,9)+" "+NLJRNL.NJNARATIVE"
  126.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  127.       Location     =   "Header Block"
  128.       Height       =   285
  129.       Left         =   4725
  130.       Top          =   180
  131.       Width        =   4515
  132. End
  133. Begin Control LABEL
  134.       Type         =   "Label"
  135.       Style        =   1
  136.       Caption      =   "Account"
  137.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  138.       Location     =   "Header Block"
  139.       Height       =   285
  140.       Left         =   1830
  141.       Top          =   510
  142.       Width        =   2760
  143. End
  144. Begin Control LABEL
  145.       Type         =   "Label"
  146.       Style        =   9
  147.       Caption      =   "mid(NLTRAN.NTENTRYNO+"         ",5,5)"
  148.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  149.       Location     =   "Header Block"
  150.       Height       =   285
  151.       Left         =   675
  152.       Top          =   180
  153.       Width        =   870
  154. End
  155. Begin Control NNACCNAME
  156.       Type         =   "Text"
  157.       Style        =   0
  158.       Fieldname    =   "NNACCNAME"
  159.       Filename     =   "NLNAME"
  160.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  161.       Location     =   "Transaction Block"
  162.       Height       =   270
  163.       Left         =   1830
  164.       Top          =   30
  165.       Width        =   2760
  166. End
  167. Begin Control NTCODE
  168.       Type         =   "Text"
  169.       Style        =   0
  170.       Fieldname    =   "NTCODE"
  171.       Filename     =   "NLTRAN"
  172.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  173.       Location     =   "Transaction Block"
  174.       Height       =   270
  175.       Left         =   45
  176.       Top          =   30
  177.       Width        =   1275
  178. End
  179. Begin Control LABEL
  180.       Type         =   "Label"
  181.       Style        =   10
  182.       Caption      =   "CORD(NLTRAN.NTVALUE,10,2,1)"
  183.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  184.       Location     =   "Transaction Block"
  185.       Height       =   285
  186.       Left         =   4800
  187.       Top          =   45
  188.       Width        =   1410
  189. End
  190. Begin Control LABEL
  191.       Type         =   "Label"
  192.       Style        =   10
  193.       Caption      =   "CORD(NLTRAN.NTVALUE,10,2,-1)"
  194.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  195.       Location     =   "Transaction Block"
  196.       Height       =   285
  197.       Left         =   6420
  198.       Top          =   45
  199.       Width        =   1410
  200. End
  201. Begin Control NTCOMMENT
  202.       Type         =   "Text"
  203.       Style        =   0
  204.       Fieldname    =   "NTCOMMENT"
  205.       Filename     =   "NLTRAN"
  206.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  207.       Location     =   "Transaction Block"
  208.       Height       =   270
  209.       Left         =   8040
  210.       Top          =   30
  211.       Width        =   2895
  212. End
  213. Begin Control BOX
  214.       Type         =   "Box"
  215.       Style        =   8
  216.       Location     =   "Subtotal Block"
  217.       Height       =   465
  218.       Left         =   4875
  219.       Top          =   315
  220.       Width        =   2970
  221. End
  222. Begin Control LABEL
  223.       Type         =   "Label"
  224.       Style        =   10
  225.       Caption      =   "STR(REPTOT(0),10,2)"
  226.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  227.       Location     =   "Subtotal Block"
  228.       Height       =   270
  229.       Left         =   5010
  230.       Top          =   420
  231.       Width        =   1215
  232. End
  233. Begin Control LABEL
  234.       Type         =   "Label"
  235.       Style        =   10
  236.       Caption      =   "STR(REPTOT(1),10,2)"
  237.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  238.       Location     =   "Subtotal Block"
  239.       Height       =   270
  240.       Left         =   6615
  241.       Top          =   420
  242.       Width        =   1215
  243. End
  244. Begin Control LABEL
  245.       Type         =   "Label"
  246.       Style        =   1
  247.       Caption      =   "Account Total"
  248.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  249.       Location     =   "Subtotal Block"
  250.       Height       =   270
  251.       Left         =   3165
  252.       Top          =   420
  253.       Width        =   1605
  254. End
  255. Begin Control LABEL
  256.       Type         =   "Label"
  257.       Style        =   1
  258.       Caption      =   "Input By:"
  259.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  260.       Location     =   "Subtotal Block"
  261.       Height       =   270
  262.       Left         =   150
  263.       Top          =   420
  264.       Width        =   930
  265. End
  266. Begin Control NJINPUTBY
  267.       Type         =   "Text"
  268.       Style        =   0
  269.       Fieldname    =   "NJINPUTBY"
  270.       Filename     =   "NLJRNL"
  271.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  272.       Location     =   "Subtotal Block"
  273.       Height       =   270
  274.       Left         =   1215
  275.       Top          =   420
  276.       Width        =   945
  277. End
  278. Begin Control LABEL
  279.       Type         =   "Label"
  280.       Style        =   1
  281.       Caption      =   "Totals"
  282.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  283.       Location     =   "Footer Block"
  284.       Height       =   270
  285.       Left         =   3435
  286.       Top          =   330
  287.       Width        =   885
  288. End
  289. Begin Control LABEL
  290.       Type         =   "Label"
  291.       Style        =   10
  292.       Caption      =   "STR(REPTOT(2),10,2)"
  293.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  294.       Location     =   "Footer Block"
  295.       Height       =   270
  296.       Left         =   4995
  297.       Top          =   465
  298.       Width        =   1215
  299. End
  300. Begin Control LABEL
  301.       Type         =   "Label"
  302.       Style        =   10
  303.       Caption      =   "STR(REPTOT(3),10,2)"
  304.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  305.       Location     =   "Footer Block"
  306.       Height       =   270
  307.       Left         =   6615
  308.       Top          =   450
  309.       Width        =   1215
  310. End
  311. Begin Control BOX
  312.       Type         =   "Box"
  313.       Style        =   8
  314.       Location     =   "Footer Block"
  315.       Height       =   45
  316.       Left         =   5010
  317.       Top          =   345
  318.       Width        =   2835
  319. End
  320. Begin Control BOX
  321.       Type         =   "Box"
  322.       Style        =   8
  323.       Location     =   "Footer Block"
  324.       Height       =   45
  325.       Left         =   5010
  326.       Top          =   750
  327.       Width        =   2835
  328. End
  329.