carry subreport page header to next page

[Jacqueline]

I have developed a report that compiles a number of subreports into one
master report. It works great except when there is a page break which ever
subreport that is broken between the two pages does not carry the page header
to the next page.

The subreports are grouped and I have tried pulling the heading info out of
the group header and placing it in the page header for each sub, and I tried
using the keep header with first record, neither of those worked.

Any ideas??
Thanks much
Jacqueline

 

[Marshall Barton]

I have developed a report that compiles a number of subreports into one
master report. It works great except when there is a page break which ever
subreport that is broken between the two pages does not carry the page header
to the next page.

The subreports are grouped and I have tried pulling the heading info out of
the group header and placing it in the page header for each sub, and I tried
using the keep header with first record, neither of those worked.

Have you tried setting the **group** header section's
RepeatSection property to Yes? If not, that should do
something useful, but you may want to remove the page header
altogether.

If that's can't do what you want, please explain what you
are getting in the page header when there is a second page
in a subreport.

 

[Jacqueline]

Hi Marshall,

Yes, I did try using the keep together on the group header that did not work
either. Each subreport has one group, and then nested into the master report.
The master covers a number of different reporting errors for the department
schedulers.

If the subreport breaks between pages, the header info does not print at the
start of the data on the new page. Some of the schedulers get confused…(***
sigh***) if they do not have headers for the data at the top of the page.

I hope this gives you more info, I am starting to think they just need to
suck it up, but don't want to tell them that until I have exhausted all
options.... Obi-Wan You are my last hope...

Thanks again,
Jacqueline

 

[Jacqueline]

Marshall,
Well I feel really dumb now... after sending you the last email, I got to
poking around in my reports and found that I was working on the wrong
subreport. As soon as I set the group header to "repeat section" everything
works...

Thanks for your help..
Jacqueline

 

[Jacqueline]

David,
This came to me, not sure if it will go to Marshall, but the answer to your
questions is within the "Group By" function you have an option to "keep group
together on one page"

This will keep one group of information together rather than spliting it
between two pages. I don't know what version of Access you are using. I am in
2007 and the Group and Sort function is in the Grouping & Totals gallery, on
the Design tab of for your form.

Hope this helps
Jacqueline

 

[David K.]

Marshall Barton,

If you are still around would you explain how to go about setting up the
groups header section. I can't figure out exactly what you mean.