home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / NLTRIAL.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  10.9 KB  |  348 lines
  1. VERSION 2.00
  2. Begin Report NLTRIAL.REP
  3.       Caption      =   "NLTRIAL.REP"
  4.       Width        =   11175
  5.       Height       =   15795
  6.       Reportheader =   1230
  7.       Header       =   975
  8.       Transaction  =   690
  9.       SubTotal     =   930
  10.       Footer       =   690
  11.       Pagefooter   =   15105
  12.       Replicate    =   375
  13.       Style        =   0
  14.       Query        =   "NLTRAN ALL ORDER BY NTCODE+NTENTRYNO"
  15.       Macro        =   "1LU:Select from NLNAME where NNACCOUNT=NLTRAN.NTCODE"
  16.       Macro        =   "2CD:When NLTRAN.NTVALUE>0 then REPTOT(0)=REPTOT(0)+NLTRAN.NTVALUE"
  17.       Macro        =   "2CD:When NLTRAN.NTVALUE<0 then REPTOT(1)=REPTOT(1)+NLTRAN.NTVALUE"
  18.       Macro        =   "3PP:@REPVARS.REPTOT(2) = REPTOT(2)+REPTOT(0)"
  19.       Macro        =   "3PP:@REPVARS.REPTOT(3) = REPTOT(3)+REPTOT(1)"
  20.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  21.       Macro        =   "3PP:@REPVARS.REPTOT(1) = 0"
  22.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  23.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  24.       Macro        =   "4PP:@REPVARS.REPTOT(2) = 0"
  25.       Macro        =   "4PP:@REPVARS.REPTOT(3) = 0"
  26.       Macro        =   "4PP:@REPVARS.REPTOT(4) = 0"
  27.       BreakOn      =   "NLTRAN.NTCODE"
  28.       Special      =   "TXNRANGE(NTENTRYNO)"
  29. End
  30. Begin Control LABEL
  31.       Type         =   "Label"
  32.       Style        =   4
  33.       Caption      =   "Detailed Trial Balance"
  34.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  35.       Location     =   "Reportheader Block"
  36.       Height       =   375
  37.       Left         =   0
  38.       Top          =   540
  39.       Width        =   11025
  40. End
  41. Begin Control LABEL
  42.       Type         =   "Label"
  43.       Style        =   9
  44.       Caption      =   "DTOC(DATE())"
  45.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  46.       Location     =   "Reportheader Block"
  47.       Height       =   285
  48.       Left         =   135
  49.       Top          =   570
  50.       Width        =   1800
  51. End
  52. Begin Control LABEL
  53.       Type         =   "Label"
  54.       Style        =   10
  55.       Caption      =   ""Page "+PAGENUM()"
  56.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  57.       Location     =   "Reportheader Block"
  58.       Height       =   285
  59.       Left         =   9180
  60.       Top          =   585
  61.       Width        =   1800
  62. End
  63. Begin Control LABEL
  64.       Type         =   "Label"
  65.       Style        =   12
  66.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  67.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  68.       Location     =   "Reportheader Block"
  69.       Height       =   270
  70.       Left         =   120
  71.       Top          =   135
  72.       Width        =   11070
  73. End
  74. Begin Control LABEL
  75.       Type         =   "Label"
  76.       Style        =   2
  77.       Caption      =   "Debit"
  78.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  79.       Location     =   "Header Block"
  80.       Height       =   285
  81.       Left         =   4665
  82.       Top          =   705
  83.       Width        =   1410
  84. End
  85. Begin Control LABEL
  86.       Type         =   "Label"
  87.       Style        =   2
  88.       Caption      =   "Credit"
  89.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  90.       Location     =   "Header Block"
  91.       Height       =   285
  92.       Left         =   6420
  93.       Top          =   705
  94.       Width        =   1410
  95. End
  96. Begin Control NNACCOUNT
  97.       Type         =   "Text"
  98.       Style        =   0
  99.       Fieldname    =   "NNACCOUNT"
  100.       Filename     =   "NLNAME"
  101.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  102.       Location     =   "Header Block"
  103.       Height       =   270
  104.       Left         =   45
  105.       Top          =   240
  106.       Width        =   1005
  107. End
  108. Begin Control NNACCNAME
  109.       Type         =   "Text"
  110.       Style        =   0
  111.       Fieldname    =   "NNACCNAME"
  112.       Filename     =   "NLNAME"
  113.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  114.       Location     =   "Header Block"
  115.       Height       =   270
  116.       Left         =   1125
  117.       Top          =   240
  118.       Width        =   3030
  119. End
  120. Begin Control LABEL
  121.       Type         =   "Label"
  122.       Style        =   4
  123.       Caption      =   "Input By"
  124.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  125.       Location     =   "Header Block"
  126.       Height       =   285
  127.       Left         =   3585
  128.       Top          =   705
  129.       Width        =   870
  130. End
  131. Begin Control LABEL
  132.       Type         =   "Label"
  133.       Style        =   2
  134.       Caption      =   "Entry"
  135.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  136.       Location     =   "Header Block"
  137.       Height       =   285
  138.       Left         =   1290
  139.       Top          =   705
  140.       Width        =   870
  141. End
  142. Begin Control LABEL
  143.       Type         =   "Label"
  144.       Style        =   1
  145.       Caption      =   "Date"
  146.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  147.       Location     =   "Header Block"
  148.       Height       =   285
  149.       Left         =   75
  150.       Top          =   705
  151.       Width        =   870
  152. End
  153. Begin Control LABEL
  154.       Type         =   "Label"
  155.       Style        =   1
  156.       Caption      =   "Type"
  157.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  158.       Location     =   "Header Block"
  159.       Height       =   285
  160.       Left         =   2235
  161.       Top          =   705
  162.       Width        =   870
  163. End
  164. Begin Control NTTXNDATE
  165.       Type         =   "Text"
  166.       Style        =   0
  167.       Fieldname    =   "NTTXNDATE"
  168.       Filename     =   "NLTRAN"
  169.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  170.       Location     =   "Transaction Block"
  171.       Height       =   270
  172.       Left         =   45
  173.       Top          =   75
  174.       Width        =   1080
  175. End
  176. Begin Control LABEL
  177.       Type         =   "Label"
  178.       Style        =   10
  179.       Caption      =   "CORD(NLTRAN.NTVALUE,10,2,1)"
  180.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  181.       Location     =   "Transaction Block"
  182.       Height       =   285
  183.       Left         =   4665
  184.       Top          =   90
  185.       Width        =   1410
  186. End
  187. Begin Control LABEL
  188.       Type         =   "Label"
  189.       Style        =   10
  190.       Caption      =   "CORD(NLTRAN.NTVALUE,10,2,-1)"
  191.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  192.       Location     =   "Transaction Block"
  193.       Height       =   285
  194.       Left         =   6420
  195.       Top          =   90
  196.       Width        =   1410
  197. End
  198. Begin Control NTINPUTBY
  199.       Type         =   "Text"
  200.       Style        =   0
  201.       Fieldname    =   "NTINPUTBY"
  202.       Filename     =   "NLTRAN"
  203.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  204.       Location     =   "Transaction Block"
  205.       Height       =   270
  206.       Left         =   3720
  207.       Top          =   75
  208.       Width        =   600
  209. End
  210. Begin Control LABEL
  211.       Type         =   "Label"
  212.       Style        =   10
  213.       Caption      =   "MID(NLTRAN.NTENTRYNO,5,5)"
  214.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  215.       Location     =   "Transaction Block"
  216.       Height       =   270
  217.       Left         =   1275
  218.       Top          =   105
  219.       Width        =   885
  220. End
  221. Begin Control LABEL
  222.       Type         =   "Label"
  223.       Style        =   9
  224.       Caption      =   "MID("        Journal  Sales    Purchase Res/Prov Cash BookB/Fwd    ",NLTRAN.NTTXNTYPE*9,9)"
  225.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  226.       Location     =   "Transaction Block"
  227.       Height       =   270
  228.       Left         =   2220
  229.       Top          =   105
  230.       Width        =   1425
  231. End
  232. Begin Control NTCOMMENT
  233.       Type         =   "Text"
  234.       Style        =   0
  235.       Fieldname    =   "NTCOMMENT"
  236.       Filename     =   "NLTRAN"
  237.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  238.       Location     =   "Transaction Block"
  239.       Height       =   270
  240.       Left         =   8040
  241.       Top          =   75
  242.       Width        =   2895
  243. End
  244. Begin Control BOX
  245.       Type         =   "Box"
  246.       Style        =   8
  247.       Location     =   "Subtotal Block"
  248.       Height       =   450
  249.       Left         =   4740
  250.       Top          =   225
  251.       Width        =   3105
  252. End
  253. Begin Control LABEL
  254.       Type         =   "Label"
  255.       Style        =   1
  256.       Caption      =   "Totals"
  257.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  258.       Location     =   "Subtotal Block"
  259.       Height       =   270
  260.       Left         =   1815
  261.       Top          =   360
  262.       Width        =   750
  263. End
  264. Begin Control LABEL
  265.       Type         =   "Label"
  266.       Style        =   10
  267.       Caption      =   "CORD(REPTOT(0),10,2,1)"
  268.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  269.       Location     =   "Subtotal Block"
  270.       Height       =   270
  271.       Left         =   4725
  272.       Top          =   345
  273.       Width        =   1350
  274. End
  275. Begin Control LABEL
  276.       Type         =   "Label"
  277.       Style        =   10
  278.       Caption      =   "CORD(REPTOT(1),10,2,-1)"
  279.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  280.       Location     =   "Subtotal Block"
  281.       Height       =   270
  282.       Left         =   6480
  283.       Top          =   330
  284.       Width        =   1350
  285. End
  286. Begin Control LABEL
  287.       Type         =   "Label"
  288.       Style        =   10
  289.       Caption      =   "STR(REPTOT(0)+REPTOT(1),10,2)"
  290.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  291.       Location     =   "Subtotal Block"
  292.       Height       =   270
  293.       Left         =   2760
  294.       Top          =   360
  295.       Width        =   1695
  296. End
  297. Begin Control BOX
  298.       Type         =   "Box"
  299.       Style        =   8
  300.       Location     =   "Footer Block"
  301.       Height       =   45
  302.       Left         =   4740
  303.       Top          =   645
  304.       Width        =   3105
  305. End
  306. Begin Control BOX
  307.       Type         =   "Box"
  308.       Style        =   8
  309.       Location     =   "Footer Block"
  310.       Height       =   45
  311.       Left         =   4740
  312.       Top          =   240
  313.       Width        =   3105
  314. End
  315. Begin Control LABEL
  316.       Type         =   "Label"
  317.       Style        =   10
  318.       Caption      =   "CORD(REPTOT(2),10,2,1)"
  319.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  320.       Location     =   "Footer Block"
  321.       Height       =   270
  322.       Left         =   4725
  323.       Top          =   360
  324.       Width        =   1350
  325. End
  326. Begin Control LABEL
  327.       Type         =   "Label"
  328.       Style        =   10
  329.       Caption      =   "CORD(REPTOT(3),10,2,-1)"
  330.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  331.       Location     =   "Footer Block"
  332.       Height       =   270
  333.       Left         =   6480
  334.       Top          =   345
  335.       Width        =   1350
  336. End
  337. Begin Control LABEL
  338.       Type         =   "Label"
  339.       Style        =   1
  340.       Caption      =   "Grand Totals"
  341.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  342.       Location     =   "Footer Block"
  343.       Height       =   270
  344.       Left         =   1815
  345.       Top          =   360
  346.       Width        =   1560
  347. End
  348.