Head Ache Reporting

[dave2009]

I have created a small program the invoices and stock takes etc and having trouble getting the Remmitance Advice to stay at the bottom of every invoice.
If its in the Page Footer I end up with 2 if the invoice end up being 2 pages long and if its in the Report Footer and only say two items are invoiced out the remmitance advice comes half way up the page.....is their any way of getting it to stay on the bottom of the page/pages.

Any help would be appreciated.


Regards Dave

 

[BobStubbs]

If you don't mind the Remittance Advice being on a separate sheet of paper:

-- Create the Remittance Advice in the Report Footer area.
-- Change the Report Footer Properties. Find the 'Force New Page' option on the [Format] tab, and set this to Before Section

You should now find that your report prints, with the Remittance Advice separated from the data, on the last page of the report.

Getting it to stay at the bottom of this page is now just a question of laying out the Advice with sufficient blank space above it in the Report Footer.

This will also deal with the problem you could have if there are enough records to almost fill a page - so if the Remittance Advice is not on its own sheet, then part would be at the end of the data records, and the rest on the next sheet.

I hope that this helps.

Bob Stubbs