Showing posts with label group. Show all posts
Showing posts with label group. Show all posts

Friday, March 30, 2012

KPI

Hi all,

I've created a KPI and it is working correctly, however, I don't see it in the cube browser under the measures group? Where can I set the property to have it appear?

Thanks,

Mark

You can see KPI on "Browser View" mode on KPI's tab or sending an MDX query from the SQL Server Management Studio.

Francesco

|||Thanks Francesco, I do see it there. How can I get it to render via an Excel (2007) pivot table? I recall having generated one when I was using the Beta version of 2007.

Wednesday, March 28, 2012

Kind Attention: MSFT

Hi,
The below issue is frustrating me as I have posted it
couple of times on this news group but didnt received a
single response.Atleast this time I expect a response from
MSFT online personnels.
I have a SBS 2003 5 CAL . I want to use SQL Server on top
of it in production, I prefer to use SQL Server based on
the available CPU's on my system. But I am confused
thinking, In what way SQL Server Licencing restrictions
are applicable as it is bundled along with SBS.
Thanks for the help!
Regards
ChipQ. Is it possible to install the server applications included with
Windows Small Business Server 2003 on a different computer running Windows
Server? For example, I want to run SQL Server on the computer running
Windows Small Business Server 2003, but I want to run Exchange Server 2003
on a different computer.
A. No. The server applications that come with the product must be
installed on the same physical machine, if they are installed at all. The
only exception is that FrontPage 2003, which is included with the premium
edition, may be installed on a single client computer in the Windows Small
Business Server 2003 network.
direct from MS web site
http://www.microsoft.com/windowsser...iew/generalfaq.
mspx
Neil MacMurchy
"Chip" <chipsin007@.yahoo.com> wrote in message
news:1b1401c3fc0d$62f56690$a301280a@.phx.gbl...
> Hi,
> The below issue is frustrating me as I have posted it
> couple of times on this news group but didnt received a
> single response.Atleast this time I expect a response from
> MSFT online personnels.
> I have a SBS 2003 5 CAL . I want to use SQL Server on top
> of it in production, I prefer to use SQL Server based on
> the available CPU's on my system. But I am confused
> thinking, In what way SQL Server Licencing restrictions
> are applicable as it is bundled along with SBS.
> Thanks for the help!
> Regards
> Chip
>|||Hi Neil,
Thanks for trying to help me, but if u read my post
clearly I was talking about installing the SQL Server on
the Same SBS 2003 Edition and am concerned about Licensing
Issues with SQL Server 2000 on SBS 2003.
I am going mad with this Issue.
Regards
Chip
>--Original Message--
> Q. Is it possible to install the server
applications included with
>Windows Small Business Server 2003 on a different
computer running Windows
>Server? For example, I want to run SQL Server on the
computer running
>Windows Small Business Server 2003, but I want to run
Exchange Server 2003
>on a different computer.
> A. No. The server applications that come with the
product must be
>installed on the same physical machine, if they are
installed at all. The
>only exception is that FrontPage 2003, which is included
with the premium
>edition, may be installed on a single client computer in
the Windows Small
>Business Server 2003 network.
>
> direct from MS web site
>http://www.microsoft.com/windowsser...sbs/techinfo/ov
erview/generalfaq.
>mspx
> Neil MacMurchy
>
>"Chip" <chipsin007@.yahoo.com> wrote in message
>news:1b1401c3fc0d$62f56690$a301280a@.phx.gbl...
from
top
>
>.
>|||you might have better luck in the microsoft.public.smallbiz.sbsisp group.
My guess however is still a big nope. Since the SBS server is licensed per
seat, I don't think this would allow the SQL portion to be licensed per
processor as they apps are licensed as a bundle. I realize that if you
wanted to use this to allow anonymous SQL access (Internet) you need to use
per processor licensing but this is not the intent of this product (to my
knowledge).
Best bet would be to call MS. A regional sales rep can usually clear away
the licensing confusion that most MS products have
Neil
"Chip" <chipsin007@.yahoo.com> wrote in message
news:1daa01c3fc20$06faab30$a301280a@.phx.gbl...
> Hi Neil,
> Thanks for trying to help me, but if u read my post
> clearly I was talking about installing the SQL Server on
> the Same SBS 2003 Edition and am concerned about Licensing
> Issues with SQL Server 2000 on SBS 2003.
> I am going mad with this Issue.
> Regards
> Chip
> applications included with
> computer running Windows
> computer running
> Exchange Server 2003
> product must be
> installed at all. The
> with the premium
> the Windows Small
> erview/generalfaq.
> from
> top|||Hi Neil,
Thank you very much for ur views and suggestions. I will
contact the Local Microsoft office. But I am surprised of
one thing. How come no Microsoft guy tried to answer my
query even after I put the Attention Note in subject.
Anyway Have a nice time.
Regards
Chip
>--Original Message--
>you might have better luck in the
microsoft.public.smallbiz.sbsisp group.
>My guess however is still a big nope. Since the SBS
server is licensed per
>seat, I don't think this would allow the SQL portion to
be licensed per
>processor as they apps are licensed as a bundle. I
realize that if you
>wanted to use this to allow anonymous SQL access
(Internet) you need to use
>per processor licensing but this is not the intent of
this product (to my
>knowledge).
>Best bet would be to call MS. A regional sales rep can
usually clear away
>the licensing confusion that most MS products have
>Neil
>"Chip" <chipsin007@.yahoo.com> wrote in message
>news:1daa01c3fc20$06faab30$a301280a@.phx.gbl...
Licensing
included
in
>http://www.microsoft.com/windowsser...sbs/techinfo/ov
received a
based on
restrictions
>
>.
>|||"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:2a0701c3fc90$f2d9dc40$a101280a@.phx.gbl...
> Hi Neil,
> Thank you very much for ur views and suggestions. I will
> contact the Local Microsoft office. But I am surprised of
> one thing. How come no Microsoft guy tried to answer my
> query even after I put the Attention Note in subject.
> Anyway Have a nice time.
In short, because we're not lawyers and we've been told that because we're
not lawyers we're not to dispense legal advice. :-( On top of that, there
simply may not be any Microsoft employees reading this newsgroup who know
the answer. I know I sure don't. Neil is right, your best bet is to contact
your local sales office.
Oh, and please note that while this is a Microsoft-hosted newsgroup, unless
you're a subscriber to technet or MSDN there's no guarantee of a response.
Sorry!
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.

Kind Attention: MSFT

