"Continued" in Header and Repeat Footers

U

Uninvisible

I have a report that is made up of several sub reports linked by a
group ID. Each of the sub reports has a report footer and header.
There are instances when any of the sub reports span more than one
page. When that is the case, I'd like to include a "continued" in the
header of each successive page and have the footer, which is a line,
appear on all subsequent pages containing the information for a given
sub report (i.e., have the footer repeat similar to the "repeat
headers" function). I have tried driving this off of page counts, but
it doesn't seem to work. As the report stands, the headers repeat
without the word "continued" and the footer only appears at the end of
the record set, as illustrated below:

Current Functionality:

Page 1:
Header 1 Header 2
Detail
Detail
Detail

Page 2:
Header 1 Header 2
Detail
Detail
Detail

Page 3:
Header 1 Header 2
Detail
Detail
Detail
Footer

Desire Functionality

Page 1:
Header 1 Header 2
Detail
Detail
Detail
Footer <-- desired

Page 2:
Header 1 Header 2 (continued) <-- desired
Detail
Detail
Detail
Footer <-- desired

Page 3:
Header 1 Header 2 (continued) <-- desired
Detail
Detail
Detail
Footer <-- desired
 
M

Marshall Barton

Uninvisible said:
I have a report that is made up of several sub reports linked by a
group ID. Each of the sub reports has a report footer and header.
There are instances when any of the sub reports span more than one
page. When that is the case, I'd like to include a "continued" in the
header of each successive page and have the footer, which is a line,
appear on all subsequent pages containing the information for a given
sub report (i.e., have the footer repeat similar to the "repeat
headers" function). I have tried driving this off of page counts, but
it doesn't seem to work. As the report stands, the headers repeat
without the word "continued" and the footer only appears at the end of
the record set, as illustrated below:

Current Functionality:

Page 1:
Header 1 Header 2
Detail
Detail
Detail

Page 2:
Header 1 Header 2
Detail
Detail
Detail

Page 3:
Header 1 Header 2
Detail
Detail
Detail
Footer

Desire Functionality

Page 1:
Header 1 Header 2
Detail
Detail
Detail
Footer <-- desired

Page 2:
Header 1 Header 2 (continued) <-- desired
Detail
Detail
Detail
Footer <-- desired

Page 3:
Header 1 Header 2 (continued) <-- desired
Detail
Detail
Detail
Footer <-- desired

Add an invisible label (named lblCont) in the repeating
group header and set its Caption to "continued". To make
it appear on subsequent pages, use a line of code in the
detail section's Print event procedure:
Me.lblCont.Visible = True
and you can hide it on the first page by adding a line to
the group footer section's Print event:
Me.lblCont.Visible = False

There is no way to repeat a group footer. The only thing
that appears at the bottom of every page is the main
report's page footer. To further complicated the problem,
any calculated values you have in the group footer will not
be known until all the details have been processed on the
last page of the group, way too late to do anything about
displaying them in the footer on the first page of the
group.
 
U

Uninvisible

Uninvisible said:
I have a report that is made up of several sub reports linked by a
group ID.  Each of the sub reports has a report footer and header.
There are instances when any of the sub reports span more than one
page.  When that is the case, I'd like to include a "continued" in the
header of each successive page and have the footer, which is a line,
appear on all subsequent pages containing the information for a given
sub report (i.e., have the footer repeat similar to the "repeat
headers" function).  I have tried driving this off of page counts, but
it doesn't seem to work.  As the report stands, the headers repeat
without the word "continued" and the footer only appears at the end of
the record set, as illustrated below:
Current Functionality:
Page 1:
Header 1 Header 2
Detail
Detail
Detail
Page 2:
Header 1 Header 2
Detail
Detail
Detail
Page 3:
Header 1 Header 2
Detail
Detail
Detail
Footer
Desire Functionality
Page 1:
Header 1 Header 2
Detail
Detail
Detail
Footer <-- desired
Page 2:
Header 1 Header 2 (continued) <-- desired
Detail
Detail
Detail
Footer <-- desired
Page 3:
Header 1 Header 2 (continued) <-- desired
Detail
Detail
Detail
Footer <-- desired

Add an invisible label (named lblCont) in the repeating
group header and set its Caption to "continued".   To make
it appear on subsequent pages, use a line of code in the
detail section's Print event procedure:
    Me.lblCont.Visible = True
and you can hide it on the first page by adding a line to
the group footer section's Print event:
    Me.lblCont.Visible = False

There is no way to repeat a group footer.  The only thing
that appears at the bottom of every page is the main
report's page footer.  To further complicated the problem,
any calculated values you have in the group footer will not
be known until all the details have been processed on the
last page of the group, way too late to do anything about
displaying them in the footer on the first page of the
group.

--
Marsh
MVP [MS Access]- Hide quoted text -

- Show quoted text -

Thanks for the reply, worked like a charm. I figured there was no
real solution to the report footer conundrum. Had ideas of embedding
a subreport in a header of another report and leverage the repeat
function to simulate a report footer, but that doesn't seem to play
out as desired either. Thanks so much.
 
M

Marshall Barton

Uninvisible said:
Thanks for the reply, worked like a charm. I figured there was no
real solution to the report footer conundrum. Had ideas of embedding
a subreport in a header of another report and leverage the repeat
function to simulate a report footer, but that doesn't seem to play
out as desired either. Thanks so much.


The bottom of the page has to be known when the page starts
on the first section to appear after the page header. If
the bottom were changed (eg. by extending the detail
section) then CanGrow and the various levels of KeepTogether
could never figure out what to do.
 

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