Sub-Report not going to next page

  • Thread starter Thread starter sportmetro
  • Start date Start date
S

sportmetro

I have a sub-report in the page footer section of a main report. The
main report has several pages as does the sub report. When I go to the
next page of the main report the sub-report stays on the first age. Is
there anyway to change this so that the sub-report goes to the next
page aswell?
 
sportmetro said:
I have a sub-report in the page footer section of a main report. The
main report has several pages as does the sub report. When I go to the
next page of the main report the sub-report stays on the first age. Is
there anyway to change this so that the sub-report goes to the next
page aswell?
Click to expand...


The Page Footer can not grow, so, No, there is no way to do
that.

If you want it to span mulitiple pages, why would you want
to use the page footer? Wouldn't the Report Footer be more
appropriate?
 
Marshall Barton said:
The Page Footer can not grow, so, No, there is no way to do
that.

If you want it to span mulitiple pages, why would you want
to use the page footer? Wouldn't the Report Footer be more
appropriate?
Click to expand...

If I place the sub-report into the report footer it only appears on
the last page of the main report. I need the sub report to appear on
all pages. Is there any way to do this?
 
sportmetro said:
If I place the sub-report into the report footer it only appears on
the last page of the main report. I need the sub report to appear on
all pages. Is there any way to do this?
Click to expand...

I don't think that makes any sense - you want a multi page
subreport to appear on every page - sounds like a self
contradiction to me.

Remember that a Page header/footer can not grow, there can
be no page boundaries in a page header/footer and each
section's design space is limitted to 22".

How about a group footer? Is there any way to organize the
report's data into "page" size groups?
 
Marshall Barton said:
I don't think that makes any sense - you want a multi page
subreport to appear on every page - sounds like a self
contradiction to me.

Remember that a Page header/footer can not grow, there can
be no page boundaries in a page header/footer and each
section's design space is limitted to 22".

How about a group footer? Is there any way to organize the
report's data into "page" size groups?
Click to expand...

I will try and explain what I am trying to do. I need two separate
sets of data to appear on the report page. The first needs to appear
in the top half of the page and the send appear on the bottom. I don't
think I can group these two sets of data as they start to appear
before and after each other, they need to be totally separate. Hence
trying to put a sub report in the page footer section. However when
this second set of data is large I need it to grow to a second page.
 
sportmetro said:
I will try and explain what I am trying to do. I need two separate
sets of data to appear on the report page. The first needs to appear
in the top half of the page and the send appear on the bottom. I don't
think I can group these two sets of data as they start to appear
before and after each other, they need to be totally separate. Hence
trying to put a sub report in the page footer section. However when
this second set of data is large I need it to grow to a second page.
Click to expand...


I still don't have a good picture of how you want it to work
under all those various circumstances.

Why not put the subreport at the bottom of the detail
section?
 
Marshall Barton said:
I still don't have a good picture of how you want it to work
under all those various circumstances.

Why not put the subreport at the bottom of the detail
section?
Click to expand...

The main reports record source is a query, which queries two linked
tables. If I put the sub-report in the detail section (or any other
group header/footer section) it is printed after each record returned
by the query. I only want this sub-report to appear once on any page.
 
sportmetro said:
The main reports record source is a query, which queries two linked
tables. If I put the sub-report in the detail section (or any other
group header/footer section) it is printed after each record returned
by the query. I only want this sub-report to appear once on any page.
Click to expand...


You're not going to get a multipage subreport to work in the
page footer section, so we have to try to find something
else that might come close.

About the only thing I can think of is to put the subreport
in the detail section and make it invisible until the detail
gets low enough on the page.

Do you have grouping? How big are the group footers? Can
they grow? Are the group headers/footers forced to a page
boundary?

How big is the detail section? Can it grow?
 
Marshall Barton said:
You're not going to get a multipage subreport to work in the
page footer section, so we have to try to find something
else that might come close.

About the only thing I can think of is to put the subreport
in the detail section and make it invisible until the detail
gets low enough on the page.

Do you have grouping? How big are the group footers? Can
they grow? Are the group headers/footers forced to a page
boundary?

How big is the detail section? Can it grow?
Click to expand...

Thanks for all the help, but this is starting to become far to
involved. I have decided to cut down on the data in the sub-report so
that is never grows beyoned one page.
 
sportmetro said:
Thanks for all the help, but this is starting to become far to
involved. I have decided to cut down on the data in the sub-report so
that is never grows beyoned one page.
Click to expand...


That sounds like a good decision. It certainly would have
gotten very involved with all kinds of tricks and, depending
on the specifics of your report, might not have worked in
all situations.
 
Back
Top