Keeping Footers with Detail

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I have a report that has several footers with subreports. How do I stop the
subreports/footers from extending across the page break.

I want to keep all the data for a record on one page.

Thanks.
 
Ken said:
I have a report that has several footers with subreports. How do I stop the
subreports/footers from extending across the page break.

I want to keep all the data for a record on one page.
Click to expand...


Which record? The main report record or some/all
subreports?

In general, you can use a section's KeepTogether property to
keep the section on a page (assuming it fits on one page).
If you have more than one thing (subreport?) in a section
that you want to keep together, but not necessarily all on
the same page, then you need to put those things in separate
sections. If you are sufficiently below the limit of ten
groups, then you can add more groups based on the same
field/expression as an existing group and then spread the
things acorss the extra group's header and footer sections.
 
Hi Marsh,

Thanks for the information. I have 7 footer sections with various
information about the detail record. Not all the footers are displayed for
every record. Not every footer is a sub-report.

I am trying to get the detail (record) and any footers to stay on the same
page with the record.

I did not realize I could put my subreport in the detail. When I tried
something like that before my detail did not shrink to remove all the dead
space.

Thanks.
 
Ken said:
Thanks for the information. I have 7 footer sections with various
information about the detail record. Not all the footers are displayed for
every record. Not every footer is a sub-report.

I am trying to get the detail (record) and any footers to stay on the same
page with the record.

I did not realize I could put my subreport in the detail. When I tried
something like that before my detail did not shrink to remove all the dead
space.
Click to expand...


Now I am lost. How can you have 7 group levels for a single
detail record? If there really are more than one detail
record, then I don't understand how putting a summary
subreport in the detail section would make sense.

There is no way to keep the last/only detail with more than
one group footer sections. It can't be done even if there
is only one group footer if either the detail and/or the
group footer can grow.

On the shrinking issue, moot or not, you need to set the
CanShrink property for both the (text box or subreport)
control AND for the section that contains the control.
 
Back
Top