Aleniko


I am trying to add a 'disclaimer' at the bottom of invoices. The thing is that the disclaimer should always print at the bottom of the last page. If the last page has only one item, the disclaimer should still print all the way at the bottom. The disclaimer is not a single line but a bunch of lines, and it may change.

I've added it to the summary band and I've tried to set the 'field position' to 'fixed relative to the bottom of band' but that won't help.

Any ideas

Thanks.



Re: Summary band in reports - VFP9

Daniel CW Tan


Hi,

I'd place the text in page footer band and in the "Print When" I'd put "_pageno=_pagetotal". This way the text will be printed in the footer area when it's the last page only.

Regards

Daniel






Re: Summary band in reports - VFP9

Aleniko

This works fine except that is takes a constant amount of space from the page footer off each page.

If I have half a page of legal blablas at the end of my invoice, each and every page is half empty because I've allocated that much space to the page footer.

I do check mark 'remove line if blank' - and it won't help.

Any other ideas

Thanks.





Re: Summary band in reports - VFP9

Daniel CW Tan

Have you tried the Reportlistener object It can SQUEEZETEXT into a field width so I think it'll work for you. The only problem is that the font get adjusted to "fit in" into the field so if with too many lines it may become unreadable.

Cheers.

Regards

Daniel





Re: Summary band in reports - VFP9

Garrett Fitzgerald

Have you tried making the textbox in the footer only one line tall, and allowing it to Stretch with overflow That seems to have worked when I tested it here.

Funnily enough, when I did _PAGENO = _PAGETOTAL, it wound up on the second-to-last page, since it forced the leftover lines onto an extra page. When I did RECNO() = RECCOUNT(), it only forced the last line onto the last page. Problem is, this method won't work if you have an order set on the table...




Re: Summary band in reports - VFP9

Aleniko

Yes I tried that - won't work.

Keep in mind that I have also a report summary. I get a mess when I try that.

Thanks.