Hi,
The below issue is frustrating me as I have posted it
couple of times on this news group but didnt received a
single response.Atleast this time I expect a response from
MSFT online personnels.
I have a SBS 2003 5 CAL . I want to use SQL Server on top
of it in production, I prefer to use SQL Server based on
the available CPU's on my system. But I am confused
thinking, In what way SQL Server Licencing restrictions
are applicable as it is bundled along with SBS.
Thanks for the help!
Regards
ChipQ. Is it possible to install the server applications included with
Windows Small Business Server 2003 on a different computer running Windows
Server? For example, I want to run SQL Server on the computer running
Windows Small Business Server 2003, but I want to run Exchange Server 2003
on a different computer.
A. No. The server applications that come with the product must be
installed on the same physical machine, if they are installed at all. The
only exception is that FrontPage 2003, which is included with the premium
edition, may be installed on a single client computer in the Windows Small
Business Server 2003 network.
direct from MS web site
http://www.microsoft.com/windowsserver2003/sbs/techinfo/overview/generalfaq.
mspx
Neil MacMurchy
"Chip" <chipsin007@.yahoo.com> wrote in message
news:1b1401c3fc0d$62f56690$a301280a@.phx.gbl...
> Hi,
> The below issue is frustrating me as I have posted it
> couple of times on this news group but didnt received a
> single response.Atleast this time I expect a response from
> MSFT online personnels.
> I have a SBS 2003 5 CAL . I want to use SQL Server on top
> of it in production, I prefer to use SQL Server based on
> the available CPU's on my system. But I am confused
> thinking, In what way SQL Server Licencing restrictions
> are applicable as it is bundled along with SBS.
> Thanks for the help!
> Regards
> Chip
>|||Hi Neil,
Thanks for trying to help me, but if u read my post
clearly I was talking about installing the SQL Server on
the Same SBS 2003 Edition and am concerned about Licensing
Issues with SQL Server 2000 on SBS 2003.
I am going mad with this Issue.
Regards
Chip
>--Original Message--
> Q. Is it possible to install the server
applications included with
>Windows Small Business Server 2003 on a different
computer running Windows
>Server? For example, I want to run SQL Server on the
computer running
>Windows Small Business Server 2003, but I want to run
Exchange Server 2003
>on a different computer.
> A. No. The server applications that come with the
product must be
>installed on the same physical machine, if they are
installed at all. The
>only exception is that FrontPage 2003, which is included
with the premium
>edition, may be installed on a single client computer in
the Windows Small
>Business Server 2003 network.
>
> direct from MS web site
>http://www.microsoft.com/windowsserver2003/sbs/techinfo/ov
erview/generalfaq.
>mspx
> Neil MacMurchy
>
>"Chip" <chipsin007@.yahoo.com> wrote in message
>news:1b1401c3fc0d$62f56690$a301280a@.phx.gbl...
>> Hi,
>> The below issue is frustrating me as I have posted it
>> couple of times on this news group but didnt received a
>> single response.Atleast this time I expect a response
from
>> MSFT online personnels.
>> I have a SBS 2003 5 CAL . I want to use SQL Server on
top
>> of it in production, I prefer to use SQL Server based on
>> the available CPU's on my system. But I am confused
>> thinking, In what way SQL Server Licencing restrictions
>> are applicable as it is bundled along with SBS.
>> Thanks for the help!
>> Regards
>> Chip
>
>.
>|||you might have better luck in the microsoft.public.smallbiz.sbsisp group.
My guess however is still a big nope. Since the SBS server is licensed per
seat, I don't think this would allow the SQL portion to be licensed per
processor as they apps are licensed as a bundle. I realize that if you
wanted to use this to allow anonymous SQL access (Internet) you need to use
per processor licensing but this is not the intent of this product (to my
knowledge).
Best bet would be to call MS. A regional sales rep can usually clear away
the licensing confusion that most MS products have :)
Neil
"Chip" <chipsin007@.yahoo.com> wrote in message
news:1daa01c3fc20$06faab30$a301280a@.phx.gbl...
> Hi Neil,
> Thanks for trying to help me, but if u read my post
> clearly I was talking about installing the SQL Server on
> the Same SBS 2003 Edition and am concerned about Licensing
> Issues with SQL Server 2000 on SBS 2003.
> I am going mad with this Issue.
> Regards
> Chip
> >--Original Message--
> > Q. Is it possible to install the server
> applications included with
> >Windows Small Business Server 2003 on a different
> computer running Windows
> >Server? For example, I want to run SQL Server on the
> computer running
> >Windows Small Business Server 2003, but I want to run
> Exchange Server 2003
> >on a different computer.
> >
> > A. No. The server applications that come with the
> product must be
> >installed on the same physical machine, if they are
> installed at all. The
> >only exception is that FrontPage 2003, which is included
> with the premium
> >edition, may be installed on a single client computer in
> the Windows Small
> >Business Server 2003 network.
> >
> >
> >
> > direct from MS web site
> >http://www.microsoft.com/windowsserver2003/sbs/techinfo/ov
> erview/generalfaq.
> >mspx
> >
> > Neil MacMurchy
> >
> >
> >"Chip" <chipsin007@.yahoo.com> wrote in message
> >news:1b1401c3fc0d$62f56690$a301280a@.phx.gbl...
> >> Hi,
> >>
> >> The below issue is frustrating me as I have posted it
> >> couple of times on this news group but didnt received a
> >> single response.Atleast this time I expect a response
> from
> >> MSFT online personnels.
> >>
> >> I have a SBS 2003 5 CAL . I want to use SQL Server on
> top
> >> of it in production, I prefer to use SQL Server based on
> >> the available CPU's on my system. But I am confused
> >> thinking, In what way SQL Server Licencing restrictions
> >> are applicable as it is bundled along with SBS.
> >>
> >> Thanks for the help!
> >>
> >> Regards
> >>
> >> Chip
> >>
> >
> >
> >.
> >|||Hi Neil,
Thank you very much for ur views and suggestions. I will
contact the Local Microsoft office. But I am surprised of
one thing. How come no Microsoft guy tried to answer my
query even after I put the Attention Note in subject.
Anyway Have a nice time.
Regards
Chip
>--Original Message--
>you might have better luck in the
microsoft.public.smallbiz.sbsisp group.
>My guess however is still a big nope. Since the SBS
server is licensed per
>seat, I don't think this would allow the SQL portion to
be licensed per
>processor as they apps are licensed as a bundle. I
realize that if you
>wanted to use this to allow anonymous SQL access
(Internet) you need to use
>per processor licensing but this is not the intent of
this product (to my
>knowledge).
>Best bet would be to call MS. A regional sales rep can
usually clear away
>the licensing confusion that most MS products have :)
>Neil
>"Chip" <chipsin007@.yahoo.com> wrote in message
>news:1daa01c3fc20$06faab30$a301280a@.phx.gbl...
>> Hi Neil,
>> Thanks for trying to help me, but if u read my post
>> clearly I was talking about installing the SQL Server on
>> the Same SBS 2003 Edition and am concerned about
Licensing
>> Issues with SQL Server 2000 on SBS 2003.
>> I am going mad with this Issue.
>> Regards
>> Chip
>> >--Original Message--
>> > Q. Is it possible to install the server
>> applications included with
>> >Windows Small Business Server 2003 on a different
>> computer running Windows
>> >Server? For example, I want to run SQL Server on the
>> computer running
>> >Windows Small Business Server 2003, but I want to run
>> Exchange Server 2003
>> >on a different computer.
>> >
>> > A. No. The server applications that come with the
>> product must be
>> >installed on the same physical machine, if they are
>> installed at all. The
>> >only exception is that FrontPage 2003, which is
included
>> with the premium
>> >edition, may be installed on a single client computer
in
>> the Windows Small
>> >Business Server 2003 network.
>> >
>> >
>> >
>> > direct from MS web site
>http://www.microsoft.com/windowsserver2003/sbs/techinfo/ov
>> erview/generalfaq.
>> >mspx
>> >
>> > Neil MacMurchy
>> >
>> >
>> >"Chip" <chipsin007@.yahoo.com> wrote in message
>> >news:1b1401c3fc0d$62f56690$a301280a@.phx.gbl...
>> >> Hi,
>> >>
>> >> The below issue is frustrating me as I have posted it
>> >> couple of times on this news group but didnt
received a
>> >> single response.Atleast this time I expect a response
>> from
>> >> MSFT online personnels.
>> >>
>> >> I have a SBS 2003 5 CAL . I want to use SQL Server on
>> top
>> >> of it in production, I prefer to use SQL Server
based on
>> >> the available CPU's on my system. But I am confused
>> >> thinking, In what way SQL Server Licencing
restrictions
>> >> are applicable as it is bundled along with SBS.
>> >>
>> >> Thanks for the help!
>> >>
>> >> Regards
>> >>
>> >> Chip
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:2a0701c3fc90$f2d9dc40$a101280a@.phx.gbl...
> Hi Neil,
> Thank you very much for ur views and suggestions. I will
> contact the Local Microsoft office. But I am surprised of
> one thing. How come no Microsoft guy tried to answer my
> query even after I put the Attention Note in subject.
> Anyway Have a nice time.
In short, because we're not lawyers and we've been told that because we're
not lawyers we're not to dispense legal advice. :-( On top of that, there
simply may not be any Microsoft employees reading this newsgroup who know
the answer. I know I sure don't. Neil is right, your best bet is to contact
your local sales office.
Oh, and please note that while this is a Microsoft-hosted newsgroup, unless
you're a subscriber to TechNet or MSDN there's no guarantee of a response.
Sorry!
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.

Friday, March 9, 2012

KeepTogether header does not work correctly.

I selected "Repeat Group Header" in my grouping properties. This is working fine; however, if a group is to start as the last line in a page, the header prints on that last line and then the header is printed once more in the next page. Consequently I end up with two consecutive headers with no detail lines in between.

How do I prevent the printing of two consecutive headers for the same group? I want to get rid of the one that occurs as the last line on the page.

Thanks, Shyam.

The dropdown would not accept a selection of the same group.

I tried other selections, but did not work.

JR.

|||If there is only one such situation in your report, try increasing the height of the detail or the header so that it is stretched to the next page.|||

Thanks for the reply. I appreciated you trying to help me.

I found this problem in several reports and the problem repeats a few times in each report.

I tried your suggestion, it was a good thought, but did not work. It shifted the problem to a different page.

Do you have another suggestion ?

|||

For all the textboxes in the group header, select hide duplicates and select that group in the dropdown below that. It's just a suggestion which may or may not work.

Shyam

KeepTogether header does not work correctly.

I selected "Repeat Group Header" in my grouping properties. This is working fine; however, if a group is to start as the last line in a page, the header prints on that last line and then the header is printed once more in the next page. Consequently I end up with two consecutive headers with no detail lines in between.

How do I prevent the printing of two consecutive headers for the same group? I want to get rid of the one that occurs as the last line on the page.

If there is only one such situation in your report, try increasing the height of the detail or the header so that it is stretched to the next page.|||

