Totals go to next page

[Guest]

i have a report that list production per lender. the report is like 50 pages
long and on each page it has a particular lenders activity with the totals on
each page for that lender. in the report footer i have the totals for all
the lenders and it puts these on the last page with the last lender. i want
the totals at the end to be on a separate page how can i do this?

 

[Duane Hookom]

Try add a page break control at the very top of your Report Footer section
or set the "Force New Page" property of the Report Footer to "Before
Section".

 

[Guest]

it worked by putting before section i was putting after i dont quite
understand that but it works how do you add a page break control?
thanks for your help greately appreciated

 

[Duane Hookom]

Putting the break after the section would print a blank page after the
report footer section.

The page break control is in the Tool Box.

 

[Ken®]

just go to the under footer in the report and type that =sum([the sub total
fiels name]) and you will see that you have the general total in the last
page. hope its help you
(e-mail address removed)
ken