Keep Details belonging to a Group together on a page

Hi,
this is my problem:
I have a Table defined in some report (Reporting Services); the Table has a
grouping, and each Group has one or more detail rows. So far so good.
When details belonging to some group do not fit on the current page, they
move to the next page - and this is my problem. I would like to have a
"KeepTogether" property on the the Group level, but unfortunately, this
doesn't seem to exist; I can only say "KeepTogether" on the Table level,
which is of no use for the Group.
Does anyone have an idea how some Group can be kept together with the detail
rows belonging to it on one page, such that in cases where at least one of
the details would move to the next page, the whole Group would move, instead?
Thanks for any hint, Axel Hecker.
--
Axel HeckerOn Feb 28, 7:55 am, AxelHecker <AxelHec...@.discussions.microsoft.com>
wrote:
> Hi,
> this is my problem:
> I have a Table defined in some report (Reporting Services); the Table has a
> grouping, and each Group has one or more detail rows. So far so good.
> When details belonging to some group do not fit on the current page, they
> move to the next page - and this is my problem. I would like to have a
> "KeepTogether" property on the the Group level, but unfortunately, this
> doesn't seem to exist; I can only say "KeepTogether" on the Table level,
> which is of no use for the Group.
> Does anyone have an idea how some Group can be kept together with the detail
> rows belonging to it on one page, such that in cases where at least one of
> the details would move to the next page, the whole Group would move, instead?
> Thanks for any hint, Axel Hecker.
> --
> Axel Hecker
You might be able to accomplish this by putting the table in a list.
Otherwise, it might be quite difficult to accomplish this.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Enrique, thanks very much for your comment.
But I cannot really follow you: when I put the table into a list, anything I
define for the list might have effects on the table level, but not on the
group level, because, as far as I know, the list would not "see" the groups
anyway. Or is my thinking wrong somehow?
--
Axel Hecker
"EMartinez" wrote:
> On Feb 28, 7:55 am, AxelHecker <AxelHec...@.discussions.microsoft.com>
> wrote:
> > Hi,
> >
> > this is my problem:
> >
> > I have a Table defined in some report (Reporting Services); the Table has a
> > grouping, and each Group has one or more detail rows. So far so good.
> >
> > When details belonging to some group do not fit on the current page, they
> > move to the next page - and this is my problem. I would like to have a
> > "KeepTogether" property on the the Group level, but unfortunately, this
> > doesn't seem to exist; I can only say "KeepTogether" on the Table level,
> > which is of no use for the Group.
> >
> > Does anyone have an idea how some Group can be kept together with the detail
> > rows belonging to it on one page, such that in cases where at least one of
> > the details would move to the next page, the whole Group would move, instead?
> >
> > Thanks for any hint, Axel Hecker.
> >
> > --
> > Axel Hecker
> You might be able to accomplish this by putting the table in a list.
> Otherwise, it might be quite difficult to accomplish this.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 1, 2:52 am, AxelHecker <AxelHec...@.discussions.microsoft.com>
wrote:
> Enrique, thanks very much for your comment.
> But I cannot really follow you: when I put the table into a list, anything I
> define for the list might have effects on the table level, but not on the
> group level, because, as far as I know, the list would not "see" the groups
> anyway. Or is my thinking wrong somehow?
> --
> Axel Hecker
> "EMartinez" wrote:
> > On Feb 28, 7:55 am, AxelHecker <AxelHec...@.discussions.microsoft.com>
> > wrote:
> > > Hi,
> > > this is my problem:
> > > I have a Table defined in some report (Reporting Services); the Table has a
> > > grouping, and each Group has one or more detail rows. So far so good.
> > > When details belonging to some group do not fit on the current page, they
> > > move to the next page - and this is my problem. I would like to have a
> > > "KeepTogether" property on the the Group level, but unfortunately, this
> > > doesn't seem to exist; I can only say "KeepTogether" on the Table level,
> > > which is of no use for the Group.
> > > Does anyone have an idea how some Group can be kept together with the detail
> > > rows belonging to it on one page, such that in cases where at least one of
> > > the details would move to the next page, the whole Group would move, instead?
> > > Thanks for any hint, Axel Hecker.
> > > --
> > > Axel Hecker
> > You might be able to accomplish this by putting the table in a list.
> > Otherwise, it might be quite difficult to accomplish this.
> > Regards,
> > Enrique Martinez
> > Sr. SQL Server Developer
Theoretically that is correct; however, sometimes in RS the list helps
restrict the table groups (atleast in some cases). The only other
suggestion I would have is to select the page break after group
functionality, which may not give the exact results you are looking
for, but may be the only other option. Ofcourse, adding an extra
column to the report query and specifying grouping on that might be
another way to go to control your format; but is not a guarantee.
Regards,
Enrique Martinez
Sr. SQL Server Developer