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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|