How to Shake Off a Last Blank Page

[doyle60]

I have a report that prints out orders and it has a section,
groupfooter2, in it for a sub report.

Sometimes there is no data in the sub report and that is fine.

All works well except for one thing: When the last order in a range
picked in a Print form does not have data for the sub, the report
prints out a blank last page. So a 10 page report becomes 11 pages
and a 4 page report prints out 5 pages. But if the last order has
data in the sub, it doesn't produce a blank last page.

For the life of me, I can't shake the last page from this report.

The sub is in groupfooter2 and is the only other section other than
the detail section.

The Sub section is the first section of the sorting and grouping
window. This may seem odd but sometimes two or more orders share this
sub data which is a long memo.

So I have it printing out like this, where the numbers are POs:

74776
74777
74778
Memo for 74777 and 74778
74779
Memo for 74779
74780
74781

There is a sub in the sub for explaining which POs the Memo belongs to
so there is no confusion there.

So all works just wonderfully. But that last blank page is bothering
me.

Any ideas what it is?

If I delete the sub but leave the footer: The blank appears.
If I delete the footer altogether: The blank disappears.
If I make the section invisible: The blank appears.
If I make the height of the section zero but leave the sub there: The
blank appears.

Matt

 

[doyle60]

There is no footer or any footer. When I put one on, it reacts the
same way.

After typing the first sentence above, I had a wonderful idea. I
colored the backgrounds of each section a different color. I then
previewed my wonderful rainbow report. The blank page is white!
There is no section with white on it!

I have a plan b that works fine. I put data in the query that can
work around having a sub section in the report. But it would be
easier and better to do it the original way so I can have code to
remove the section if the user wants to. I can put the code in the
query but it is harder to shorten the document that way. A blank page
could print out now and then owing to it just happening to hit that
border, as you probably understand.

So I have solutions but whatever!

Thanks for the help. I've tried everything!

Matt

 

[Marshall Barton]

There is no footer or any footer. When I put one on, it reacts the
same way.

After typing the first sentence above, I had a wonderful idea. I
colored the backgrounds of each section a different color. I then
previewed my wonderful rainbow report. The blank page is white!
There is no section with white on it!

I have a plan b that works fine. I put data in the query that can
work around having a sub section in the report. But it would be
easier and better to do it the original way so I can have code to
remove the section if the user wants to. I can put the code in the
query but it is harder to shorten the document that way. A blank page
could print out now and then owing to it just happening to hit that
border, as you probably understand.

That still sounds like either the main report or the
subreport has a Report Footer section that is probably blank
or has ForceNewPage set.

 

[doyle60]

It's just not it. I am not forcing a page on anything.

I think it has to do with there being no link for the sub on the last
PO.

But I've come to like plan B over the last few hours and will go with
that. I will be changing things about so won't be able to test any
new cures you may come up with. Thanks for your concern,

Matt