Thanks for the reply. I appreciated you trying to help me.

I found this problem in several reports and the problem repeats a few times in each report.

I tried your suggestion, it was a good thought, but did not work. It shifted the problem to a different page.

Do you have another suggestion ?

|||

For all the textboxes in the group header, select hide duplicates and select that group in the dropdown below that. It's just a suggestion which may or may not work.

Shyam

|||

Thanks, Shyam.

The dropdown would not accept a selection of the same group.

I tried other selections, but did not work.

JR.

KeepTogether

I'm in a search for a solution. I need to keep a group together. If it doesn't fit on the same page as the previous group it should start on a new page. I cannot believe reporting services unable to provide this.
Ok, table's grouping doesn't have keeptogether option (but the table itself has...).
Let's see List. It doesn't work. I hoped SP1 will solve it, but doesn't. Shall we wait till SP2 or the Yukon version of RS?KeepTogether on Grouping is on our future features wishlist.
(Note: KeepTogether on List wouldn't help since it tries to keep the entire
list together, not the individual groups)
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"sabe" <sabe@.discussions.microsoft.com> wrote in message
news:D2FE2D32-51B3-4732-A0C6-0ACF1F1C579C@.microsoft.com...
> I'm in a search for a solution. I need to keep a group together. If it
doesn't fit on the same page as the previous group it should start on a new
page. I cannot believe reporting services unable to provide this.
> Ok, table's grouping doesn't have keeptogether option (but the table
itself has...).
> Let's see List. It doesn't work. I hoped SP1 will solve it, but doesn't.
Shall we wait till SP2 or the Yukon version of RS?|||OK, then what's the functionality of the _current_ KeepTogether property? Nothing, I suppose...
"Chris Hays [MSFT]" wrote:
> KeepTogether on Grouping is on our future features wishlist.
> (Note: KeepTogether on List wouldn't help since it tries to keep the entire
> list together, not the individual groups)
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "sabe" <sabe@.discussions.microsoft.com> wrote in message
> news:D2FE2D32-51B3-4732-A0C6-0ACF1F1C579C@.microsoft.com...
> > I'm in a search for a solution. I need to keep a group together. If it
> doesn't fit on the same page as the previous group it should start on a new
> page. I cannot believe reporting services unable to provide this.
> >
> > Ok, table's grouping doesn't have keeptogether option (but the table
> itself has...).
> >
> > Let's see List. It doesn't work. I hoped SP1 will solve it, but doesn't.
> Shall we wait till SP2 or the Yukon version of RS?
>
>|||OK, then what's the functionality of the _current_ KeepTogether property? Nothing, I suppose...
"Chris Hays [MSFT]" wrote:
> KeepTogether on Grouping is on our future features wishlist.
> (Note: KeepTogether on List wouldn't help since it tries to keep the entire
> list together, not the individual groups)
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "sabe" <sabe@.discussions.microsoft.com> wrote in message
> news:D2FE2D32-51B3-4732-A0C6-0ACF1F1C579C@.microsoft.com...
> > I'm in a search for a solution. I need to keep a group together. If it
> doesn't fit on the same page as the previous group it should start on a new
> page. I cannot believe reporting services unable to provide this.
> >
> > Ok, table's grouping doesn't have keeptogether option (but the table
> itself has...).
> >
> > Let's see List. It doesn't work. I hoped SP1 will solve it, but doesn't.
> Shall we wait till SP2 or the Yukon version of RS?
>
>|||It attempts to keep the entire list together (not the individual groups
within the list).
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"sabe" <sabe@.discussions.microsoft.com> wrote in message
news:A38B97C5-3F5D-4EEC-BDB1-637131421CD0@.microsoft.com...
> OK, then what's the functionality of the _current_ KeepTogether property?
Nothing, I suppose...
>
> "Chris Hays [MSFT]" wrote:
> > KeepTogether on Grouping is on our future features wishlist.
> >
> > (Note: KeepTogether on List wouldn't help since it tries to keep the
entire
> > list together, not the individual groups)
> >
> > --
> > My employer's lawyers require me to say:
> > "This posting is provided 'AS IS' with no warranties, and confers no
> > rights."
> >
> > "sabe" <sabe@.discussions.microsoft.com> wrote in message
> > news:D2FE2D32-51B3-4732-A0C6-0ACF1F1C579C@.microsoft.com...
> > > I'm in a search for a solution. I need to keep a group together. If it
> > doesn't fit on the same page as the previous group it should start on a
new
> > page. I cannot believe reporting services unable to provide this.
> > >
> > > Ok, table's grouping doesn't have keeptogether option (but the table
> > itself has...).
> > >
> > > Let's see List. It doesn't work. I hoped SP1 will solve it, but
doesn't.
> > Shall we wait till SP2 or the Yukon version of RS?
> >
> >
> >|||I'm replying MUCH after-the-fact... this string is currently on p.18
but if anybody is still reading 18 pages deep, I'll share my workaround
in order to achieve Keep together on groups, I've been nesting tables within tables -- nested in a "merged cell" group header of the parent table
I create the parent table, group it on group1, then I merge all cells in the group header. Into the merged cell group header, I drop another table, and group that table on group2, and so on...
to make an example, say I have a U.S.A. report, that I want to show State/County/City details.
My parent table is Grouped on States. I merge cells in the State Group header, and drop another table inside the merged cells. This new table I group on Counties. I merge cells in the Group header here as well, and drop another table inside grouped on Cities... I can then say "keep together" on any of these tables
it's a pain initially, but once you get the hang of it, it seems to work... at least it has for me...
hope this makes sense...
---
"Chris Hays [MSFT]" wrote:
> It attempts to keep the entire list together (not the individual groups
> within the list).
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "sabe" <sabe@.discussions.microsoft.com> wrote in message
> news:A38B97C5-3F5D-4EEC-BDB1-637131421CD0@.microsoft.com...
> > OK, then what's the functionality of the _current_ KeepTogether property?
> Nothing, I suppose...
> >
> >
> >
> > "Chris Hays [MSFT]" wrote:
> >
> > > KeepTogether on Grouping is on our future features wishlist.
> > >
> > > (Note: KeepTogether on List wouldn't help since it tries to keep the
> entire
> > > list together, not the individual groups)
> > >
> > > --
> > > My employer's lawyers require me to say:
> > > "This posting is provided 'AS IS' with no warranties, and confers no
> > > rights."
> > >
> > > "sabe" <sabe@.discussions.microsoft.com> wrote in message
> > > news:D2FE2D32-51B3-4732-A0C6-0ACF1F1C579C@.microsoft.com...
> > > > I'm in a search for a solution. I need to keep a group together. If it
> > > doesn't fit on the same page as the previous group it should start on a
> new
> > > page. I cannot believe reporting services unable to provide this.
> > > >
> > > > Ok, table's grouping doesn't have keeptogether option (but the table
> > > itself has...).
> > > >
> > > > Let's see List. It doesn't work. I hoped SP1 will solve it, but
> doesn't.
> > > Shall we wait till SP2 or the Yukon version of RS?
> > >
> > >
> > >
>
>|||Hi,
How you link the parent table and the child tables?
- Samuel
"Derek in Richmond" <DerekinRichmond@.discussions.microsoft.com> wrote in
message news:D821CEDE-3280-42EB-B7ED-2DBCD073DEB7@.microsoft.com...
> I'm replying MUCH after-the-fact... this string is currently on p.18
> but if anybody is still reading 18 pages deep, I'll share my workaround
> in order to achieve Keep together on groups, I've been nesting tables
within tables -- nested in a "merged cell" group header of the parent table
> I create the parent table, group it on group1, then I merge all cells in
the group header. Into the merged cell group header, I drop another table,
and group that table on group2, and so on...
> to make an example, say I have a U.S.A. report, that I want to show
State/County/City details.
> My parent table is Grouped on States. I merge cells in the State Group
header, and drop another table inside the merged cells. This new table I
group on Counties. I merge cells in the Group header here as well, and drop
another table inside grouped on Cities... I can then say "keep together" on
any of these tables
> it's a pain initially, but once you get the hang of it, it seems to
work... at least it has for me...
> hope this makes sense...
>
>
> ---
> "Chris Hays [MSFT]" wrote:
> > It attempts to keep the entire list together (not the individual groups
> > within the list).
> >
> > --
> > My employer's lawyers require me to say:
> > "This posting is provided 'AS IS' with no warranties, and confers no
> > rights."
> >
> > "sabe" <sabe@.discussions.microsoft.com> wrote in message
> > news:A38B97C5-3F5D-4EEC-BDB1-637131421CD0@.microsoft.com...
> > > OK, then what's the functionality of the _current_ KeepTogether
property?
> > Nothing, I suppose...
> > >
> > >
> > >
> > > "Chris Hays [MSFT]" wrote:
> > >
> > > > KeepTogether on Grouping is on our future features wishlist.
> > > >
> > > > (Note: KeepTogether on List wouldn't help since it tries to keep the
> > entire
> > > > list together, not the individual groups)
> > > >
> > > > --
> > > > My employer's lawyers require me to say:
> > > > "This posting is provided 'AS IS' with no warranties, and confers no
> > > > rights."
> > > >
> > > > "sabe" <sabe@.discussions.microsoft.com> wrote in message
> > > > news:D2FE2D32-51B3-4732-A0C6-0ACF1F1C579C@.microsoft.com...
> > > > > I'm in a search for a solution. I need to keep a group together.
If it
> > > > doesn't fit on the same page as the previous group it should start
on a
> > new
> > > > page. I cannot believe reporting services unable to provide this.
> > > > >
> > > > > Ok, table's grouping doesn't have keeptogether option (but the
table
> > > > itself has...).
> > > > >
> > > > > Let's see List. It doesn't work. I hoped SP1 will solve it, but
> > doesn't.
> > > > Shall we wait till SP2 or the Yukon version of RS?
> > > >
> > > >
> > > >
> >
> >
> >

