A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Group Header Splits When Spanning Multiple Pages



 
 
Thread Tools Display Modes
  #1  
Old July 23rd, 2009, 02:03 AM posted to microsoft.public.access.reports
coder09
external usenet poster
 
Posts: 13
Default Group Header Splits When Spanning Multiple Pages

Hi,

I have a set of subreports, which belong to a larger report, in which
I use Group Headers with the "Repeat Section" property set to "Yes,"
so that the headers repeat when the subreports have enough data to
span multiple pages. The issue I'm having is that if a subreport's
header is at the bottom of the page and the entire header does not fit
onto it, Access will just cut it in half, so that half the header is
displayed on one page and the other half is displayed on the next.
The Detail section displays fine. Any ideas?

Thanks
  #2  
Old July 23rd, 2009, 12:05 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Group Header Splits When Spanning Multiple Pages

coder09 wrote:
I have a set of subreports, which belong to a larger report, in which
I use Group Headers with the "Repeat Section" property set to "Yes,"
so that the headers repeat when the subreports have enough data to
span multiple pages. The issue I'm having is that if a subreport's
header is at the bottom of the page and the entire header does not fit
onto it, Access will just cut it in half, so that half the header is
displayed on one page and the other half is displayed on the next.



Have you tried setting the header section's KeepTogether
property to Yes?

--
Marsh
MVP [MS Access]
  #3  
Old July 23rd, 2009, 01:04 PM posted to microsoft.public.access.reports
coder09
external usenet poster
 
Posts: 13
Default Group Header Splits When Spanning Multiple Pages

Yes, I've tried that on the group header, detail section, and also on
the sorting and grouping fields with no luck.

Thanks


Have you tried setting the header section's KeepTogether
property to Yes?

--
Marsh
MVP [MS Access]


  #4  
Old July 23rd, 2009, 02:47 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Group Header Splits When Spanning Multiple Pages

Using KeepTogether to Yes on the group header section should
be sufficient. Are you sure the stuff that is split across
a page boundary is in the group header section?

I don't see how it's relevant, but I feel like I should ask
if this happens any time the group header appears or just
the first time?

Maybe not what you want, but another thing to try is setting
the group's KeepTogether property to With First Detail

The only other thing I can think of that might cause the
problem is if you have some code that is fooling around with
the main report's Page Footer section.
--
Marsh
MVP [MS Access]


coder09 wrote:
Yes, I've tried that on the group header, detail section, and also on
the sorting and grouping fields with no luck.


Have you tried setting the header section's KeepTogether
property to Yes?

  #5  
Old July 23rd, 2009, 03:55 PM posted to microsoft.public.access.reports
coder09
external usenet poster
 
Posts: 13
Default Group Header Splits When Spanning Multiple Pages

I've removed all code and the issue is still occurring. I've also
tried the KeepTogether options that you've specified, with no luck.
None of the options effect the subreport at all, which is strange. I
should note, in the sorting and grouping menu, I have the following
groups defined:

=1 (this is used to allow for repeating the header in subreports)
Time (the time and date fields are used to control the sorting of the
report, maybe this is not the right way to do it?)
Date

Thank you
  #6  
Old July 23rd, 2009, 05:49 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Group Header Splits When Spanning Multiple Pages

coder09 wrote:

I've removed all code and the issue is still occurring. I've also
tried the KeepTogether options that you've specified, with no luck.
None of the options effect the subreport at all, which is strange. I
should note, in the sorting and grouping menu, I have the following
groups defined:

=1 (this is used to allow for repeating the header in subreports)
Time (the time and date fields are used to control the sorting of the
report, maybe this is not the right way to do it?)
Date



The repeat section header should be fine. Is that the
header that's being split? If it is, then you should
probably also have its ForceNewPage property set to Before
Section.

If it's a different group header that's split, please
provide more detailed information about the report.,

--
Marsh
MVP [MS Access]
  #7  
Old July 23rd, 2009, 06:06 PM posted to microsoft.public.access.reports
coder09
external usenet poster
 
Posts: 13
Default Group Header Splits When Spanning Multiple Pages

Yes, the repeat section header is being split. It is the only header
I have, but I have multiple other Field/Expression entries within the
Sorting and Grouping menu (Time and Date), if that effects anything.
I've tried the ForceNewPage property, but it did not have any effect.
Thank you
  #8  
Old July 23rd, 2009, 10:00 PM posted to microsoft.public.access.reports
coder09
external usenet poster
 
Posts: 13
Default Group Header Splits When Spanning Multiple Pages

Any more info on this? I've been working at this for hours and am
running out of ideas. Thanks
  #9  
Old July 23rd, 2009, 10:14 PM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Group Header Splits When Spanning Multiple Pages

Coder09,

What are your margins on your report and what is the minumum margins your
printer will except?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"coder09" wrote in message
...
Any more info on this? I've been working at this for hours and am
running out of ideas. Thanks



  #10  
Old July 23rd, 2009, 10:33 PM posted to microsoft.public.access.reports
coder09
external usenet poster
 
Posts: 13
Default Group Header Splits When Spanning Multiple Pages

Thanks for the reply. The margins are set appropriately, per what the
printer can accept.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.