Page Break Between Label and Subreport

[Larry]

I have a report with about 5 subreports on it. Each subreport control
has an associated label over it, which tells what the data below
references (Assignment, Responsible Parties, etc.).

Since all of them can grow, I just hit a place where there is a lot of
data at the top part of the report, causing a page break. This causes
the label for the subreport to remain on the first page and the
subreport to show up on the next page.

I can't believe in all the years I have worked with Access that this
has never happened to me before! lol

Anyway, is there a way to make the subreport label stay with the
subreport control?

I know I can put the label, in the report pointed to by the subreport,
but if there is no data for one of the subreports, then the label would
not show up either, meaning there would just be a blank area on the
report and the users will not like a report that changes that much.

Any ideas?

 

[Marshall Barton]

I have a report with about 5 subreports on it. Each subreport control
has an associated label over it, which tells what the data below
references (Assignment, Responsible Parties, etc.).

Since all of them can grow, I just hit a place where there is a lot of
data at the top part of the report, causing a page break. This causes
the label for the subreport to remain on the first page and the
subreport to show up on the next page.

I can't believe in all the years I have worked with Access that this
has never happened to me before! lol

Anyway, is there a way to make the subreport label stay with the
subreport control?

I know I can put the label, in the report pointed to by the subreport,
but if there is no data for one of the subreports, then the label would
not show up either, meaning there would just be a blank area on the
report and the users will not like a report that changes that much.

The preferrred way to deal with that sort of thing is to use
Sorting and Grouping to add group header and footer sections
on a constant expression such as =1. Then you can place
each subreport and its label in separate sections with their
KeepTogether property set to Yes.

If you do not want to keep the entire subreport together on
the same page, then I only have one somewhat hokey idea.
Place the label on top of the subreport control and fiddle
the subreport's header section to have a line's worth of
blank space at the top of the section.

 

[Larry]

I can't do the Sorting/Grouping/Sections idea because the first two
subreports are side-by-side.

I'll give the "hokey" idea a try, but in the cases where there is no
data, I don't think this will help. But I'm game for anything.

Thanks.