blank section on report

  • Thread starter Thread starter Melanie
  • Start date Start date
M

Melanie

Hi,
I have a report that should be two pages long. When I
print the report, it is 3 pages long, and the second page
has the bottom half blank, with the rest of the data
showing up on a third page.
When I look at the design view, there are no gaps in my
data, but somehow, there is a huge gap when the report
prints out.
Any idea what is causing this?
Thanks for any help.
Melanie
 
Melanie,

There are two common reasons for getting more pages that you expect:

1. The report width is wider than the available width on the selected paper
size (paper width minus vertica margins), so it spills over to a second page
horizontally; unlikely that this is your case, for I would expect four pages
to come out of the printer.

2. Some section of your report (detail, group header, group footer etc.) has
its Force New Page property set to something other than None; reset to None
and it wil fix your problem.

HTH,
Nikos
 
I'm not sure exactly what it was, I moved around some of
the fields, and whatever it was, it fixed itself. Thanks
for your help! By the way, the second page is just
costing calculations that the users don't need to see. Is
there anyway to have the report automatically only print
out the first page? It's the only page anyone other than
myself has to see.
Thanks for any suggestions,
Melanie
 
Melanie,

The way you're thinking of it is rather complicated, requiring some VB code.
An easier alternative is to make a second copy of the report for your
personal use (so it shows the extra controls), and then in the first one
(for the other users) either delete those extra controls, or, if required
for other calculations, move them in the "left page" so they don't require a
"right" one and just make them invisible.

HTH,
Nikos
 
Nikos,
What do you mean by "left page" and "right page"?
If I just make them invisible and leave them where they
are, will that print only the first page?
Thanks again,
Melanie
 
Melanie,

By "right" page I was referring to the extra one you get when you have a
width spill-over. Sorry for the confusion.

Making the controls invisible will result in the exact same pages you get
anyway, just without those controls showing.

Nikos
 
Back
Top