Keep a Group Together

Is this property available as in MS Access? It should attempt to fit the
entire group (heading and detail) on the current page if it can, and issue a
page break if it can't.Which control are u using. U can set properties like Fit Matrix/Table
in Page if possible property of table or matrix.
If in table u can edit group to set properties for page break at
start/end.
Mahesh|||In this case, I'm using a table.
If I set a page break at the start of a new group, I'll be generating 100's
of pages! Groups could have from 1 to 30 or more detail items. If I have 10
groups with 1 detail item each, they should all fit on one page. If I have 10
with 20 items each, the first 3 (or so, depending on spacing) should fit on
one page and the 4th go to the next page because it wouldn't fit on the
current one.
That's the way Access works.
"Mahesh" wrote:
> Which control are u using. U can set properties like Fit Matrix/Table
> in Page if possible property of table or matrix.
> If in table u can edit group to set properties for page break at
> start/end.
> Mahesh
>|||Yes. This is actually a table setting though, not a group setting. It is
KeepTogether.
If you select the table, then select the little grey square at the very top
left, you can get to the table properties.
"Peter Manse" <PeterManse@.discussions.microsoft.com> wrote in message
news:C02669DF-3B74-4F5F-B8F8-F7C511A33482@.microsoft.com...
> In this case, I'm using a table.
> If I set a page break at the start of a new group, I'll be generating
> 100's
> of pages! Groups could have from 1 to 30 or more detail items. If I have
> 10
> groups with 1 detail item each, they should all fit on one page. If I have
> 10
> with 20 items each, the first 3 (or so, depending on spacing) should fit
> on
> one page and the 4th go to the next page because it wouldn't fit on the
> current one.
> That's the way Access works.
> "Mahesh" wrote:
>> Which control are u using. U can set properties like Fit Matrix/Table
>> in Page if possible property of table or matrix.
>> If in table u can edit group to set properties for page break at
>> start/end.
>> Mahesh
>>|||I was excited for minute, but it didn't last!
Here's what the pertinent properties for the table say:
KeepTogether: True
PageBreakAtEnd: True
PageBreakAtStart: False
Parent: Body
RepeatFooterOnNewPage: False
RepeatHeaderOnNewPage: True
The table is not kept together. Instead, the heading and as many detail
items as will fit on the page are printed. When there is no more room, a new
page is generated, the heading is reprinted, followed by the remaining detail
items.
This is true of the export (pdf in my case), too, although the export takes
up 20 pages where the html takes up only 11.
This is pretty basic formatting stuff, so I'm sure I must be doing something
wrong, but I just can't put my finger on it.
Any more ideas?
"goodman93" wrote:
> Yes. This is actually a table setting though, not a group setting. It is
> KeepTogether.
> If you select the table, then select the little grey square at the very top
> left, you can get to the table properties.
>
> "Peter Manse" <PeterManse@.discussions.microsoft.com> wrote in message
> news:C02669DF-3B74-4F5F-B8F8-F7C511A33482@.microsoft.com...
> > In this case, I'm using a table.
> >
> > If I set a page break at the start of a new group, I'll be generating
> > 100's
> > of pages! Groups could have from 1 to 30 or more detail items. If I have
> > 10
> > groups with 1 detail item each, they should all fit on one page. If I have
> > 10
> > with 20 items each, the first 3 (or so, depending on spacing) should fit
> > on
> > one page and the 4th go to the next page because it wouldn't fit on the
> > current one.
> >
> > That's the way Access works.
> >
> > "Mahesh" wrote:
> >
> >> Which control are u using. U can set properties like Fit Matrix/Table
> >> in Page if possible property of table or matrix.
> >>
> >> If in table u can edit group to set properties for page break at
> >> start/end.
> >>
> >> Mahesh
> >>
> >>
>
>|||Anybody on the MS SQL Reporting team have any ideas on this? I keep on trying
different combinations but just haven't hit on one that will work. It's as if
KeepTogether is being completely ignored.
"Peter Manse" wrote:
> I was excited for minute, but it didn't last!
> Here's what the pertinent properties for the table say:
> KeepTogether: True
> PageBreakAtEnd: True
> PageBreakAtStart: False
> Parent: Body
> RepeatFooterOnNewPage: False
> RepeatHeaderOnNewPage: True
> The table is not kept together. Instead, the heading and as many detail
> items as will fit on the page are printed. When there is no more room, a new
> page is generated, the heading is reprinted, followed by the remaining detail
> items.
> This is true of the export (pdf in my case), too, although the export takes
> up 20 pages where the html takes up only 11.
> This is pretty basic formatting stuff, so I'm sure I must be doing something
> wrong, but I just can't put my finger on it.
> Any more ideas?
> "goodman93" wrote:
> > Yes. This is actually a table setting though, not a group setting. It is
> > KeepTogether.
> >
> > If you select the table, then select the little grey square at the very top
> > left, you can get to the table properties.
> >
> >
> > "Peter Manse" <PeterManse@.discussions.microsoft.com> wrote in message
> > news:C02669DF-3B74-4F5F-B8F8-F7C511A33482@.microsoft.com...
> > > In this case, I'm using a table.
> > >
> > > If I set a page break at the start of a new group, I'll be generating
> > > 100's
> > > of pages! Groups could have from 1 to 30 or more detail items. If I have
> > > 10
> > > groups with 1 detail item each, they should all fit on one page. If I have
> > > 10
> > > with 20 items each, the first 3 (or so, depending on spacing) should fit
> > > on
> > > one page and the 4th go to the next page because it wouldn't fit on the
> > > current one.
> > >
> > > That's the way Access works.
> > >
> > > "Mahesh" wrote:
> > >
> > >> Which control are u using. U can set properties like Fit Matrix/Table
> > >> in Page if possible property of table or matrix.
> > >>
> > >> If in table u can edit group to set properties for page break at
> > >> start/end.
> > >>
> > >> Mahesh
> > >>
> > >>
> >
> >
> >|||Peter, I need to do the same thing. I have a table that is displaying
information in groups. I want the page to break before a group starts if in
order to start that group on page one it will finish on page two. Has
anyting come of this? Is there a way to do this?
"Peter Manse" wrote:
> Anybody on the MS SQL Reporting team have any ideas on this? I keep on trying
> different combinations but just haven't hit on one that will work. It's as if
> KeepTogether is being completely ignored.
> "Peter Manse" wrote:
> > I was excited for minute, but it didn't last!
> >
> > Here's what the pertinent properties for the table say:
> >
> > KeepTogether: True
> > PageBreakAtEnd: True
> > PageBreakAtStart: False
> > Parent: Body
> > RepeatFooterOnNewPage: False
> > RepeatHeaderOnNewPage: True
> >
> > The table is not kept together. Instead, the heading and as many detail
> > items as will fit on the page are printed. When there is no more room, a new
> > page is generated, the heading is reprinted, followed by the remaining detail
> > items.
> >
> > This is true of the export (pdf in my case), too, although the export takes
> > up 20 pages where the html takes up only 11.
> >
> > This is pretty basic formatting stuff, so I'm sure I must be doing something
> > wrong, but I just can't put my finger on it.
> >
> > Any more ideas?
> >
> > "goodman93" wrote:
> >
> > > Yes. This is actually a table setting though, not a group setting. It is
> > > KeepTogether.
> > >
> > > If you select the table, then select the little grey square at the very top
> > > left, you can get to the table properties.
> > >
> > >
> > > "Peter Manse" <PeterManse@.discussions.microsoft.com> wrote in message
> > > news:C02669DF-3B74-4F5F-B8F8-F7C511A33482@.microsoft.com...
> > > > In this case, I'm using a table.
> > > >
> > > > If I set a page break at the start of a new group, I'll be generating
> > > > 100's
> > > > of pages! Groups could have from 1 to 30 or more detail items. If I have
> > > > 10
> > > > groups with 1 detail item each, they should all fit on one page. If I have
> > > > 10
> > > > with 20 items each, the first 3 (or so, depending on spacing) should fit
> > > > on
> > > > one page and the 4th go to the next page because it wouldn't fit on the
> > > > current one.
> > > >
> > > > That's the way Access works.
> > > >
> > > > "Mahesh" wrote:
> > > >
> > > >> Which control are u using. U can set properties like Fit Matrix/Table
> > > >> in Page if possible property of table or matrix.
> > > >>
> > > >> If in table u can edit group to set properties for page break at
> > > >> start/end.
> > > >>
> > > >> Mahesh
> > > >>
> > > >>
> > >
> > >
> > >|||It looks like we're SOL, Sharin. Here's what Leo Tachev (author of "Microsoft
Reporting Services In Action") told me when I asked him the question:
"As it stands, RS 2000 and 2005 donâ't allow you to control the page break.
Data regions have Keep Together and Before and After page breaks. I am afraid
this is as far as you can control it at the moment."
This jives with what we're experiencing, but sounds like there's a bug in
the Keep Together function. Either that or the function is neither named nor
documented properly. My expectation with a function named Keep Together is
that it would work exactly the way you and I expect it to.
"SharinDenver" wrote:
> Peter, I need to do the same thing. I have a table that is displaying
> information in groups. I want the page to break before a group starts if in
> order to start that group on page one it will finish on page two. Has
> anyting come of this? Is there a way to do this?
>
> "Peter Manse" wrote:
> > Anybody on the MS SQL Reporting team have any ideas on this? I keep on trying
> > different combinations but just haven't hit on one that will work. It's as if
> > KeepTogether is being completely ignored.
> >
> > "Peter Manse" wrote:
> >
> > > I was excited for minute, but it didn't last!
> > >
> > > Here's what the pertinent properties for the table say:
> > >
> > > KeepTogether: True
> > > PageBreakAtEnd: True
> > > PageBreakAtStart: False
> > > Parent: Body
> > > RepeatFooterOnNewPage: False
> > > RepeatHeaderOnNewPage: True
> > >
> > > The table is not kept together. Instead, the heading and as many detail
> > > items as will fit on the page are printed. When there is no more room, a new
> > > page is generated, the heading is reprinted, followed by the remaining detail
> > > items.
> > >
> > > This is true of the export (pdf in my case), too, although the export takes
> > > up 20 pages where the html takes up only 11.
> > >
> > > This is pretty basic formatting stuff, so I'm sure I must be doing something
> > > wrong, but I just can't put my finger on it.
> > >
> > > Any more ideas?
> > >
> > > "goodman93" wrote:
> > >
> > > > Yes. This is actually a table setting though, not a group setting. It is
> > > > KeepTogether.
> > > >
> > > > If you select the table, then select the little grey square at the very top
> > > > left, you can get to the table properties.
> > > >
> > > >
> > > > "Peter Manse" <PeterManse@.discussions.microsoft.com> wrote in message
> > > > news:C02669DF-3B74-4F5F-B8F8-F7C511A33482@.microsoft.com...
> > > > > In this case, I'm using a table.
> > > > >
> > > > > If I set a page break at the start of a new group, I'll be generating
> > > > > 100's
> > > > > of pages! Groups could have from 1 to 30 or more detail items. If I have
> > > > > 10
> > > > > groups with 1 detail item each, they should all fit on one page. If I have
> > > > > 10
> > > > > with 20 items each, the first 3 (or so, depending on spacing) should fit
> > > > > on
> > > > > one page and the 4th go to the next page because it wouldn't fit on the
> > > > > current one.
> > > > >
> > > > > That's the way Access works.
> > > > >
> > > > > "Mahesh" wrote:
> > > > >
> > > > >> Which control are u using. U can set properties like Fit Matrix/Table
> > > > >> in Page if possible property of table or matrix.
> > > > >>
> > > > >> If in table u can edit group to set properties for page break at
> > > > >> start/end.
> > > > >>
> > > > >> Mahesh
> > > > >>
> > > > >>
> > > >
> > > >
> > > >|||I don't even see the KeepTogether function or how or where to use it. Did
Leo see a problem with this lack of functionality and does it sound like
something they will try and fix? Did you ask him if KeepTogether should do
what we want?
"Peter Manse" wrote:
> It looks like we're SOL, Sharin. Here's what Leo Tachev (author of "Microsoft
> Reporting Services In Action") told me when I asked him the question:
> "As it stands, RS 2000 and 2005 donâ't allow you to control the page break.
> Data regions have Keep Together and Before and After page breaks. I am afraid
> this is as far as you can control it at the moment."
> This jives with what we're experiencing, but sounds like there's a bug in
> the Keep Together function. Either that or the function is neither named nor
> documented properly. My expectation with a function named Keep Together is
> that it would work exactly the way you and I expect it to.
>
> "SharinDenver" wrote:
> > Peter, I need to do the same thing. I have a table that is displaying
> > information in groups. I want the page to break before a group starts if in
> > order to start that group on page one it will finish on page two. Has
> > anyting come of this? Is there a way to do this?
> >
> >
> > "Peter Manse" wrote:
> >
> > > Anybody on the MS SQL Reporting team have any ideas on this? I keep on trying
> > > different combinations but just haven't hit on one that will work. It's as if
> > > KeepTogether is being completely ignored.
> > >
> > > "Peter Manse" wrote:
> > >
> > > > I was excited for minute, but it didn't last!
> > > >
> > > > Here's what the pertinent properties for the table say:
> > > >
> > > > KeepTogether: True
> > > > PageBreakAtEnd: True
> > > > PageBreakAtStart: False
> > > > Parent: Body
> > > > RepeatFooterOnNewPage: False
> > > > RepeatHeaderOnNewPage: True
> > > >
> > > > The table is not kept together. Instead, the heading and as many detail
> > > > items as will fit on the page are printed. When there is no more room, a new
> > > > page is generated, the heading is reprinted, followed by the remaining detail
> > > > items.
> > > >
> > > > This is true of the export (pdf in my case), too, although the export takes
> > > > up 20 pages where the html takes up only 11.
> > > >
> > > > This is pretty basic formatting stuff, so I'm sure I must be doing something
> > > > wrong, but I just can't put my finger on it.
> > > >
> > > > Any more ideas?
> > > >
> > > > "goodman93" wrote:
> > > >
> > > > > Yes. This is actually a table setting though, not a group setting. It is
> > > > > KeepTogether.
> > > > >
> > > > > If you select the table, then select the little grey square at the very top
> > > > > left, you can get to the table properties.
> > > > >
> > > > >
> > > > > "Peter Manse" <PeterManse@.discussions.microsoft.com> wrote in message
> > > > > news:C02669DF-3B74-4F5F-B8F8-F7C511A33482@.microsoft.com...
> > > > > > In this case, I'm using a table.
> > > > > >
> > > > > > If I set a page break at the start of a new group, I'll be generating
> > > > > > 100's
> > > > > > of pages! Groups could have from 1 to 30 or more detail items. If I have
> > > > > > 10
> > > > > > groups with 1 detail item each, they should all fit on one page. If I have
> > > > > > 10
> > > > > > with 20 items each, the first 3 (or so, depending on spacing) should fit
> > > > > > on
> > > > > > one page and the 4th go to the next page because it wouldn't fit on the
> > > > > > current one.
> > > > > >
> > > > > > That's the way Access works.
> > > > > >
> > > > > > "Mahesh" wrote:
> > > > > >
> > > > > >> Which control are u using. U can set properties like Fit Matrix/Table
> > > > > >> in Page if possible property of table or matrix.
> > > > > >>
> > > > > >> If in table u can edit group to set properties for page break at
> > > > > >> start/end.
> > > > > >>
> > > > > >> Mahesh
> > > > > >>
> > > > > >>
> > > > >
> > > > >
> > > > >