Last Report Page Blank - 2010

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Having a strange thing that I've never run into before. I have a report with
a zero-height group footer section which is set to force new page after
section, so that each item in the group begins at the top of its own page.
For some reason, when it gets to the end of the last group item, it still
forces a new page, resulting in a single blank page at the end of the
report.

I've been creating reports like this for years, and I've never had this
problem. Access never forced a new page after the last group in the report.
But I'm doing this in Access 2010, and something tells me that this is one
of the bugs in that version.

Anyway, was wondering if anyone else has run across this problem, and if
there are any known workarounds.

Thanks!
 
Neil said:
Having a strange thing that I've never run into before. I have a report
with a zero-height group footer section which is set to force new page
after section, so that each item in the group begins at the top of its own
page. For some reason, when it gets to the end of the last group item, it
still forces a new page, resulting in a single blank page at the end of
the report.

I've been creating reports like this for years, and I've never had this
problem. Access never forced a new page after the last group in the
report. But I'm doing this in Access 2010, and something tells me that
this is one of the bugs in that version.

Anyway, was wondering if anyone else has run across this problem, and if
there are any known workarounds.

Thanks!
Click to expand...
Had the same problem; if a section had "Force New Page after Section"
property. I Deleted the empty report footer to eliminated the extra page. It
looks like Access 2010 looks at the report footer differently from previous
versions.
 
ron paii said:
Had the same problem; if a section had "Force New Page after Section"
property. I Deleted the empty report footer to eliminated the extra page.
It looks like Access 2010 looks at the report footer differently from
previous versions.
Click to expand...
Well, clearly it's a bug. Hopefully they'll fix it in the 2010 SP1 -- if
they ever come out with it, that is!!

So what did you do as a workaround when you removed the footer?
 
ron paii said:
Had the same problem; if a section had "Force New Page after Section"
property. I Deleted the empty report footer to eliminated the extra page.
It looks like Access 2010 looks at the report footer differently from
previous versions.
Click to expand...

Interesting note: the database is an MDB file, and when I open it in 2003,
the report works fine - no blank page at the end. Clearly a glitch in 2010.
 
Neil said:
Well, clearly it's a bug. Hopefully they'll fix it in the 2010 SP1 -- if
they ever come out with it, that is!!

So what did you do as a workaround when you removed the footer?
Click to expand...
I didn't need it, the footer was empty.
"Force New Page after Section" was on the footer of a group section.
 
ron paii said:
I didn't need it, the footer was empty.
"Force New Page after Section" was on the footer of a group section.
Click to expand...

Yes, that's what I have - Force New Page After Section in the footer of a
group section, where the footer is empty. But I use that start a new page
with each group item. Otherwise, if you do a page break before the header
section of the group, then the first group ends up on page 2. So by putting
a Force New Page After Section in the empty footer section of the group, it
starts the next group on a new page.

So what I'm saying is, how did you get each group item to start on their own
page if you didn't do it with the footer section?

Thx
 
Neil said:
Yes, that's what I have - Force New Page After Section in the footer of a
group section, where the footer is empty. But I use that start a new page
with each group item. Otherwise, if you do a page break before the header
section of the group, then the first group ends up on page 2. So by
putting a Force New Page After Section in the empty footer section of the
group, it starts the next group on a new page.

So what I'm saying is, how did you get each group item to start on their
own page if you didn't do it with the footer section?

Thx
Click to expand...
I also put the Force new page in the group footer. The problem is the REPORT
footer will print on a new page after the group footer. If the Report footer
is empty, delete it.
 
ron paii said:
I also put the Force new page in the group footer. The problem is the
REPORT footer will print on a new page after the group footer. If the
Report footer is empty, delete it.
Click to expand...

Ah, I see what you're saying. I thought it was the group footer that was
showing up on the last page. But both the group footer and report footer are
zero-height, so it could be either. What you say makes sense.

Unfortunatately, though the report footer is empty, I can't delete it. I'm
using the report header, and the two go together. So I guess I'm stuck.

Interesting thing, though: I tested it in A2007, and no problem. It's only
in A2010. Hopefully this is something they're going to fix soon.

Thanks.
 
Neil,
Even though you cannot delete the report footer section (because you
need the report header section), you CAN change the "Force New Page"
property to NO inside the report footer section.

You only need the "Force New Page" setting in the group footer
section.

Fred
 
Neil,
Even though you cannot delete the report footer section (because you
need the report header section), you CAN change the "Force New Page"
property to NO inside the report footer section.

You only need the "Force New Page" setting in the group footer
section.

Fred

==============

Yes, that's right. I don't know if you read this thread, but that's not the
issue. The issue is that a glitch in Access 2010 (but not previous versions)
causes a blank page to appear at the end of a report that has a report
footer, which has the GROUP footer set to Force New Page. Apparently,
deleting the report footer resolves the problem. But the report footer never
had Force New Page in the first place, only the group footer. But this is a
bug in Access 2010.
 
Just a shot in the dark.

Are you sure it is not a margin issue when the last page is printed,it needs
another page ??
 
Phil Hunt said:
Just a shot in the dark.

Are you sure it is not a margin issue when the last page is printed,it
needs another page ??
Click to expand...
Yes, I'm sure. :-)

Try it yourself if you have 2010. Set a group footer to force a new page,
and include a report footer. See what happens.
 
Neil,
Even though you cannot delete the report footer section (because you
need the report header section), you CAN change the "Force New Page"
property to NO inside the report footer section.

You only need the "Force New Page" setting in the group footer
section.

Fred

==============

Yes, that's right. I don't know if you read this thread, but that's not the
issue. The issue is that a glitch in Access 2010 (but not previous versions)
causes a blank page to appear at the end of a report that has a report
footer, which has the GROUP footer set to Force New Page. Apparently,
deleting the report footer resolves the problem. But the report footer never
had Force New Page in the first place, only the group footer. But this is a
bug in Access 2010.
Click to expand...

Update: I had this happen to some reports I've been using for years with no problem. If I switch it from After Section to Before Section, it correctly renders with no blank pages. Somehow they reversed the logic in 2010...
 
Back
Top