home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / PLAGED.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  14.0 KB  |  424 lines
  1. VERSION 2.00
  2. Begin Report PLAGED.REP
  3.       Caption      =   "PLAGED.REP"
  4.       Width        =   11295
  5.       Height       =   15510
  6.       Reportheader =   930
  7.       Header       =   585
  8.       Transaction  =   11775
  9.       SubTotal     =   0
  10.       Footer       =   765
  11.       Pagefooter   =   15000
  12.       Replicate    =   390
  13.       Style        =   16
  14.       Query        =   "PLTRAN ALL ORDER BY PLTRAN.PTCODE"
  15.       Macro        =   "1OF:@REPVARS.REPSTR(0) = "0""
  16.       Macro        =   "1OF:@REPVARS.REPSTR(1) = "0""
  17.       Macro        =   "2LU:Select from PLNAME where PLNAME.PNCODE=PLTRAN.PTCODE"
  18.       Macro        =   "2OF:@REPVARS.REPTOT(0) = @REPVARS.REPTOT(0)+PLTRAN.PTOUTSTAND"
  19.       Macro        =   "2OF:@REPVARS.REPTOT(1) = PERIOD(DATE(),PLTRAN.PTTXNDATE)"
  20.       Macro        =   "2CD:When PLTRAN.PTTXNTYPE="P" & PLTRAN.PTALLOC=" " then REPTOT(1)=-1"
  21.       Macro        =   "2CD:When REPTOT(1)=-1 then REPSTR(0)=STR(REPSTR(0)+PLTRAN.PTOUTSTAND,10,2)"
  22.       Macro        =   "2CD:When REPTOT(1)=0 then REPTOT(2)=REPTOT(2)+PLTRAN.PTOUTSTAND"
  23.       Macro        =   "2CD:When REPTOT(1)=1 then REPTOT(3)=REPTOT(3)+PLTRAN.PTOUTSTAND"
  24.       Macro        =   "2CD:When REPTOT(1)=2 then REPTOT(4)=REPTOT(4)+PLTRAN.PTOUTSTAND"
  25.       Macro        =   "2CD:When REPTOT(1)=3 then REPTOT(5)=REPTOT(5)+PLTRAN.PTOUTSTAND"
  26.       Macro        =   "3OF:@REPVARS.REPTOT(6) = REPTOT(6)+REPTOT(2)"
  27.       Macro        =   "3OF:@REPVARS.REPTOT(7) = REPTOT(7)+REPTOT(3)"
  28.       Macro        =   "3OF:@REPVARS.REPTOT(8) = REPTOT(8)+REPTOT(4)"
  29.       Macro        =   "3OF:@REPVARS.REPTOT(9) = REPTOT(9)+REPTOT(5)"
  30.       Macro        =   "3OF:@REPVARS.REPSTR(1) = STR(REPSTR(1)+REPSTR(0),10,2)"
  31.       Macro        =   "3OF:@REPVARS.REPTOT(0) = 0"
  32.       Macro        =   "3OF:@REPVARS.REPTOT(1) = 0"
  33.       Macro        =   "3OF:@REPVARS.REPTOT(2) = 0"
  34.       Macro        =   "3OF:@REPVARS.REPTOT(3) = 0"
  35.       Macro        =   "3OF:@REPVARS.REPTOT(4) = 0"
  36.       Macro        =   "3OF:@REPVARS.REPTOT(5) = 0"
  37.       Macro        =   "3OF:@REPVARS.REPSTR(0) = "0""
  38.       Macro        =   "4OF:@REPVARS.REPTOT(5) = REPTOT(9)+REPTOT(8)+REPTOT(7)+REPTOT(6)+REPSTR(1)"
  39.       Macro        =   "4PP:@REPVARS.REPTOT(5) = 0"
  40.       Macro        =   "4PP:@REPVARS.REPTOT(6) = 0"
  41.       Macro        =   "4PP:@REPVARS.REPTOT(7) = 0"
  42.       Macro        =   "4PP:@REPVARS.REPTOT(8) = 0"
  43.       Macro        =   "4PP:@REPVARS.REPTOT(9) = 0"
  44.       Macro        =   "4PP:@REPVARS.REPSTR(1) = "0""
  45.       BreakOn      =   "PLTRAN.PTCODE"
  46. End
  47. Begin Control LABEL
  48.       Type         =   "Label"
  49.       Style        =   12
  50.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  51.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  52.       Location     =   "Reportheader Block"
  53.       Height       =   285
  54.       Left         =   135
  55.       Top          =   135
  56.       Width        =   10890
  57. End
  58. Begin Control LABEL
  59.       Type         =   "Label"
  60.       Style        =   4
  61.       Caption      =   "Aged Creditors List"
  62.       Font         =   "-315|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  63.       Location     =   "Reportheader Block"
  64.       Height       =   420
  65.       Left         =   135
  66.       Top          =   405
  67.       Width        =   10890
  68. End
  69. Begin Control LABEL
  70.       Type         =   "Label"
  71.       Style        =   9
  72.       Caption      =   "DTOC(DATE())"
  73.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  74.       Location     =   "Reportheader Block"
  75.       Height       =   285
  76.       Left         =   135
  77.       Top          =   585
  78.       Width        =   1410
  79. End
  80. Begin Control LABEL
  81.       Type         =   "Label"
  82.       Style        =   10
  83.       Caption      =   ""Page "+PAGENUM()"
  84.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  85.       Location     =   "Reportheader Block"
  86.       Height       =   285
  87.       Left         =   9285
  88.       Top          =   585
  89.       Width        =   1800
  90. End
  91. Begin Control LABEL
  92.       Type         =   "Label"
  93.       Style        =   1
  94.       Caption      =   "Supplier ID"
  95.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  96.       Location     =   "Header Block"
  97.       Height       =   270
  98.       Left         =   135
  99.       Top          =   150
  100.       Width        =   1080
  101. End
  102. Begin Control LABEL
  103.       Type         =   "Label"
  104.       Style        =   2
  105.       Caption      =   "Current"
  106.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  107.       Location     =   "Header Block"
  108.       Height       =   270
  109.       Left         =   4230
  110.       Top          =   150
  111.       Width        =   945
  112. End
  113. Begin Control LABEL
  114.       Type         =   "Label"
  115.       Style        =   2
  116.       Caption      =   "1 Month"
  117.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  118.       Location     =   "Header Block"
  119.       Height       =   270
  120.       Left         =   3375
  121.       Top          =   150
  122.       Width        =   810
  123. End
  124. Begin Control LABEL
  125.       Type         =   "Label"
  126.       Style        =   2
  127.       Caption      =   "2 Months"
  128.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  129.       Location     =   "Header Block"
  130.       Height       =   270
  131.       Left         =   2235
  132.       Top          =   150
  133.       Width        =   945
  134. End
  135. Begin Control LABEL
  136.       Type         =   "Label"
  137.       Style        =   2
  138.       Caption      =   "C/R Limit"
  139.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  140.       Location     =   "Header Block"
  141.       Height       =   270
  142.       Left         =   7530
  143.       Top          =   150
  144.       Width        =   810
  145. End
  146. Begin Control LABEL
  147.       Type         =   "Label"
  148.       Style        =   2
  149.       Caption      =   "Total"
  150.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  151.       Location     =   "Header Block"
  152.       Height       =   270
  153.       Left         =   6465
  154.       Top          =   150
  155.       Width        =   810
  156. End
  157. Begin Control LABEL
  158.       Type         =   "Label"
  159.       Style        =   2
  160.       Caption      =   "Unallocated"
  161.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  162.       Location     =   "Header Block"
  163.       Height       =   270
  164.       Left         =   5190
  165.       Top          =   150
  166.       Width        =   1080
  167. End
  168. Begin Control LABEL
  169.       Type         =   "Label"
  170.       Style        =   2
  171.       Caption      =   "3 Months +"
  172.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  173.       Location     =   "Header Block"
  174.       Height       =   270
  175.       Left         =   1275
  176.       Top          =   150
  177.       Width        =   945
  178. End
  179. Begin Control SNCREDIT
  180.       Type         =   "Text"
  181.       Style        =   0
  182.       Fieldname    =   "PNDEBIT"
  183.       Filename     =   "PLNAME"
  184.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  185.       Location     =   "Transaction Block"
  186.       Height       =   270
  187.       Left         =   7485
  188.       Top          =   105
  189.       Width        =   945
  190. End
  191. Begin Control LABEL
  192.       Type         =   "Label"
  193.       Style        =   10
  194.       Caption      =   "STR(@REPVARS.REPTOT(0),10,2)"
  195.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  196.       Location     =   "Transaction Block"
  197.       Height       =   285
  198.       Left         =   6300
  199.       Top          =   105
  200.       Width        =   1005
  201. End
  202. Begin Control LABEL
  203.       Type         =   "Label"
  204.       Style        =   10
  205.       Caption      =   "STR(@REPVARS.REPTOT(5),10,2)"
  206.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  207.       Location     =   "Transaction Block"
  208.       Height       =   285
  209.       Left         =   1290
  210.       Top          =   105
  211.       Width        =   945
  212. End
  213. Begin Control LABEL
  214.       Type         =   "Label"
  215.       Style        =   10
  216.       Caption      =   "STR(@REPVARS.REPTOT(2),10,2)"
  217.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  218.       Location     =   "Transaction Block"
  219.       Height       =   285
  220.       Left         =   4260
  221.       Top          =   105
  222.       Width        =   945
  223. End
  224. Begin Control LABEL
  225.       Type         =   "Label"
  226.       Style        =   10
  227.       Caption      =   "STR(@REPVARS.REPTOT(3),10,2)"
  228.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  229.       Location     =   "Transaction Block"
  230.       Height       =   285
  231.       Left         =   3255
  232.       Top          =   105
  233.       Width        =   945
  234. End
  235. Begin Control LABEL
  236.       Type         =   "Label"
  237.       Style        =   10
  238.       Caption      =   "STR(@REPVARS.REPTOT(4),10,2)"
  239.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  240.       Location     =   "Transaction Block"
  241.       Height       =   285
  242.       Left         =   2280
  243.       Top          =   105
  244.       Width        =   945
  245. End
  246. Begin Control SNACCOUNT
  247.       Type         =   "Text"
  248.       Style        =   0
  249.       Fieldname    =   "PNCODE"
  250.       Filename     =   "PLNAME"
  251.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  252.       Location     =   "Transaction Block"
  253.       Height       =   270
  254.       Left         =   195
  255.       Top          =   105
  256.       Width        =   1080
  257. End
  258. Begin Control SNNAME
  259.       Type         =   "Text"
  260.       Style        =   0
  261.       Fieldname    =   "PNNAME"
  262.       Filename     =   "PLNAME"
  263.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  264.       Location     =   "Transaction Block"
  265.       Height       =   270
  266.       Left         =   8505
  267.       Top          =   105
  268.       Width        =   2700
  269. End
  270. Begin Control LABEL
  271.       Type         =   "Label"
  272.       Style        =   10
  273.       Caption      =   "STR(REPSTR(0),10,2)"
  274.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  275.       Location     =   "Transaction Block"
  276.       Height       =   285
  277.       Left         =   5280
  278.       Top          =   105
  279.       Width        =   945
  280. End
  281. Begin Control LABEL
  282.       Type         =   "Label"
  283.       Style        =   10
  284.       Caption      =   "STR(@REPVARS.REPTOT(9),10,2)"
  285.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  286.       Location     =   "Footer Block"
  287.       Height       =   285
  288.       Left         =   1290
  289.       Top          =   480
  290.       Width        =   945
  291. End
  292. Begin Control LABEL
  293.       Type         =   "Label"
  294.       Style        =   10
  295.       Caption      =   "STR(@REPVARS.REPTOT(8),10,2)"
  296.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  297.       Location     =   "Footer Block"
  298.       Height       =   285
  299.       Left         =   2280
  300.       Top          =   480
  301.       Width        =   945
  302. End
  303. Begin Control LABEL
  304.       Type         =   "Label"
  305.       Style        =   10
  306.       Caption      =   "STR(@REPVARS.REPTOT(7),10,2)"
  307.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  308.       Location     =   "Footer Block"
  309.       Height       =   285
  310.       Left         =   3255
  311.       Top          =   480
  312.       Width        =   945
  313. End
  314. Begin Control LABEL
  315.       Type         =   "Label"
  316.       Style        =   10
  317.       Caption      =   "STR(@REPVARS.REPTOT(6),10,2)"
  318.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  319.       Location     =   "Footer Block"
  320.       Height       =   285
  321.       Left         =   4260
  322.       Top          =   480
  323.       Width        =   945
  324. End
  325. Begin Control LABEL
  326.       Type         =   "Label"
  327.       Style        =   10
  328.       Caption      =   "STR(@REPVARS.REPTOT(5),10,2)"
  329.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  330.       Location     =   "Footer Block"
  331.       Height       =   285
  332.       Left         =   6300
  333.       Top          =   480
  334.       Width        =   1005
  335. End
  336. Begin Control LABEL
  337.       Type         =   "Label"
  338.       Style        =   2
  339.       Caption      =   "3 Months +"
  340.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  341.       Location     =   "Footer Block"
  342.       Height       =   270
  343.       Left         =   1275
  344.       Top          =   210
  345.       Width        =   945
  346. End
  347. Begin Control LABEL
  348.       Type         =   "Label"
  349.       Style        =   2
  350.       Caption      =   "2 Months"
  351.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  352.       Location     =   "Footer Block"
  353.       Height       =   270
  354.       Left         =   2235
  355.       Top          =   210
  356.       Width        =   945
  357. End
  358. Begin Control LABEL
  359.       Type         =   "Label"
  360.       Style        =   2
  361.       Caption      =   "1 Month"
  362.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  363.       Location     =   "Footer Block"
  364.       Height       =   270
  365.       Left         =   3375
  366.       Top          =   210
  367.       Width        =   810
  368. End
  369. Begin Control LABEL
  370.       Type         =   "Label"
  371.       Style        =   2
  372.       Caption      =   "Current"
  373.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  374.       Location     =   "Footer Block"
  375.       Height       =   270
  376.       Left         =   4230
  377.       Top          =   210
  378.       Width        =   945
  379. End
  380. Begin Control LABEL
  381.       Type         =   "Label"
  382.       Style        =   2
  383.       Caption      =   "Total"
  384.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  385.       Location     =   "Footer Block"
  386.       Height       =   270
  387.       Left         =   6465
  388.       Top          =   210
  389.       Width        =   810
  390. End
  391. Begin Control LABEL
  392.       Type         =   "Label"
  393.       Style        =   1
  394.       Caption      =   "Total"
  395.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  396.       Location     =   "Footer Block"
  397.       Height       =   270
  398.       Left         =   135
  399.       Top          =   480
  400.       Width        =   810
  401. End
  402. Begin Control LABEL
  403.       Type         =   "Label"
  404.       Style        =   10
  405.       Caption      =   "STR(REPSTR(1),10,2)"
  406.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  407.       Location     =   "Footer Block"
  408.       Height       =   285
  409.       Left         =   5280
  410.       Top          =   480
  411.       Width        =   945
  412. End
  413. Begin Control LABEL
  414.       Type         =   "Label"
  415.       Style        =   2
  416.       Caption      =   "Unallocated"
  417.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  418.       Location     =   "Footer Block"
  419.       Height       =   270
  420.       Left         =   5190
  421.       Top          =   210
  422.       Width        =   1080
  423. End
  424.