Last Report Page Blank - 2010

[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!

 

[ron paii]

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!

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.

 

[Neil]

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.

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?

 

[Neil]

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.

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.

 

[ron paii]

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?

I didn't need it, the footer was empty.
"Force New Page after Section" was on the footer of a group section.

 

[Neil]

I didn't need it, the footer was empty.
"Force New Page after Section" was on the footer of a group section.

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

 

[ron paii]

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

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.

 

[Neil]

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.

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.

 

[zuckermanf]

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]

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.

 

[Phil Hunt]

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 ??

 

[Neil]

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 ??

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.

 

[triadruid]

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.

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...