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.

 

[Michiel Rapati-Kekkonen]

there we go

subreport: subR_Invoices
there we have a text box: Provision
in the group footer of this subreport there's a text box SumOfProvision and
in the Report footer SumOfProvisionR, both: =Sum([Provision])
in the main report there's a text box in the page footer called SubTotal: =
subR_Invoices.Report.SumOfProvision
and another referring in the same way to the other footer's text box.
This is of course for reasons of testing.

The text box holding the sum in the group footer shows the total over all,
so I can't use it this way,
the text box holding the sum of the Report footer shows 'a' subtotal indeed,
but of all the Provisions that show on this page PLUS the Provision in the
first row on the next page.
Which makes it a strange subtotal.

Did I formulate it properly this time?

Michiel

 

[Duane Hookom]

"in the main report there's a text box in the page footer" I don't generally
place any text boxes with aggregate totals in a page footer.

Do you have any link master/child properties set for the subreport?


--
Duane Hookom
Microsoft Access MVP

there we go

subreport: subR_Invoices
there we have a text box: Provision
in the group footer of this subreport there's a text box SumOfProvision and
in the Report footer SumOfProvisionR, both: =Sum([Provision])
in the main report there's a text box in the page footer called SubTotal: =
subR_Invoices.Report.SumOfProvision
and another referring in the same way to the other footer's text box.
This is of course for reasons of testing.

The text box holding the sum in the group footer shows the total over all,
so I can't use it this way,
the text box holding the sum of the Report footer shows 'a' subtotal indeed,
but of all the Provisions that show on this page PLUS the Provision in the
first row on the next page.
Which makes it a strange subtotal.

Did I formulate it properly this time?

Michiel

 

[Michiel Rapati-Kekkonen]

if it would work however it would be just how I want it.
I would say that the page footer would be the proper spot for a subtotal.

The MainReport shows the provision invoice that is to be sent,
the subform shows the invoices over which the agent gets his provision.
And yes, they are linked. It works properly,
only adding subtotals on each page would be nice...

Where then, and how, would you put a subtotal, totalling the invoices shown
in the subreport on that page?

Thanks for your input

Michiel

"in the main report there's a text box in the page footer" I don't
generally
place any text boxes with aggregate totals in a page footer.

Do you have any link master/child properties set for the subreport?


--
Duane Hookom
Microsoft Access MVP

there we go

subreport: subR_Invoices
there we have a text box: Provision
in the group footer of this subreport there's a text box SumOfProvision
and
in the Report footer SumOfProvisionR, both: =Sum([Provision])
in the main report there's a text box in the page footer called SubTotal:
=
subR_Invoices.Report.SumOfProvision
and another referring in the same way to the other footer's text box.
This is of course for reasons of testing.

The text box holding the sum in the group footer shows the total over
all,
so I can't use it this way,
the text box holding the sum of the Report footer shows 'a' subtotal
indeed,
but of all the Provisions that show on this page PLUS the Provision in
the
first row on the next page.
Which makes it a strange subtotal.

Did I formulate it properly this time?

Michiel

I don't understand what exactly you did. You haven't provided any
control
names or control sources or whatever.
--
Duane Hookom
Microsoft Access MVP


:

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



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
--
Duane Hookom
Microsoft Access MVP


:

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


Michiel Rapati-Kekkonen wrote:
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?

 

[Duane Hookom]

There is a KB article on page footer totals at
http://support.microsoft.com/kb/216311/en-us. I believe you would want to
have a text box in the report section with the subreport in order to grab the
value from the subreport. You could then reference this text box or maybe
creating a running sum on it.

--
Duane Hookom
Microsoft Access MVP

if it would work however it would be just how I want it.
I would say that the page footer would be the proper spot for a subtotal.

The MainReport shows the provision invoice that is to be sent,
the subform shows the invoices over which the agent gets his provision.
And yes, they are linked. It works properly,
only adding subtotals on each page would be nice...

Where then, and how, would you put a subtotal, totalling the invoices shown
in the subreport on that page?

Thanks for your input

Michiel

"in the main report there's a text box in the page footer" I don't
generally
place any text boxes with aggregate totals in a page footer.

Do you have any link master/child properties set for the subreport?


--
Duane Hookom
Microsoft Access MVP

there we go

subreport: subR_Invoices
there we have a text box: Provision
in the group footer of this subreport there's a text box SumOfProvision
and
in the Report footer SumOfProvisionR, both: =Sum([Provision])
in the main report there's a text box in the page footer called SubTotal:
=
subR_Invoices.Report.SumOfProvision
and another referring in the same way to the other footer's text box.
This is of course for reasons of testing.

The text box holding the sum in the group footer shows the total over
all,
so I can't use it this way,
the text box holding the sum of the Report footer shows 'a' subtotal
indeed,
but of all the Provisions that show on this page PLUS the Provision in
the
first row on the next page.
Which makes it a strange subtotal.

Did I formulate it properly this time?

Michiel




I don't understand what exactly you did. You haven't provided any
control
names or control sources or whatever.
--
Duane Hookom
Microsoft Access MVP


:

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



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
--
Duane Hookom
Microsoft Access MVP


:

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


Michiel Rapati-Kekkonen wrote:
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?