On Oct 27, 12:09*am, Marshall Barton <marshbar...@wowway.com> wrote:
> Uninvisible wrote:
> >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.
|
Similar Threads
