Header and/or footer should be suppressed

G

Guest

I have a report which is sorted by Branch. When Branch changes the title and
header are printed on the page. All of the detail records are complete on
one page, however the report prints the title and header on the next page
with no detail records. Is there anyway to suppress a header and/or footer
if there are no more detail records ?
 
M

Marshall Barton

rmcompute said:
I have a report which is sorted by Branch. When Branch changes the title and
header are printed on the page. All of the detail records are complete on
one page, however the report prints the title and header on the next page
with no detail records. Is there anyway to suppress a header and/or footer
if there are no more detail records ?


Reports don't print an extra page with a header unless you
do something to tell it that's what you want.

If you have a group footer section, make sure its
ForceNewPage property is not set.
 
G

Guest

Force New Page is set to None, but the report prints a header and footer on the
next page when the number of records contained in the branch is exactly the
amount that fits on one page. If it is less, this does not happen and if it
is more, the header and footer do print as they should on the next page with
the detail records. Is there a way to stop the header and footer from
printing when the amount of records per branch is exactly the amount that fit
 
M

Marshall Barton

No, there is event for this kind of thing because the
situation should not come up.

There must be something to print on that "extra" page. The
most likely is to check for extra space below the lowest
control in the detail section. If you are having trouble
identifying the source of whatever is spilling over to the
next page, try setting each section's and the lowest
control's BackColor to various colors so you can see some
kind of indication of what's going on.
 

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