Report footer printing on separate page

G

GoBrowns!

Help! I have tried everything I can think of!

I have a report with several subtotaled sections, and a subreport. A "grand
total" is supposed to display after the last entry/subtotal of the main
report. For some reason, that Grand Total (which is in the report footer)
prints on the next page of the report, not directly under the report. It will
print on the top of the next page, with the subreport immediately following
it.

How can I get the "grand total" to print right under the main report where
it should? I have looked at Group Together, Force Page Break, and just about
any other thing I can think of. Please help!

Thanks!
 
A

Allen Browne

Temporarily set the Force New Page property to None for all sections of the
report, delete any Page Break Control anywhere in the report, and comment
out any code in the report's module.

If that fixes the problem, then start adding back the properties you need.
You may be able to solve the problem by setting Force New Page to Yes for a
group header instead of for the group footer (assuming there's no report
header to worry about.)

If it does not fix the problem, double-check the height of the Report Footer
section. Keep it minimal.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top