having a problem with filemaker

I've looked everywhere to get some help, but haven't had any luck.

Here's the issue:

I'm trying to get my summary fields to shop up at the end all records, almost as if it were a record itself.

here's what i want it to look like:

johnson $5
smith $7
total $12

but when i set it up in the layout, here's what i get as a result:

johnson $5
total $12
smith $7
total $12


putting it in the footer won't work because these reports end up being 5 pages long.


so what i do is make 2 seperate layouts, one that looks like this:

johnson $5
smith $7

and one that looks like this:

total $12

then, what i do is print out the first report, 5 pages.

after that, i line up my second report(totals) so that it prints directly
below the last record, or in this example smith.


so i have to print the full report, then rig it so the totals will print on the last page.

i believe i came across the solution to this once while working on a layout, but i forgot what it is called.

any help would be much much much appreciated.

thanks!!!

 

finally it works!!!!!


thanks!!!!