By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,804 Members | 1,627 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,804 IT Pros & Developers. It's quick & easy.

Sub-Report Header Won't Stay With Report Detail

P: n/a
I have several sub-reports in the footer of a main report. In certain
situations when one of the sub-reports is pushed down to near the
bottom of the page by the sub-reports above it, the sub-report report
header will display at the bottom of the page, but the detail displays
on the next page.

How can I force the sub-report header to display on the next page
together with its detail?

Aug 15 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
The subreport is in one of the sections of the main report.
Set that section's Keep Together property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Wayne" <cq*******@volcanomail.comwrote in message
news:11**********************@m37g2000prh.googlegr oups.com...
>I have several sub-reports in the footer of a main report. In certain
situations when one of the sub-reports is pushed down to near the
bottom of the page by the sub-reports above it, the sub-report report
header will display at the bottom of the page, but the detail displays
on the next page.

How can I force the sub-report header to display on the next page
together with its detail?
Aug 15 '07 #2

P: n/a
Thanks for the reply Allen. I already have the Keep Together property
set.

I've noticed that depending on where the page ends, sometimes even the
header is split across pages, with the top portion of the header at
the bottom of one page and the bottom half of the header at the top of
the next. The fact that these subreports are in the footer of the
main report may have something to do with this strange behaviour.

At the end of the day, I may have to live with it.
Aug 15 '07 #3

P: n/a
If they are in the Page Footer, they are fixed height, i.e. they cannot
stretch/shrink, so you will get the behavior you describe.

If they are in the Report Footer, they should work fine.
(But it will only appear on the final page of the report.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Wayne" <cq*******@volcanomail.comwrote in message
news:11**********************@x40g2000prg.googlegr oups.com...
Thanks for the reply Allen. I already have the Keep Together property
set.

I've noticed that depending on where the page ends, sometimes even the
header is split across pages, with the top portion of the header at
the bottom of one page and the bottom half of the header at the top of
the next. The fact that these subreports are in the footer of the
main report may have something to do with this strange behaviour.

At the end of the day, I may have to live with it.
Aug 16 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.