Keeping the 10 newest records... in each GROUP ?

Ok, I give up.
I need to GROUP BY state... keep the newest 10 records in each state...
then delete all other records.
(Why do the simplest *SOUNDING* queries... always stump me?)
CREATE TABLE MyTable
(
MyKey Int
IDENTITY(1,1) PRIMARY KEY,
MySaveDate DateTime NOT NULL
DEFAULT GetDate(),
MyState VarChar(2) NOT NULL
)
GOHi
I'm not sure that understand your request
SELECT OrderID,CustomerId ,OrderDate
FROM Orders WHERE OrderDate IN (SELECT TOP 2 OrderDate FROM
Orders O WHERE O.CustomerId=Orders.CustomerId ORDER BY OrderDate DESC)
ORDER BY CustomerId
This is an example from NorthWind database. We get two newest OrderId made
by each Customer
Can you show us DDL+ sample data + expected result?
""A_Michigan_User"" <Michigan_RE_M0VE@.ameritech.net> wrote in message
news:e0VNlMdsFHA.276@.TK2MSFTNGP10.phx.gbl...
> Ok, I give up.
> I need to GROUP BY state... keep the newest 10 records in each state...
> then delete all other records.
> (Why do the simplest *SOUNDING* queries... always stump me?)
> CREATE TABLE MyTable
> (
> MyKey Int IDENTITY(1,1) PRIMARY KEY,
> MySaveDate DateTime NOT NULL DEFAULT
> GetDate(),
> MyState VarChar(2) NOT NULL
> )
> GO
>
>|||On Mon, 5 Sep 2005 00:34:43 -0400, "A_Michigan_User" wrote:

>Ok, I give up.
> I need to GROUP BY state... keep the newest 10 records in each state...
>then delete all other records.
>(Why do the simplest *SOUNDING* queries... always stump me?)
>CREATE TABLE MyTable
> (
> MyKey Int
>IDENTITY(1,1) PRIMARY KEY,
> MySaveDate DateTime NOT NULL
>DEFAULT GetDate(),
> MyState VarChar(2) NOT NULL
> )
> GO
Hi A_Michigan_User,
If you want to leave the table untouched but remove some rows from the
output, use the code Uri posted.
But if your requirement is to delete rows from the table, but keep only
the 10 most recent rows for each state, use the one below (note: this
version may retain more than 10 rows for a state if there are ties)
DELETE FROM MyTable
WHERE (SELECT COUNT(*)
FROM MyTable AS b
WHERE b.MyState = MyTable.MyState
AND b.MySaveDate > MyTable.MySaveDate) >= 10
Note: this code is untested. Test it on a backed-up database, inside a
transaction and ROLLBACK if the results are wrong.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

Wednesday, March 7, 2012

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
> >
> >
>

keep together table groups

Hi.
I have a table containing two groups and a detail area.In the preview tab ,on some pages the second group and the detail area splits to different pages.I want them to be always on the same page.How can I do that?I don't know of an explicit way of keeping them together. However bear in mind that paging in the preview tab and the web will probably be different to exported or printed reports. You can try to control the paging by forcing a page break in the group properties tab.|||

Hi,

Did you have any luck with this. I have many reports that I need to keep the groupings together, but have yet to find the solution. Thanks.

|||Thanks Adam.
But if I use a page break in the group properties, there will be one group per page.And this is not a thing I want.|||

This is amazing to me also.

I've used Crystal Reports and Visual FoxPro's report writer, and both have simple checkboxes to "Keep Together" that you can set for any group.

I haven't tried it yet, but what I'm wondering is if there's a way to use a subreport (or a table inside a table row?) because you can apparently set a table to keep together...

Somebody please post if you've found a way...

Thanks.

keep together table groups

Hi.
I have a table containing two groups and a detail area.In the preview tab ,on some pages the second group and the detail area splits to different pages.I want them to be always on the same page.How can I do that?
I don't know of an explicit way of keeping them together. However bear in mind that paging in the preview tab and the web will probably be different to exported or printed reports. You can try to control the paging by forcing a page break in the group properties tab.|||

Hi,

Did you have any luck with this. I have many reports that I need to keep the groupings together, but have yet to find the solution. Thanks.

|||Thanks Adam.
But if I use a page break in the group properties, there will be one group per page.And this is not a thing I want.
|||

This is amazing to me also.

I've used Crystal Reports and Visual FoxPro's report writer, and both have simple checkboxes to "Keep Together" that you can set for any group.

I haven't tried it yet, but what I'm wondering is if there's a way to use a subreport (or a table inside a table row?) because you can apparently set a table to keep together...

Somebody please post if you've found a way...

Thanks.

Keep Together Function Not Working

These 3 posts all address same problem: Basically, have some data, either in
a group of text boxes or in a table and they are ending up on two pages of
the report, when they should only be on one.
Has anyone found a solution?
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=47aa22ae-f3a2-41bd-9b5b-a233914f7c7d&sloc=en-us
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=12c7fbc6-1aca-4e3a-9b2f-e15917fb7c22&sloc=en-us
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=76f3399b-06f1-4438-bd6a-d468578e6e20&sloc=en-usI HAVE FOUND A "DIRTY" WAY TO GET THE GROUPINGS WORKING.
THE TRICK IS TO CREATE NESTED GROUPING TABLES.
For example,
I have a query output with Agent name , client name and client details.
In order to keep them grouped, I create a table with one group, the Agent
(header, no details).
In that group, I create a table with one group, the Client (same as above).
And in that I group I create another table with the Client Details.
I only use details at the lower lever (the client details).
That works.
I don't like it because it makes the report complicated but it works.
"msflinx" wrote:
> These 3 posts all address same problem: Basically, have some data, either in
> a group of text boxes or in a table and they are ending up on two pages of
> the report, when they should only be on one.
> Has anyone found a solution?
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=47aa22ae-f3a2-41bd-9b5b-a233914f7c7d&sloc=en-us
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=12c7fbc6-1aca-4e3a-9b2f-e15917fb7c22&sloc=en-us
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=76f3399b-06f1-4438-bd6a-d468578e6e20&sloc=en-us
>|||Very interesting approach. Should work though and since most of my reports
are only three levels deep, I might try it.
Thanks for you assistance.
"Kyriakos" wrote:
> I HAVE FOUND A "DIRTY" WAY TO GET THE GROUPINGS WORKING.
> THE TRICK IS TO CREATE NESTED GROUPING TABLES.
> For example,
> I have a query output with Agent name , client name and client details.
> In order to keep them grouped, I create a table with one group, the Agent
> (header, no details).
> In that group, I create a table with one group, the Client (same as above).
> And in that I group I create another table with the Client Details.
> I only use details at the lower lever (the client details).
> That works.
> I don't like it because it makes the report complicated but it works.
> "msflinx" wrote:
> > These 3 posts all address same problem: Basically, have some data, either in
> > a group of text boxes or in a table and they are ending up on two pages of
> > the report, when they should only be on one.
> >
> > Has anyone found a solution?
> >
> > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=47aa22ae-f3a2-41bd-9b5b-a233914f7c7d&sloc=en-us
> >
> > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=12c7fbc6-1aca-4e3a-9b2f-e15917fb7c22&sloc=en-us
> >
> > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=76f3399b-06f1-4438-bd6a-d468578e6e20&sloc=en-us
> >
> >

Friday, February 24, 2012

Keep Table Group on Same Page

