home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / NLTRIALG.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  6.2 KB  |  192 lines
  1. VERSION 2.00
  2. Begin Report NLTRIALG.REP
  3.       Caption      =   "NLTRIALG.REP"
  4.       Width        =   11175
  5.       Height       =   15795
  6.       Reportheader =   1050
  7.       Header       =   330
  8.       Transaction  =   12930
  9.       SubTotal     =   135
  10.       Footer       =   735
  11.       Pagefooter   =   15615
  12.       Replicate    =   390
  13.       Style        =   16
  14.       Query        =   "NLNAME (NNBALANCE+NNBFWD)<>0 ORDER BY NNGROUP"
  15.       Macro        =   "2LU:Select from NLGRPS where NGCODE=NLNAME.NNGROUP"
  16.       Macro        =   "2CD:When (NLNAME.NNBALANCE+NLNAME.NNBFWD)>0 then REPTOT(1)=REPTOT(1)+NLNAME.NNBALANCE+NLNAME.NNBFWD"
  17.       Macro        =   "2CD:When (NLNAME.NNBALANCE+NLNAME.NNBFWD)<0 then REPTOT(2)=REPTOT(2)+((NLNAME.NNBALANCE+NLNAME.NNBFWD)*-1)"
  18.       Macro        =   "2CD:When (NLNAME.NNBALANCE+NLNAME.NNBFWD)>0 then REPTOT(3)=REPTOT(3)+NLNAME.NNBALANCE+NLNAME.NNBFWD"
  19.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  20.       Macro        =   "3PP:@REPVARS.REPTOT(1) = 0"
  21.       Macro        =   "3PP:@REPVARS.REPTOT(2) = 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      =   "NLNAME.NNGROUP"
  28. End
  29. Begin Control LABEL
  30.       Type         =   "Label"
  31.       Style        =   4
  32.       Caption      =   "Trial Balance By Group"
  33.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  34.       Location     =   "Reportheader Block"
  35.       Height       =   375
  36.       Left         =   0
  37.       Top          =   675
  38.       Width        =   11025
  39. End
  40. Begin Control LABEL
  41.       Type         =   "Label"
  42.       Style        =   9
  43.       Caption      =   "DTOC(DATE())"
  44.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  45.       Location     =   "Reportheader Block"
  46.       Height       =   285
  47.       Left         =   135
  48.       Top          =   705
  49.       Width        =   1800
  50. End
  51. Begin Control LABEL
  52.       Type         =   "Label"
  53.       Style        =   10
  54.       Caption      =   ""Page "+PAGENUM()"
  55.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  56.       Location     =   "Reportheader Block"
  57.       Height       =   285
  58.       Left         =   9180
  59.       Top          =   720
  60.       Width        =   1800
  61. End
  62. Begin Control LABEL
  63.       Type         =   "Label"
  64.       Style        =   12
  65.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  66.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  67.       Location     =   "Reportheader Block"
  68.       Height       =   270
  69.       Left         =   -15
  70.       Top          =   405
  71.       Width        =   11070
  72. End
  73. Begin Control LABEL
  74.       Type         =   "Label"
  75.       Style        =   2
  76.       Caption      =   "Debit"
  77.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  78.       Location     =   "Header Block"
  79.       Height       =   285
  80.       Left         =   4395
  81.       Top          =   75
  82.       Width        =   1410
  83. End
  84. Begin Control LABEL
  85.       Type         =   "Label"
  86.       Style        =   2
  87.       Caption      =   "Credit"
  88.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  89.       Location     =   "Header Block"
  90.       Height       =   285
  91.       Left         =   6015
  92.       Top          =   75
  93.       Width        =   1410
  94. End
  95. Begin Control NGDESC
  96.       Type         =   "Text"
  97.       Style        =   0
  98.       Fieldname    =   "NGDESC"
  99.       Filename     =   "NLGRPS"
  100.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  101.       Location     =   "Transaction Block"
  102.       Height       =   270
  103.       Left         =   1155
  104.       Top          =   90
  105.       Width        =   2895
  106. End
  107. Begin Control NNGROUP
  108.       Type         =   "Text"
  109.       Style        =   0
  110.       Fieldname    =   "NNGROUP"
  111.       Filename     =   "NLNAME"
  112.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  113.       Location     =   "Transaction Block"
  114.       Height       =   270
  115.       Left         =   45
  116.       Top          =   90
  117.       Width        =   1005
  118. End
  119. Begin Control LABEL
  120.       Type         =   "Label"
  121.       Style        =   10
  122.       Caption      =   "CORD(REPTOT(1),10,2,1)"
  123.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  124.       Location     =   "Transaction Block"
  125.       Height       =   285
  126.       Left         =   4395
  127.       Top          =   105
  128.       Width        =   1410
  129. End
  130. Begin Control LABEL
  131.       Type         =   "Label"
  132.       Style        =   10
  133.       Caption      =   "CORD(REPTOT(2),10,2,1)"
  134.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  135.       Location     =   "Transaction Block"
  136.       Height       =   285
  137.       Left         =   6015
  138.       Top          =   105
  139.       Width        =   1410
  140. End
  141. Begin Control LABEL
  142.       Type         =   "Label"
  143.       Style        =   2
  144.       Caption      =   "Totals"
  145.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  146.       Location     =   "Footer Block"
  147.       Height       =   270
  148.       Left         =   3300
  149.       Top          =   405
  150.       Width        =   885
  151. End
  152. Begin Control LABEL
  153.       Type         =   "Label"
  154.       Style        =   10
  155.       Caption      =   "STR(REPTOT(3),10,2)"
  156.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  157.       Location     =   "Footer Block"
  158.       Height       =   270
  159.       Left         =   4590
  160.       Top          =   405
  161.       Width        =   1215
  162. End
  163. Begin Control LABEL
  164.       Type         =   "Label"
  165.       Style        =   10
  166.       Caption      =   "STR(REPTOT(3),10,2)"
  167.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  168.       Location     =   "Footer Block"
  169.       Height       =   270
  170.       Left         =   6210
  171.       Top          =   390
  172.       Width        =   1215
  173. End
  174. Begin Control BOX
  175.       Type         =   "Box"
  176.       Style        =   8
  177.       Location     =   "Footer Block"
  178.       Height       =   45
  179.       Left         =   4605
  180.       Top          =   285
  181.       Width        =   2835
  182. End
  183. Begin Control BOX
  184.       Type         =   "Box"
  185.       Style        =   8
  186.       Location     =   "Footer Block"
  187.       Height       =   45
  188.       Left         =   4605
  189.       Top          =   690
  190.       Width        =   2835
  191. End
  192.