how to make a header appear when subreport goes to the next page

[Michiel Rapati-Kekkonen]

Hi,

I have a subreport on my report.
When there's a lot of rows in the subreport, it continues on the next page
but
without the stuff in my header.
I tried to put it in the report header, the page header and a group header
to no avail.

where should I put it?

thanks in advance!

Michiel

Vista 64
Access 2007

 

[Duane Hookom]

Put the labels in a top level group header based a constant expression like:
=1
Then set the Repeat Section property of the new group header to Yes.

 

[Michiel Rapati-Kekkonen]

Yes, that did it
like a charm as they say here.
Where did you learn about this?
Is there some secret MVP course?

But
one answer leads, as often, immediately to new questions:
this works for the header,
but is there also something like this for the footer,
so that it can show a subtotal for each page?
There's no Repeat Section for the footer...

hope for more gems, TIA!

Michiel

 

[Rick Brandt]

Yes, that did it
like a charm as they say here.
Where did you learn about this?
Is there some secret MVP course?

But
one answer leads, as often, immediately to new questions:
this works for the header,
but is there also something like this for the footer,
so that it can show a subtotal for each page?
There's no Repeat Section for the footer...

hope for more gems, TIA!

There is no equivelent for a footer that I know of.

Can you put what you want in the PageFooter of the main report?

 

[Michiel Rapati-Kekkonen]

thanks for your reply.
there's certainly room for it,
but do you mean that a field in the page footer could read the sum field in
the subreport
at the moment the subreport reaches the end of the page?

Michiel

 

[Duane Hookom]

You can generally reference the value in a text box from the subreport with a
text box in the main report and a control source like:
=SubRptControlName.Report.ControlNameOnSubreport

 

[Michiel Rapati-Kekkonen]

thank you
how clever that it sees where the subreport breaks off.
ha, but I'm gonna do it.

thanks

Michiel

 

[Michiel Rapati-Kekkonen]

I did it but
I have two footers: a ReportFooter and 'Duane's' group footer in my
subreport.
in both footers I have a field that sums a field in the body of the
subreport.
de groupfooter shows the total total, the reportfooter a subtotal,
but that subtotal is the total until where it breaks off, Plus the first row
on the next page.
I experimented a bit, but did not improve.

where did I go wrong

TIA!

Michiel

 

[Duane Hookom]

I don't understand what exactly you did. You haven't provided any control
names or control sources or whatever.