Keeping a group together over page break

I'm creating a report now, that will span over several pages.
I want to keep a group togheter. The report shows clients and projects, and
I don't want to have any "hanging" projects starting on a new page.
Is it possible to have the report do page break if it calculates that the
grouping is too big for the remaining page?
Kaisa M. LindahlThere is a group property called Keeptogether ( I think thats the name) ...
Set its value to 1 ( or true) and if the entire group can not fit in the
remaining space on the space, it will auto page break ...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:ew9B4nr3EHA.2180@.TK2MSFTNGP12.phx.gbl...
> I'm creating a report now, that will span over several pages.
> I want to keep a group togheter. The report shows clients and projects,
and
> I don't want to have any "hanging" projects starting on a new page.
> Is it possible to have the report do page break if it calculates that the
> grouping is too big for the remaining page?
> Kaisa M. Lindahl
>|||Thanks for the reply, but it didn't quite work out.
The KeepTogheter property works on a table level. I couldn't find it for a
group level. And according to this page
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_2bvp.asp
- it says when adding KeepTogether to a table, " A table group is not kept
together. "
I've tried it out, and it seems to be true, even with KeepTogether set to
true, groups will not break to be on one page.
However, I did some testing on the Edit Group bit, and turned on "Repeat
Group Header". So now it will display the group header on the new page.
Is there a way to check if a group has been split like this? Because if
there was, I'd like to do this check, and add ".. continued" on the next
page.
Kaisa M. Lindahl
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:ubciJefCFHA.1188@.tk2msftngp13.phx.gbl...
> There is a group property called Keeptogether ( I think thats the name)
...
> Set its value to 1 ( or true) and if the entire group can not fit in the
> remaining space on the space, it will auto page break ...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.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
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> news:ew9B4nr3EHA.2180@.TK2MSFTNGP12.phx.gbl...
> > I'm creating a report now, that will span over several pages.
> > I want to keep a group togheter. The report shows clients and projects,
> and
> > I don't want to have any "hanging" projects starting on a new page.
> > Is it possible to have the report do page break if it calculates that
the
> > grouping is too big for the remaining page?
> >
> > Kaisa M. Lindahl
> >
> >
>