I have a report that consists of a table containing invoices grouped by
Customer. I'd like to keep all invoices for any given customer on the same
page, but without needing a page break after each customer (each page can fit
about 12 or so groups on it).
Does anyone know how to do this?
I found a thread dated 5/20/2005 called "Control Page Breaking in Detail
(Keep Together)". I think some of the people on that thread are also trying
to do what I want to do.
I tried the method suggested by Matt Temple at the end of the thread, but
this did not have the desired effect. This method resulted in keeping each
group on the same page BUT meant that only the first invoice for each
customer was displayed.
Any ideas?
Thanks,
RobRight, I had another go at Matt's suggestion (included below for convenience)
from the other thread. I was doing step 7 wrong. I've now redone it and am
getting closer, but still without the effect I need.
The instructions ensure that all the detail elements within a group are kept
on the same page, but sometimes the group header is shown at the bottom of
the previous page instead of with the detail elements.
My next step was to edit the Grouping and Sorting Properties of the group to
add a check next to "Repeat group header". This ensures that when a block of
detail elements are kept together by taking them to the next page, the group
header is repeated with them. However, I'm still left with a copy of the
group header at the bottom of the previous page.
I can't be the only person who's wanted to do this. Can anyone help?
______________________________________
Instructions to keep group elements together:
1) Right-click border of table containing the elements
2) Select "Properties"
3) Go to the "General" tab, if not already displayed
4) Place a check in the "Fit table on one page if possible" checkbox
5) Go to the "Groups" tab
6) Click on the "Details grouping..." button
7) Select the elements which comprise of the detail group you want to keep
together
8) Click "OK"
9) Click "OK" again
10) Test the modified design
"Rob Nelder" wrote:
> I have a report that consists of a table containing invoices grouped by
> Customer. I'd like to keep all invoices for any given customer on the same
> page, but without needing a page break after each customer (each page can fit
> about 12 or so groups on it).
> Does anyone know how to do this?
> I found a thread dated 5/20/2005 called "Control Page Breaking in Detail
> (Keep Together)". I think some of the people on that thread are also trying
> to do what I want to do.
> I tried the method suggested by Matt Temple at the end of the thread, but
> this did not have the desired effect. This method resulted in keeping each
> group on the same page BUT meant that only the first invoice for each
> customer was displayed.
> Any ideas?
> Thanks,
> Rob

Keep section of report the same size

I need to keep a section of a report the same size. I have now a table with a detail and group section. The table header must print on every page and the table footer must print on every page. The detail section can only be 16 rows. When I have more than 16 rows the report page breaks perfectly and puts the remaining rows on the next page along with repeating the header and footer. The problem is when there are fewer than 16 rows the table does not take up the full page and looks horrible. All my displayed data is in the data set. I have looked at padding the dataset with bogus rows that would show up at the end and just not display but would rather take care of this on the report end. Any ideas?

Thanks, Chad

Hve you tried placing the table in a rectangle control and setting it's size? I believe it can grow if it needs to and uses the defined size as it's minimum.

Keep group together

Is there any way to keep a group header and detail rows together so I don't get the header on the bottom of a page and the details orphaned at the top of the next page?

Table Keep Together property only works at the table level (though not sure how that works anyway). And I don't want a page break before each group.

Thanks in advance.

The only solution to this problem as of now is to repeat the group headers on new page.

Shyam

|||Any idea if this is going to be addressed in a future version?|||

Probably yes, but not sure.

Shyam

Keep Group Together

Hi,
we currently have a situation where the column headings for our group is
printed on the bottom of the page and the data starts on the next page. Is
there anyway to ensure the group header prints on the next page instead if
no data can be fitted on the page. Hope this is clear - in Crystal there
was an option Keep group together which did this.
thanks
MattTry putting the items you want to keep together in a rectangle. Sometimes
that keeps them on the same page. If you're working with tables, there are
problems with pagination that probably we'll have to wait for a later
version to fix.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:eiyCb601EHA.3392@.TK2MSFTNGP10.phx.gbl...
> Hi,
> we currently have a situation where the column headings for our group is
> printed on the bottom of the page and the data starts on the next page.
> Is
> there anyway to ensure the group header prints on the next page instead if
> no data can be fitted on the page. Hope this is clear - in Crystal there
> was an option Keep group together which did this.
> thanks
> Matt
>|||Thanks for the response Jeff.
Just clarifying:
Are you saying put the whole table in a rectangle?
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:e6dvxV11EHA.4000@.TK2MSFTNGP10.phx.gbl...
> Try putting the items you want to keep together in a rectangle. Sometimes
> that keeps them on the same page. If you're working with tables, there
are
> problems with pagination that probably we'll have to wait for a later
> version to fix.
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:eiyCb601EHA.3392@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > we currently have a situation where the column headings for our group is
> > printed on the bottom of the page and the data starts on the next page.
> > Is
> > there anyway to ensure the group header prints on the next page instead
if
> > no data can be fitted on the page. Hope this is clear - in Crystal
there
> > was an option Keep group together which did this.
> >
> > thanks
> >
> > Matt
> >
> >
>|||Yes, and other items as well if preferable. It's not completely
deterministic, but can influence the page breaks.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:%23$AxPFC3EHA.3840@.tk2msftngp13.phx.gbl...
> Thanks for the response Jeff.
> Just clarifying:
> Are you saying put the whole table in a rectangle?
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:e6dvxV11EHA.4000@.TK2MSFTNGP10.phx.gbl...
>> Try putting the items you want to keep together in a rectangle.
>> Sometimes
>> that keeps them on the same page. If you're working with tables, there
> are
>> problems with pagination that probably we'll have to wait for a later
>> version to fix.
>> --
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
>> news:eiyCb601EHA.3392@.TK2MSFTNGP10.phx.gbl...
>> > Hi,
>> >
>> > we currently have a situation where the column headings for our group
>> > is
>> > printed on the bottom of the page and the data starts on the next page.
>> > Is
>> > there anyway to ensure the group header prints on the next page instead
> if
>> > no data can be fitted on the page. Hope this is clear - in Crystal
> there
>> > was an option Keep group together which did this.
>> >
>> > thanks
>> >
>> > Matt
>> >
>> >
>>
>|||Ok, will give it a try. Thanks
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:%23CoByFI3EHA.1392@.tk2msftngp13.phx.gbl...
> Yes, and other items as well if preferable. It's not completely
> deterministic, but can influence the page breaks.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:%23$AxPFC3EHA.3840@.tk2msftngp13.phx.gbl...
> > Thanks for the response Jeff.
> >
> > Just clarifying:
> > Are you saying put the whole table in a rectangle?
> >
> > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > news:e6dvxV11EHA.4000@.TK2MSFTNGP10.phx.gbl...
> >> Try putting the items you want to keep together in a rectangle.
> >> Sometimes
> >> that keeps them on the same page. If you're working with tables, there
> > are
> >> problems with pagination that probably we'll have to wait for a later
> >> version to fix.
> >>
> >> --
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> >> news:eiyCb601EHA.3392@.TK2MSFTNGP10.phx.gbl...
> >> > Hi,
> >> >
> >> > we currently have a situation where the column headings for our group
> >> > is
> >> > printed on the bottom of the page and the data starts on the next
page.
> >> > Is
> >> > there anyway to ensure the group header prints on the next page
instead
> > if
> >> > no data can be fitted on the page. Hope this is clear - in Crystal
> > there
> >> > was an option Keep group together which did this.
> >> >
> >> > thanks
> >> >
> >> > Matt
> >> >
> >> >
> >>
> >>
> >
> >
>

Keep group rows together

Hi,

Is it possible to keep a group in a table report on the one page if this group could be fitted into the rest of the page and start new page otherwise?

Thanks,
Igor

This is taken from here http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx

Using Rectangles to Keep Objects Together
Rectangles in Reporting Services can be used either as graphical elements or as containers of objects. As object containers, they keep objects together on a page and control how objects move and push each other.

To keep multiple objects together on a page, put the objects within a rectangle. You can then put a page break before or after the rectangle by using the PageBreakAtStart or PageBreakAtEnd properties for the rectangle.

Using Rectangles to Control Item Growth and Displacement
Items within a rectangle become peers of each other and are governed by the rules of how peer items are positioned on the page as they move or grow. For example:

? Items will push or displace each other within the rectangle.
? Items will not push or displace items outside the rectangle, because they are not their peers.
? If necessary, a rectangle will grow to accommodate the items it contains.

You can use this logic to your advantage when dealing with objects that expand. For example:

? If you want to leave a blank space in your report for a table to expand into, group the blank space and the table in the same rectangle. When the table grows, it will push the blank space.
? If you want to prevent a matrix from pushing items off the right edge of the page, put the matrix within a rectangle with blank space to its right. Now, the matrix is no longer a peer to the other item on the page and will not be able to push it until the matrix can no longer be contained within its rectangle.

