Developer 2000 Reports 2.5

[DBID]

I am developing an Invoice. For invoice details like Item,Quantity, Price and amount i have a repeating frame. At the bottom of the page I have a frame which contains the invoice total and some text. This layout works fine as long as there is no overflow. If the invoice lines spill over to the next page the invoice footer containing invoice total and the text prints on the top of the next page or whereever the invoice lines repeating frame ends but not at the bottom of the page. I want the invoice footer to always print at the bottom of the page and just once at the end of each invoice.
I will appreciate it if you could help me out.

Thanks

 

[cfsenorin]

Try this one:

If your layout looks like this:

Invoice # Item Price Quantity Amount

And your grouping should look like this
Invoice
Totals
Item
Price
Quantity
Amount

Inclose your totals inside your a frame. 'set Print Object On' to 'Last page'. Put this frame below and outside your item repeating frame but inside your invoice repeating frame.

Your output will look like this:

Invoice Item Price Quantity Amount
A B 1 1 1
C 1 1 1
Total 2 2 2

B .... and so on

Hope it helps.