all groups > sql server reporting services > december 2004 >
You're in the

sql server reporting services

group:

Keeping a group together over page break


Keeping a group together over page break Kaisa M. Lindahl
12/10/2004 2:13:30 PM
sql server reporting services:
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

Re: Keeping a group together over page break Wayne Snyder
2/3/2005 8:51:38 AM
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

[quoted text, click to view]

Re: Keeping a group together over page break Kaisa M. Lindahl
2/4/2005 11:06:35 AM
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

[quoted text, click to view]

AddThis Social Bookmark Button