home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / NLDETRIA.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  15.2 KB  |  463 lines
  1. VERSION 2.00
  2. Begin Report NLDETRIA.REP
  3.       Caption      =   "NLDETRIA.REP"
  4.       Width        =   13515
  5.       Height       =   15765
  6.       Reportheader =   1125
  7.       Header       =   1515
  8.       Transaction  =   10545
  9.       SubTotal     =   435
  10.       Footer       =   1560
  11.       Pagefooter   =   15615
  12.       Replicate    =   345
  13.       Style        =   0
  14.       Query        =   "NLNAME NNBALANCE<>0 ORDER BY NNGROUP+NNACCOUNT"
  15.       Macro        =   "0CD:When REPTOT(6)=0 then REPSTR(0)="' '""
  16.       Macro        =   "1OF:@REPVARS.REPSTR(2) = "' '""
  17.       Macro        =   "1OF:@REPVARS.REPSTR(1) = "' '""
  18.       Macro        =   "1CD:When REPTOT(6)=1 then SKIP 3"
  19.       Macro        =   "1LU:Select from NLGRPS where NGCODE=NLNAME.NNGROUP"
  20.       Macro        =   "1OF:@REPVARS.REPSTR(0) = "'"+NLNAME.NNGROUP+"'""
  21.       Macro        =   "1CD:When NLNAME.NNGROUP=REPSTR(0) then SKIP 3"
  22.       Macro        =   "1OF:@REPVARS.REPSTR(1) = "'"+TRIM(NLGRPS.NGDESC)+" Group Total'""
  23.       Macro        =   "1OF:@REPVARS.REPSTR(2) = "'___________________________'""
  24.       Macro        =   "1OF:@REPVARS.REPTOT(6) = 1"
  25.       Macro        =   "1OF:@REPVARS.REPSTR(0) = "'"+NLNAME.NNGROUP+"'""
  26.       Macro        =   "2SQ:Select from NLTRAN where NTCODE=NLNAME.NNACCOUNT"
  27.       Macro        =   "2PP:@REPVARS.REPTOT(0) = REPTOT(0)+NLTRAN.NTVALUE"
  28.       Macro        =   "2CD:When LEN(TRIM(REPSTR(1)))<>0 then REPTOT(1)=0"
  29.       Macro        =   "3OF:@REPVARS.REPTOT(1) = REPTOT(1)+REPTOT(0)"
  30.       Macro        =   "3CD:When REPTOT(0)>0 then REPTOT(3)=REPTOT(3)+REPTOT(0)"
  31.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  32.       Macro        =   "3LU:Select from NLGRPS where NGCODE=@REPVARS.REPSTR(0)"
  33.       Macro        =   "4LU:Select from NLGRPS where NGCODE=NLNAME.NNGROUP"
  34.       Macro        =   "4OF:@REPVARS.REPSTR(1) = "'"+TRIM(NLGRPS.NGDESC)+" Group Total'""
  35.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  36.       Macro        =   "4PP:@REPVARS.REPTOT(2) = 0"
  37.       Macro        =   "4PP:@REPVARS.REPTOT(3) = 0"
  38.       Macro        =   "4PP:@REPVARS.REPTOT(6) = 0"
  39.       Macro        =   "4PP:@REPVARS.REPSTR(1) = " ""
  40.       Macro        =   "4PP:@REPVARS.REPSTR(0) = " ""
  41.       Macro        =   "4PP:@REPVARS.REPSTR(2) = " ""
  42.       BreakOn      =   "NLNAME.NNACCOUNT"
  43. End
  44. Begin Control LABEL
  45.       Type         =   "Label"
  46.       Style        =   4
  47.       Caption      =   "Detailed Trial Balance"
  48.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  49.       Location     =   "Reportheader Block"
  50.       Height       =   375
  51.       Left         =   0
  52.       Top          =   675
  53.       Width        =   11025
  54. End
  55. Begin Control LABEL
  56.       Type         =   "Label"
  57.       Style        =   9
  58.       Caption      =   "DTOC(DATE())"
  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         =   135
  63.       Top          =   705
  64.       Width        =   1800
  65. End
  66. Begin Control LABEL
  67.       Type         =   "Label"
  68.       Style        =   10
  69.       Caption      =   ""Page "+PAGENUM()"
  70.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  71.       Location     =   "Reportheader Block"
  72.       Height       =   285
  73.       Left         =   9180
  74.       Top          =   720
  75.       Width        =   1800
  76. End
  77. Begin Control LABEL
  78.       Type         =   "Label"
  79.       Style        =   12
  80.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  81.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  82.       Location     =   "Reportheader Block"
  83.       Height       =   270
  84.       Left         =   -15
  85.       Top          =   405
  86.       Width        =   11070
  87. End
  88. Begin Control LABEL
  89.       Type         =   "Label"
  90.       Style        =   9
  91.       Caption      =   "REPSTR(2)"
  92.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  93.       Location     =   "Header Block"
  94.       Height       =   270
  95.       Left         =   4590
  96.       Top          =   450
  97.       Width        =   2835
  98. End
  99. Begin Control LABEL
  100.       Type         =   "Label"
  101.       Style        =   1
  102.       Caption      =   "Type"
  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         =   2295
  107.       Top          =   1290
  108.       Width        =   735
  109. End
  110. Begin Control LABEL
  111.       Type         =   "Label"
  112.       Style        =   1
  113.       Caption      =   "Entry"
  114.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  115.       Location     =   "Header Block"
  116.       Height       =   285
  117.       Left         =   1305
  118.       Top          =   1275
  119.       Width        =   600
  120. End
  121. Begin Control NNACCNAME
  122.       Type         =   "Text"
  123.       Style        =   0
  124.       Fieldname    =   "NNACCNAME"
  125.       Filename     =   "NLNAME"
  126.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  127.       Location     =   "Header Block"
  128.       Height       =   270
  129.       Left         =   1155
  130.       Top          =   885
  131.       Width        =   2895
  132. End
  133. Begin Control NNACCOUNT
  134.       Type         =   "Text"
  135.       Style        =   0
  136.       Fieldname    =   "NNACCOUNT"
  137.       Filename     =   "NLNAME"
  138.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  139.       Location     =   "Header Block"
  140.       Height       =   270
  141.       Left         =   45
  142.       Top          =   885
  143.       Width        =   1005
  144. End
  145. Begin Control LABEL
  146.       Type         =   "Label"
  147.       Style        =   4
  148.       Caption      =   "Date"
  149.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  150.       Location     =   "Header Block"
  151.       Height       =   285
  152.       Left         =   90
  153.       Top          =   1275
  154.       Width        =   870
  155. End
  156. Begin Control LABEL
  157.       Type         =   "Label"
  158.       Style        =   4
  159.       Caption      =   "Input By"
  160.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  161.       Location     =   "Header Block"
  162.       Height       =   285
  163.       Left         =   3240
  164.       Top          =   1290
  165.       Width        =   870
  166. End
  167. Begin Control LABEL
  168.       Type         =   "Label"
  169.       Style        =   2
  170.       Caption      =   "Debit"
  171.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  172.       Location     =   "Header Block"
  173.       Height       =   285
  174.       Left         =   4665
  175.       Top          =   1305
  176.       Width        =   1005
  177. End
  178. Begin Control LABEL
  179.       Type         =   "Label"
  180.       Style        =   2
  181.       Caption      =   "Credit"
  182.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  183.       Location     =   "Header Block"
  184.       Height       =   285
  185.       Left         =   6345
  186.       Top          =   1305
  187.       Width        =   1005
  188. End
  189. Begin Control LABEL
  190.       Type         =   "Label"
  191.       Style        =   9
  192.       Caption      =   "REPSTR(1)"
  193.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  194.       Location     =   "Header Block"
  195.       Height       =   270
  196.       Left         =   495
  197.       Top          =   375
  198.       Width        =   3810
  199. End
  200. Begin Control LABEL
  201.       Type         =   "Label"
  202.       Style        =   10
  203.       Caption      =   "IF(LEN(TRIM(REPSTR(1))),CORD(REPTOT(1),10,2,2)," ")"
  204.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  205.       Location     =   "Header Block"
  206.       Height       =   270
  207.       Left         =   4335
  208.       Top          =   360
  209.       Width        =   1485
  210. End
  211. Begin Control LABEL
  212.       Type         =   "Label"
  213.       Style        =   10
  214.       Caption      =   "IF(LEN(TRIM(REPSTR(1))),CORD(REPTOT(1),10,2,-2)," ")"
  215.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  216.       Location     =   "Header Block"
  217.       Height       =   270
  218.       Left         =   6015
  219.       Top          =   360
  220.       Width        =   1410
  221. End
  222. Begin Control LABEL
  223.       Type         =   "Label"
  224.       Style        =   9
  225.       Caption      =   "REPSTR(2)"
  226.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  227.       Location     =   "Header Block"
  228.       Height       =   270
  229.       Left         =   4590
  230.       Top          =   45
  231.       Width        =   2835
  232. End
  233. Begin Control NTTXNDATE
  234.       Type         =   "Text"
  235.       Style        =   0
  236.       Fieldname    =   "NTTXNDATE"
  237.       Filename     =   "NLTRAN"
  238.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  239.       Location     =   "Transaction Block"
  240.       Height       =   270
  241.       Left         =   45
  242.       Top          =   45
  243.       Width        =   1005
  244. End
  245. Begin Control LABEL
  246.       Type         =   "Label"
  247.       Style        =   9
  248.       Caption      =   "MID("       Journal Sales   Purchase",NLTRAN.NTTXNTYPE*8,8)"
  249.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  250.       Location     =   "Transaction Block"
  251.       Height       =   285
  252.       Left         =   2295
  253.       Top          =   45
  254.       Width        =   870
  255. End
  256. Begin Control LABEL
  257.       Type         =   "Label"
  258.       Style        =   10
  259.       Caption      =   "CORD(NLTRAN.NTVALUE,10,2,1)"
  260.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  261.       Location     =   "Transaction Block"
  262.       Height       =   285
  263.       Left         =   4260
  264.       Top          =   60
  265.       Width        =   1545
  266. End
  267. Begin Control LABEL
  268.       Type         =   "Label"
  269.       Style        =   10
  270.       Caption      =   "CORD(NLTRAN.NTVALUE,10,2,-1)"
  271.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  272.       Location     =   "Transaction Block"
  273.       Height       =   285
  274.       Left         =   5880
  275.       Top          =   60
  276.       Width        =   1545
  277. End
  278. Begin Control NTCOMMENT
  279.       Type         =   "Text"
  280.       Style        =   0
  281.       Fieldname    =   "NTCOMMENT"
  282.       Filename     =   "NLTRAN"
  283.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  284.       Location     =   "Transaction Block"
  285.       Height       =   270
  286.       Left         =   7635
  287.       Top          =   45
  288.       Width        =   2760
  289. End
  290. Begin Control NTINPUTBY
  291.       Type         =   "Text"
  292.       Style        =   0
  293.       Fieldname    =   "NTINPUTBY"
  294.       Filename     =   "NLTRAN"
  295.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  296.       Location     =   "Transaction Block"
  297.       Height       =   270
  298.       Left         =   3285
  299.       Top          =   45
  300.       Width        =   735
  301. End
  302. Begin Control LABEL
  303.       Type         =   "Label"
  304.       Style        =   9
  305.       Caption      =   "mid(NLTRAN.NTENTRYNO+"         ",5,5)"
  306.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  307.       Location     =   "Transaction Block"
  308.       Height       =   285
  309.       Left         =   1350
  310.       Top          =   45
  311.       Width        =   735
  312. End
  313. Begin Control LABEL
  314.       Type         =   "Label"
  315.       Style        =   10
  316.       Caption      =   "IF(NLNAME.NNANNBUDG<>0,STR(NLNAME.NNANNBUDG,10,0)," ")"
  317.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  318.       Location     =   "Transaction Block"
  319.       Height       =   285
  320.       Left         =   10470
  321.       Top          =   60
  322.       Width        =   1545
  323. End
  324. Begin Control LABEL
  325.       Type         =   "Label"
  326.       Style        =   1
  327.       Caption      =   "___________________________"
  328.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  329.       Location     =   "Subtotal Block"
  330.       Height       =   270
  331.       Left         =   4590
  332.       Top          =   225
  333.       Width        =   2835
  334. End
  335. Begin Control LABEL
  336.       Type         =   "Label"
  337.       Style        =   10
  338.       Caption      =   "CORD(REPTOT(0),10,2,2)"
  339.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  340.       Location     =   "Subtotal Block"
  341.       Height       =   270
  342.       Left         =   4605
  343.       Top          =   180
  344.       Width        =   1215
  345. End
  346. Begin Control LABEL
  347.       Type         =   "Label"
  348.       Style        =   10
  349.       Caption      =   "CORD(REPTOT(0),10,2,-2)"
  350.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  351.       Location     =   "Subtotal Block"
  352.       Height       =   270
  353.       Left         =   6210
  354.       Top          =   180
  355.       Width        =   1215
  356. End
  357. Begin Control LABEL
  358.       Type         =   "Label"
  359.       Style        =   1
  360.       Caption      =   "___________________________"
  361.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  362.       Location     =   "Footer Block"
  363.       Height       =   270
  364.       Left         =   4575
  365.       Top          =   405
  366.       Width        =   2835
  367. End
  368. Begin Control LABEL
  369.       Type         =   "Label"
  370.       Style        =   2
  371.       Caption      =   "Totals"
  372.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  373.       Location     =   "Footer Block"
  374.       Height       =   270
  375.       Left         =   2625
  376.       Top          =   1230
  377.       Width        =   885
  378. End
  379. Begin Control LABEL
  380.       Type         =   "Label"
  381.       Style        =   10
  382.       Caption      =   "STR(REPTOT(3),10,2)"
  383.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  384.       Location     =   "Footer Block"
  385.       Height       =   270
  386.       Left         =   4590
  387.       Top          =   1230
  388.       Width        =   1215
  389. End
  390. Begin Control LABEL
  391.       Type         =   "Label"
  392.       Style        =   10
  393.       Caption      =   "STR(REPTOT(3),10,2)"
  394.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  395.       Location     =   "Footer Block"
  396.       Height       =   270
  397.       Left         =   6210
  398.       Top          =   1215
  399.       Width        =   1215
  400. End
  401. Begin Control BOX
  402.       Type         =   "Box"
  403.       Style        =   8
  404.       Location     =   "Footer Block"
  405.       Height       =   45
  406.       Left         =   4605
  407.       Top          =   1110
  408.       Width        =   2835
  409. End
  410. Begin Control BOX
  411.       Type         =   "Box"
  412.       Style        =   8
  413.       Location     =   "Footer Block"
  414.       Height       =   45
  415.       Left         =   4605
  416.       Top          =   1515
  417.       Width        =   2835
  418. End
  419. Begin Control LABEL
  420.       Type         =   "Label"
  421.       Style        =   9
  422.       Caption      =   "REPSTR(1)"
  423.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  424.       Location     =   "Footer Block"
  425.       Height       =   270
  426.       Left         =   465
  427.       Top          =   345
  428.       Width        =   3900
  429. End
  430. Begin Control LABEL
  431.       Type         =   "Label"
  432.       Style        =   10
  433.       Caption      =   "CORD(REPTOT(1),10,2,2)"
  434.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  435.       Location     =   "Footer Block"
  436.       Height       =   270
  437.       Left         =   4605
  438.       Top          =   345
  439.       Width        =   1215
  440. End
  441. Begin Control LABEL
  442.       Type         =   "Label"
  443.       Style        =   10
  444.       Caption      =   "CORD(REPTOT(1),10,2,-2)"
  445.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  446.       Location     =   "Footer Block"
  447.       Height       =   270
  448.       Left         =   6195
  449.       Top          =   345
  450.       Width        =   1215
  451. End
  452. Begin Control LABEL
  453.       Type         =   "Label"
  454.       Style        =   1
  455.       Caption      =   "___________________________"
  456.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  457.       Location     =   "Footer Block"
  458.       Height       =   270
  459.       Left         =   4590
  460.       Top          =   75
  461.       Width        =   2835
  462. End
  463.