"My guess is this is being caused somehow by the report equivalent of "Widow
and Orphan Control".
In general, people don't want to see a group header on a page without any
details below it. So if that's about to happen, we push the group header to
the next page to be with its details.
Similarly, people generally don't want to see a group footer on a page
without any details above it. So if that's about to happen, we pull at
least one detail row from the previous page down to be with the group
footer.
In your case you explicitly want the footer on a page by itself. However,
there's no way to request this explicitly, so I'm not entirely sure how
you're managing to force the subreport onto a new page. Perhaps it is
somehow related to the size of the subreport? However that happens, it
brings the last detail row with it. At that point, it's possible that the
detail row plus the subreport are collectively too large to fit on the page
so the subreport gets moved (a second time?) to the next page. It sure
seems like there's something screwy going on here and it might be a bug. If
possible, I'd like to take a look at the RDL for your report to see if I can
reproduce the problem here (I've tried with my own samples and can't make it
happen, so there's something specific to your report that I'll need to
replicate).
"
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Eddie Smith" <anon...@discussions.microsoft.com> wrote in message
news:3273CF17-F323-486D...@microsoft.com...
> I've got a report that has a group which has 5 rows in each group. The
first 3 fields always fit on a single line while the other 2 fields may have
multiple lines. When I view the report in print preview mode, there are
times when a single line will show on a page then eject to the next page (in
this instance field 2 of the 5).
> I really want the report to flow to the bottom of each page no matter what
point it is at in the group. Is there a way to force this behavior?