Keep Group Data Together

In Access there was a keep together...
How do I make sure data in a group moves to the next page if it will not fit
on the current page?
--
Thank You, LeoHello Leo,
Thank you for your post!
Regarding your question, you can add page break at each group as you want.
For example:
1. Click Layout
2. Click a table, and click table_cateory footer row icon and select the
row, right click group footer handle button
3. Select edit group
4. Select Page break at end box and click OK
Hope this information is helpful.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Keep Group Data Together
| thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==| X-WBNR-Posting-Host: 64.91.16.201
| From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| Subject: Keep Group Data Together
| Date: Tue, 2 Nov 2004 18:09:01 -0800
| Lines: 6
| Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33917
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| In Access there was a keep together...
|
| How do I make sure data in a group moves to the next page if it will not
fit
| on the current page?
| --
| Thank You, Leo
||||Peter,
Thanks for the post. I cant have seperate pages for each group . When the
whole group will not fit on the current page I would like it to be sent to
the next page.
Thanks, Leo
"Peter Yang [MSFT]" wrote:
> Hello Leo,
> Thank you for your post!
> Regarding your question, you can add page break at each group as you want.
> For example:
> 1. Click Layout
> 2. Click a table, and click table_cateory footer row icon and select the
> row, right click group footer handle button
> 3. Select edit group
> 4. Select Page break at end box and click OK
> Hope this information is helpful.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Keep Group Data Together
> | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==> | X-WBNR-Posting-Host: 64.91.16.201
> | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | Subject: Keep Group Data Together
> | Date: Tue, 2 Nov 2004 18:09:01 -0800
> | Lines: 6
> | Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33917
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | In Access there was a keep together...
> |
> | How do I make sure data in a group moves to the next page if it will not
> fit
> | on the current page?
> | --
> | Thank You, Leo
> |
>|||Hello Leo,
Thank you for your reply. You can also define the page size for a report.
Rendering extensions that support page size create page breaks based on the
page size. Rendering extensions that do not support page size ignore page
size. To change the page size for a report, change the PageHeight and
PageWidth properties of the report.
Hope this helps. Have a great day!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Keep Group Data Together
| thread-index: AcTBsZrY/4iZk6OJQlSnwYeARwU78A==| X-WBNR-Posting-Host: 64.91.16.201
| From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
<D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
| Subject: RE: Keep Group Data Together
| Date: Wed, 3 Nov 2004 06:30:02 -0800
| Lines: 75
| Message-ID: <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33956
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Peter,
|
| Thanks for the post. I cant have seperate pages for each group . When
the
| whole group will not fit on the current page I would like it to be sent
to
| the next page.
|
| Thanks, Leo
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Leo,
| >
| > Thank you for your post!
| >
| > Regarding your question, you can add page break at each group as you
want.
| > For example:
| >
| > 1. Click Layout
| > 2. Click a table, and click table_cateory footer row icon and select
the
| > row, right click group footer handle button
| > 3. Select edit group
| > 4. Select Page break at end box and click OK
| >
| > Hope this information is helpful.
| >
| > Best Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > =====================================================| > When responding to posts, please "Reply to Group" via
| > your newsreader so that others may learn and benefit
| > from your issue.
| > =====================================================| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| > --
| > | Thread-Topic: Keep Group Data Together
| > | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==| > | X-WBNR-Posting-Host: 64.91.16.201
| > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| > | Subject: Keep Group Data Together
| > | Date: Tue, 2 Nov 2004 18:09:01 -0800
| > | Lines: 6
| > | Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:33917
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | In Access there was a keep together...
| > |
| > | How do I make sure data in a group moves to the next page if it will
not
| > fit
| > | on the current page?
| > | --
| > | Thank You, Leo
| > |
| >
| >
||||"Peter Yang [MSFT]" wrote:
> Hello Leo,
> Thank you for your reply. You can also define the page size for a report.
> Rendering extensions that support page size create page breaks based on the
> page size. Rendering extensions that do not support page size ignore page
> size. To change the page size for a report, change the PageHeight and
> PageWidth properties of the report.
> Hope this helps. Have a great day!
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Keep Group Data Together
> | thread-index: AcTBsZrY/4iZk6OJQlSnwYeARwU78A==> | X-WBNR-Posting-Host: 64.91.16.201
> | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
> | Subject: RE: Keep Group Data Together
> | Date: Wed, 3 Nov 2004 06:30:02 -0800
> | Lines: 75
> | Message-ID: <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33956
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Peter,
> |
> | Thanks for the post. I cant have seperate pages for each group . When
> the
> | whole group will not fit on the current page I would like it to be sent
> to
> | the next page.
> |
> | Thanks, Leo
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello Leo,
> | >
> | > Thank you for your post!
> | >
> | > Regarding your question, you can add page break at each group as you
> want.
> | > For example:
> | >
> | > 1. Click Layout
> | > 2. Click a table, and click table_cateory footer row icon and select
> the
> | > row, right click group footer handle button
> | > 3. Select edit group
> | > 4. Select Page break at end box and click OK
> | >
> | > Hope this information is helpful.
> | >
> | > Best Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > Get Secure! - www.microsoft.com/security
> | >
> | > =====================================================> | > When responding to posts, please "Reply to Group" via
> | > your newsreader so that others may learn and benefit
> | > from your issue.
> | > =====================================================> | > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> | >
> | >
> | > --
> | > | Thread-Topic: Keep Group Data Together
> | > | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==> | > | X-WBNR-Posting-Host: 64.91.16.201
> | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | > | Subject: Keep Group Data Together
> | > | Date: Tue, 2 Nov 2004 18:09:01 -0800
> | > | Lines: 6
> | > | Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:33917
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | In Access there was a keep together...
> | > |
> | > | How do I make sure data in a group moves to the next page if it will
> not
> | > fit
> | > | on the current page?
> | > | --
> | > | Thank You, Leo
> | > |
> | >
> | >
> |
>|||Peter,
How do I know where the pages ends when the data is changeing all the time?
Is there no setting like in access that will keep a group of data together
dynamically?
If I change the page height and width it will not print correctly...
Thanks, Leo
"Peter Yang [MSFT]" wrote:
> Hello Leo,
> Thank you for your reply. You can also define the page size for a report.
> Rendering extensions that support page size create page breaks based on the
> page size. Rendering extensions that do not support page size ignore page
> size. To change the page size for a report, change the PageHeight and
> PageWidth properties of the report.
> Hope this helps. Have a great day!
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Keep Group Data Together
> | thread-index: AcTBsZrY/4iZk6OJQlSnwYeARwU78A==> | X-WBNR-Posting-Host: 64.91.16.201
> | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
> | Subject: RE: Keep Group Data Together
> | Date: Wed, 3 Nov 2004 06:30:02 -0800
> | Lines: 75
> | Message-ID: <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33956
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Peter,
> |
> | Thanks for the post. I cant have seperate pages for each group . When
> the
> | whole group will not fit on the current page I would like it to be sent
> to
> | the next page.
> |
> | Thanks, Leo
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello Leo,
> | >
> | > Thank you for your post!
> | >
> | > Regarding your question, you can add page break at each group as you
> want.
> | > For example:
> | >
> | > 1. Click Layout
> | > 2. Click a table, and click table_cateory footer row icon and select
> the
> | > row, right click group footer handle button
> | > 3. Select edit group
> | > 4. Select Page break at end box and click OK
> | >
> | > Hope this information is helpful.
> | >
> | > Best Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > Get Secure! - www.microsoft.com/security
> | >
> | > =====================================================> | > When responding to posts, please "Reply to Group" via
> | > your newsreader so that others may learn and benefit
> | > from your issue.
> | > =====================================================> | > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> | >
> | >
> | > --
> | > | Thread-Topic: Keep Group Data Together
> | > | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==> | > | X-WBNR-Posting-Host: 64.91.16.201
> | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | > | Subject: Keep Group Data Together
> | > | Date: Tue, 2 Nov 2004 18:09:01 -0800
> | > | Lines: 6
> | > | Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:33917
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | In Access there was a keep together...
> | > |
> | > | How do I make sure data in a group moves to the next page if it will
> not
> | > fit
> | > | on the current page?
> | > | --
> | > | Thank You, Leo
> | > |
> | >
> | >
> |
>|||Hello Leo,
Thank you for your reply.
If you check "Select Page break at end" box as I mentioned, the there shall
be a page break at the end of each group. Also, the group can be in
multiple pages if a group is not fit in one page according to the page size
but the last page may not full because there is a page break at the end of
each group.
Have a great day!
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Keep Group Data Together
| thread-index: AcTCd2yfHR7OlHLpTzeFPn4UYW1JNQ==| X-WBNR-Posting-Host: 64.91.16.201
| From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
<D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
<72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
<CUiSUgjwEHA.764@.cpmsftngxa10.phx.gbl>
| Subject: RE: Keep Group Data Together
| Date: Thu, 4 Nov 2004 06:06:05 -0800
| Lines: 148
| Message-ID: <C7461150-2CC3-4DB7-AC26-E987D1CBBE39@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:34074
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Peter,
|
| How do I know where the pages ends when the data is changeing all the
time?
| Is there no setting like in access that will keep a group of data
together
| dynamically?
| If I change the page height and width it will not print correctly...
|
| Thanks, Leo
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Leo,
| >
| > Thank you for your reply. You can also define the page size for a
report.
| > Rendering extensions that support page size create page breaks based on
the
| > page size. Rendering extensions that do not support page size ignore
page
| > size. To change the page size for a report, change the PageHeight and
| > PageWidth properties of the report.
| >
| > Hope this helps. Have a great day!
| >
| > Best Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > =====================================================| > When responding to posts, please "Reply to Group" via
| > your newsreader so that others may learn and benefit
| > from your issue.
| > =====================================================| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| > --
| > | Thread-Topic: Keep Group Data Together
| > | thread-index: AcTBsZrY/4iZk6OJQlSnwYeARwU78A==| > | X-WBNR-Posting-Host: 64.91.16.201
| > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| > | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| > <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
| > | Subject: RE: Keep Group Data Together
| > | Date: Wed, 3 Nov 2004 06:30:02 -0800
| > | Lines: 75
| > | Message-ID: <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:33956
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | Peter,
| > |
| > | Thanks for the post. I cant have seperate pages for each group .
When
| > the
| > | whole group will not fit on the current page I would like it to be
sent
| > to
| > | the next page.
| > |
| > | Thanks, Leo
| > |
| > | "Peter Yang [MSFT]" wrote:
| > |
| > | > Hello Leo,
| > | >
| > | > Thank you for your post!
| > | >
| > | > Regarding your question, you can add page break at each group as
you
| > want.
| > | > For example:
| > | >
| > | > 1. Click Layout
| > | > 2. Click a table, and click table_cateory footer row icon and
select
| > the
| > | > row, right click group footer handle button
| > | > 3. Select edit group
| > | > 4. Select Page break at end box and click OK
| > | >
| > | > Hope this information is helpful.
| > | >
| > | > Best Regards,
| > | >
| > | > Peter Yang
| > | > MCSE2000/2003, MCSA, MCDBA
| > | > Microsoft Online Partner Support
| > | >
| > | > Get Secure! - www.microsoft.com/security
| > | >
| > | > =====================================================| > | > When responding to posts, please "Reply to Group" via
| > | > your newsreader so that others may learn and benefit
| > | > from your issue.
| > | > =====================================================| > | > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| > | >
| > | >
| > | > --
| > | > | Thread-Topic: Keep Group Data Together
| > | > | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==| > | > | X-WBNR-Posting-Host: 64.91.16.201
| > | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| > | > | Subject: Keep Group Data Together
| > | > | Date: Tue, 2 Nov 2004 18:09:01 -0800
| > | > | Lines: 6
| > | > | Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| > | > | MIME-Version: 1.0
| > | > | Content-Type: text/plain;
| > | > | charset="Utf-8"
| > | > | Content-Transfer-Encoding: 7bit
| > | > | X-Newsreader: Microsoft CDO for Windows 2000
| > | > | Content-Class: urn:content-classes:message
| > | > | Importance: normal
| > | > | Priority: normal
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | > | Xref: cpmsftngxa10.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:33917
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | > |
| > | > | In Access there was a keep together...
| > | > |
| > | > | How do I make sure data in a group moves to the next page if it
will
| > not
| > | > fit
| > | > | on the current page?
| > | > | --
| > | > | Thank You, Leo
| > | > |
| > | >
| > | >
| > |
| >
| >
||||Hello Peter,
I dont think I am communicating what I need very well.
I need the groups to continue unless it splits it in the middle of a group.
The group data is generally small and I do not want the groups to be on new
pages every time.
Thanks, Leo
"Peter Yang [MSFT]" wrote:
> Hello Leo,
> Thank you for your reply.
> If you check "Select Page break at end" box as I mentioned, the there shall
> be a page break at the end of each group. Also, the group can be in
> multiple pages if a group is not fit in one page according to the page size
> but the last page may not full because there is a page break at the end of
> each group.
> Have a great day!
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Keep Group Data Together
> | thread-index: AcTCd2yfHR7OlHLpTzeFPn4UYW1JNQ==> | X-WBNR-Posting-Host: 64.91.16.201
> | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
> <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
> <CUiSUgjwEHA.764@.cpmsftngxa10.phx.gbl>
> | Subject: RE: Keep Group Data Together
> | Date: Thu, 4 Nov 2004 06:06:05 -0800
> | Lines: 148
> | Message-ID: <C7461150-2CC3-4DB7-AC26-E987D1CBBE39@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:34074
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Peter,
> |
> | How do I know where the pages ends when the data is changeing all the
> time?
> | Is there no setting like in access that will keep a group of data
> together
> | dynamically?
> | If I change the page height and width it will not print correctly...
> |
> | Thanks, Leo
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello Leo,
> | >
> | > Thank you for your reply. You can also define the page size for a
> report.
> | > Rendering extensions that support page size create page breaks based on
> the
> | > page size. Rendering extensions that do not support page size ignore
> page
> | > size. To change the page size for a report, change the PageHeight and
> | > PageWidth properties of the report.
> | >
> | > Hope this helps. Have a great day!
> | >
> | > Best Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > Get Secure! - www.microsoft.com/security
> | >
> | > =====================================================> | > When responding to posts, please "Reply to Group" via
> | > your newsreader so that others may learn and benefit
> | > from your issue.
> | > =====================================================> | > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> | >
> | >
> | > --
> | > | Thread-Topic: Keep Group Data Together
> | > | thread-index: AcTBsZrY/4iZk6OJQlSnwYeARwU78A==> | > | X-WBNR-Posting-Host: 64.91.16.201
> | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | > | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> | > <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
> | > | Subject: RE: Keep Group Data Together
> | > | Date: Wed, 3 Nov 2004 06:30:02 -0800
> | > | Lines: 75
> | > | Message-ID: <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:33956
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | Peter,
> | > |
> | > | Thanks for the post. I cant have seperate pages for each group .
> When
> | > the
> | > | whole group will not fit on the current page I would like it to be
> sent
> | > to
> | > | the next page.
> | > |
> | > | Thanks, Leo
> | > |
> | > | "Peter Yang [MSFT]" wrote:
> | > |
> | > | > Hello Leo,
> | > | >
> | > | > Thank you for your post!
> | > | >
> | > | > Regarding your question, you can add page break at each group as
> you
> | > want.
> | > | > For example:
> | > | >
> | > | > 1. Click Layout
> | > | > 2. Click a table, and click table_cateory footer row icon and
> select
> | > the
> | > | > row, right click group footer handle button
> | > | > 3. Select edit group
> | > | > 4. Select Page break at end box and click OK
> | > | >
> | > | > Hope this information is helpful.
> | > | >
> | > | > Best Regards,
> | > | >
> | > | > Peter Yang
> | > | > MCSE2000/2003, MCSA, MCDBA
> | > | > Microsoft Online Partner Support
> | > | >
> | > | > Get Secure! - www.microsoft.com/security
> | > | >
> | > | > =====================================================> | > | > When responding to posts, please "Reply to Group" via
> | > | > your newsreader so that others may learn and benefit
> | > | > from your issue.
> | > | > =====================================================> | > | > This posting is provided "AS IS" with no warranties, and confers no
> | > rights.
> | > | >
> | > | >
> | > | > --
> | > | > | Thread-Topic: Keep Group Data Together
> | > | > | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==> | > | > | X-WBNR-Posting-Host: 64.91.16.201
> | > | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
> | > | > | Subject: Keep Group Data Together
> | > | > | Date: Tue, 2 Nov 2004 18:09:01 -0800
> | > | > | Lines: 6
> | > | > | Message-ID: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
> | > | > | MIME-Version: 1.0
> | > | > | Content-Type: text/plain;
> | > | > | charset="Utf-8"
> | > | > | Content-Transfer-Encoding: 7bit
> | > | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | > | Content-Class: urn:content-classes:message
> | > | > | Importance: normal
> | > | > | Priority: normal
> | > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | > | Xref: cpmsftngxa10.phx.gbl
> | > microsoft.public.sqlserver.reportingsvcs:33917
> | > | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > | > |
> | > | > | In Access there was a keep together...
> | > | > |
> | > | > | How do I make sure data in a group moves to the next page if it
> will
> | > not
> | > | > fit
> | > | > | on the current page?
> | > | > | --
> | > | > | Thank You, Leo
> | > | > |
> | > | >
> | > | >
> | > |
> | >
> | >
> |
>|||Hello Leo,
Thank you for your reply. It seems that you do not want group information
to be split to a new page. Based on my research, there is no method at
present to achieve this goal. I am sorry for the inconvenience. We strive
to capture any product issues or product feedback so as to ensure that we
are continuously developing Microsoft products to meet customer needs. Your
feedback is taken seriously. I will make sure it is routed through the
proper channels and thank you again for your valuable feedback. You can
also post your suggestions to MSWISH: mswish@.microsoft.com.
Also, you may try to use this option to see if can partially meet your
requirement:
1. Click Layout
2. Click a table, and click table_cateory footer row icon and select the
row, right click group footer handle button
3. Select edit group
4. Select "Repeat group header" and "Repeat group footer" and click OK.
Each page shall have group information at this time.
If you have further questions or concerns, please feel free to respond
back.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Keep Group Data Together
| thread-index: AcTDXg9z62ueWoV6Q3e2ObxIX206vg==| X-WBNR-Posting-Host: 64.91.16.201
| From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
<D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
<72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
<CUiSUgjwEHA.764@.cpmsftngxa10.phx.gbl>
<C7461150-2CC3-4DB7-AC26-E987D1CBBE39@.microsoft.com>
<aA7BISwwEHA.768@.cpmsftngxa10.phx.gbl>
| Subject: RE: Keep Group Data Together
| Date: Fri, 5 Nov 2004 09:37:02 -0800
| Lines: 230
| Message-ID: <C4CB5E79-7FB8-4977-8F64-F8BB53109E88@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:34228
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hello Peter,
|
| I dont think I am communicating what I need very well.
|
| I need the groups to continue unless it splits it in the middle of a
group.
| The group data is generally small and I do not want the groups to be on
new
| pages every time.
|
| Thanks, Leo
| "Peter Yang [MSFT]" wrote:
|
| > Hello Leo,
| >
| > Thank you for your reply.
| >
| > If you check "Select Page break at end" box as I mentioned, the there
shall
| > be a page break at the end of each group. Also, the group can be in
| > multiple pages if a group is not fit in one page according to the page
size
| > but the last page may not full because there is a page break at the end
of
| > each group.
| >
| > Have a great day!
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > =====================================================| > When responding to posts, please "Reply to Group" via
| > your newsreader so that others may learn and benefit
| > from your issue.
| > =====================================================| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| > --
| > | Thread-Topic: Keep Group Data Together
| > | thread-index: AcTCd2yfHR7OlHLpTzeFPn4UYW1JNQ==| > | X-WBNR-Posting-Host: 64.91.16.201
| > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| > | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| > <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
| > <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
| > <CUiSUgjwEHA.764@.cpmsftngxa10.phx.gbl>
| > | Subject: RE: Keep Group Data Together
| > | Date: Thu, 4 Nov 2004 06:06:05 -0800
| > | Lines: 148
| > | Message-ID: <C7461150-2CC3-4DB7-AC26-E987D1CBBE39@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:34074
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | Peter,
| > |
| > | How do I know where the pages ends when the data is changeing all the
| > time?
| > | Is there no setting like in access that will keep a group of data
| > together
| > | dynamically?
| > | If I change the page height and width it will not print correctly...
| > |
| > | Thanks, Leo
| > |
| > | "Peter Yang [MSFT]" wrote:
| > |
| > | > Hello Leo,
| > | >
| > | > Thank you for your reply. You can also define the page size for a
| > report.
| > | > Rendering extensions that support page size create page breaks
based on
| > the
| > | > page size. Rendering extensions that do not support page size
ignore
| > page
| > | > size. To change the page size for a report, change the PageHeight
and
| > | > PageWidth properties of the report.
| > | >
| > | > Hope this helps. Have a great day!
| > | >
| > | > Best Regards,
| > | >
| > | > Peter Yang
| > | > MCSE2000/2003, MCSA, MCDBA
| > | > Microsoft Online Partner Support
| > | >
| > | > Get Secure! - www.microsoft.com/security
| > | >
| > | > =====================================================| > | > When responding to posts, please "Reply to Group" via
| > | > your newsreader so that others may learn and benefit
| > | > from your issue.
| > | > =====================================================| > | > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| > | >
| > | >
| > | > --
| > | > | Thread-Topic: Keep Group Data Together
| > | > | thread-index: AcTBsZrY/4iZk6OJQlSnwYeARwU78A==| > | > | X-WBNR-Posting-Host: 64.91.16.201
| > | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| > | > | References: <B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| > | > <D7zPvBYwEHA.3956@.cpmsftngxa10.phx.gbl>
| > | > | Subject: RE: Keep Group Data Together
| > | > | Date: Wed, 3 Nov 2004 06:30:02 -0800
| > | > | Lines: 75
| > | > | Message-ID: <72EAD227-4116-46A3-9468-BE7D07AE19F7@.microsoft.com>
| > | > | MIME-Version: 1.0
| > | > | Content-Type: text/plain;
| > | > | charset="Utf-8"
| > | > | Content-Transfer-Encoding: 7bit
| > | > | X-Newsreader: Microsoft CDO for Windows 2000
| > | > | Content-Class: urn:content-classes:message
| > | > | Importance: normal
| > | > | Priority: normal
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | > | Xref: cpmsftngxa10.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:33956
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | > |
| > | > | Peter,
| > | > |
| > | > | Thanks for the post. I cant have seperate pages for each group .
| > When
| > | > the
| > | > | whole group will not fit on the current page I would like it to
be
| > sent
| > | > to
| > | > | the next page.
| > | > |
| > | > | Thanks, Leo
| > | > |
| > | > | "Peter Yang [MSFT]" wrote:
| > | > |
| > | > | > Hello Leo,
| > | > | >
| > | > | > Thank you for your post!
| > | > | >
| > | > | > Regarding your question, you can add page break at each group
as
| > you
| > | > want.
| > | > | > For example:
| > | > | >
| > | > | > 1. Click Layout
| > | > | > 2. Click a table, and click table_cateory footer row icon and
| > select
| > | > the
| > | > | > row, right click group footer handle button
| > | > | > 3. Select edit group
| > | > | > 4. Select Page break at end box and click OK
| > | > | >
| > | > | > Hope this information is helpful.
| > | > | >
| > | > | > Best Regards,
| > | > | >
| > | > | > Peter Yang
| > | > | > MCSE2000/2003, MCSA, MCDBA
| > | > | > Microsoft Online Partner Support
| > | > | >
| > | > | > Get Secure! - www.microsoft.com/security
| > | > | >
| > | > | > =====================================================| > | > | > When responding to posts, please "Reply to Group" via
| > | > | > your newsreader so that others may learn and benefit
| > | > | > from your issue.
| > | > | > =====================================================| > | > | > This posting is provided "AS IS" with no warranties, and
confers no
| > | > rights.
| > | > | >
| > | > | >
| > | > | > --
| > | > | > | Thread-Topic: Keep Group Data Together
| > | > | > | thread-index: AcTBShZE44Vtqjs2RvyWOxH3YzmrSw==| > | > | > | X-WBNR-Posting-Host: 64.91.16.201
| > | > | > | From: "=?Utf-8?B?VHJ1c3N3b3Jrc0xlbw==?=" <Leo@.noemail.noemail>
| > | > | > | Subject: Keep Group Data Together
| > | > | > | Date: Tue, 2 Nov 2004 18:09:01 -0800
| > | > | > | Lines: 6
| > | > | > | Message-ID:
<B03DAFF9-37C8-4E0E-AF7A-394258B1233F@.microsoft.com>
| > | > | > | MIME-Version: 1.0
| > | > | > | Content-Type: text/plain;
| > | > | > | charset="Utf-8"
| > | > | > | Content-Transfer-Encoding: 7bit
| > | > | > | X-Newsreader: Microsoft CDO for Windows 2000
| > | > | > | Content-Class: urn:content-classes:message
| > | > | > | Importance: normal
| > | > | > | Priority: normal
| > | > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | > | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | > | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | > | > | Xref: cpmsftngxa10.phx.gbl
| > | > microsoft.public.sqlserver.reportingsvcs:33917
| > | > | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | > | > |
| > | > | > | In Access there was a keep together...
| > | > | > |
| > | > | > | How do I make sure data in a group moves to the next page if
it
| > will
| > | > not
| > | > | > fit
| > | > | > | on the current page?
| > | > | > | --
| > | > | > | Thank You, Leo
| > | > | > |
| > | > | >
| > | > | >
| > | > |
| > | >
| > | >
| > |
| >
| >
|