KPI - Sales Trend

Hi,

I am trying to create a Sales Trend KPI, where the value expression is last month sales (Identify last month based on current system date) and target expression is last month previous year sales amount times 1.04.

Is there a way to accomplish this using MDX in KPI.

Thanks,

Ravi

Identifying the lastest month of data is the trickiest part. One technique to do this is to create a calculated member named CurrentMonth that uses the VBA!Date() and VBA!DatePart() to construct a member reference that can then be resolved with StrToMember. Another techinique is to again create a CurrentMonth calculation with a hard coded reference to a date and then update the definition of this calculation each time a new month of data is loaded. (See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbadev/html/pullingpiecesapart.asp for some help on the VBA functions.)

Once you have this CurrentMonth member, you can use the ParallelPeriod MDX function (http://msdn2.microsoft.com/en-us/library/ms145500(SQL.90).aspx) to calculate the lat month of the previous year.

|||Thanks Matt.

Knowing current database

How can I identify the database which I execute an TSQL
statement.
The counterpart to @.@.ServerName...
Something like @.@.database?
thanks in advance.
/Tob
Tobbe,
select db_name() as DatabaseName
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Tobbe wrote:
> How can I identify the database which I execute an TSQL
> statement.
> The counterpart to @.@.ServerName...
> Something like @.@.database?
> thanks in advance.
> /Tob

Killing automatically crashed sessions ??

If one of my workstations (which communicate using ODBC) crashes, I still see it as connected in Enterprise Manager under management\current activity\.
Is there anyway to kill automatically the crashed cessions?
Thkx in advanceYou could periodicaly scan the sysprocesses table and kill any connection that hasn't had activity in some predeturmined amount of time.

Keep track of data base versions

Hi

We have several data bases and we update them every once in a while.

We want to mark each current state witha version in order to be able to track the changes made between 2 versions.

Any recommended tool?

Thanks

Avi harush

Check in Books Online about using Extended Properties.

Topics:

sp_addextendedproperty

sp_updateextendedproperty

fn_listextendedproperty

Code Snippet

EXECUTE sp_updateextendedproperty 'Version', 'v 1.0'
SELECT * FROM ::fn_listextendedproperty
( 'Version', default, default, default, default, default, default )
EXECUTE sp_updateextendedproperty 'Version', 'v 1.1'
SELECT * FROM ::fn_listextendedproperty
( 'Version', default, default, default, default, default, default )

|||

Thanks

Isn't there a product for doing this?

Avi

|||

I don't know of a third party tool to manage this.

But it would be very simple to create a couple of stored procedures (or script files) that can be used by your Upgrade process to check the version and either inform or take appropriate action.

Keep running out of memory?

There is a server configuration called 'Open Objects' that
you will need to modify.
Run this to determine current count (look for open objects
in results)
USE master
EXEC sp_configure 'show advanced option', '1'
--Here is the message:
Configuration option 'show advanced options' changed from
0 to 1.
Run the RECONFIGURE command to install.
RECONFIGURE
EXEC sp_configure
If you need to increase it, just use this command
USE master
EXEC sp_configure 'OPEN OBJECTS', '#of objects'

>--Original Message--
>Does anyone know how-to fix this error?
>17424 :
>Warning: OPEN OBJECTS parameter may be too low.
>
>.
>The values defaults to 0, which means auto-config. SQL Server will use the m
emory as it needs for open
objects. This error message often indicates that one need more memory in the
machine, quite simply.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"sbauer" <anonymous@.discussions.microsoft.com> wrote in message news:e4c701c411d9$b3bcd950$
a001280a@.phx.gbl...
> There is a server configuration called 'Open Objects' that
> you will need to modify.
> Run this to determine current count (look for open objects
> in results)
> USE master
> EXEC sp_configure 'show advanced option', '1'
> --Here is the message:
> Configuration option 'show advanced options' changed from
> 0 to 1.
> Run the RECONFIGURE command to install.
> RECONFIGURE
> EXEC sp_configure
> If you need to increase it, just use this command
> USE master
> EXEC sp_configure 'OPEN OBJECTS', '#of objects'
>|||I have 4 Gig of memory in this server and a pretty small database (50 meg).
Do you still think it is a memory problem?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23G2vf0dEEHA.3080@.TK2MSFTNGP10.phx.gbl...
> The values defaults to 0, which means auto-config. SQL Server will use the
memory as it needs for open
> objects. This error message often indicates that one need more memory in
the machine, quite simply.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "sbauer" <anonymous@.discussions.microsoft.com> wrote in message
news:e4c701c411d9$b3bcd950$a001280a@.phx.gbl...
>|||What are your settings (sp_configure) for max server memory and open objects
?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Dan Marth" <danmarth@.earthlink.net> wrote in message news:uA4ZB5eEEHA.3016@.TK2MSFTNGP11.ph
x.gbl...
> I have 4 Gig of memory in this server and a pretty small database (50 meg)
.
> Do you still think it is a memory problem?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23G2vf0dEEHA.3080@.TK2MSFTNGP10.phx.gbl...
> memory as it needs for open
> the machine, quite simply.
> news:e4c701c411d9$b3bcd950$a001280a@.phx.gbl...
>|||when I ran the USE master EXEC sp_configure 'show advanced option', '1' I
was already set to 1. So I changed it back to '0' and hopefully auto config
should work better. What do you think? Below are those settings you ask
for:
Server Memory
Minimum 4
Maximum: 2147483647
Config_value: 2147483647
Run_value: 2147483647
Open Objects
Minimum 0
Maximum 2147483647
Config_value 1000
Run_value 1000
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23GEyj7eEEHA.1376@.TK2MSFTNGP10.phx.gbl...
> What are your settings (sp_configure) for max server memory and open
objects?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Dan Marth" <danmarth@.earthlink.net> wrote in message
news:uA4ZB5eEEHA.3016@.TK2MSFTNGP11.phx.gbl...
meg).
in
the
in
>|||Show advanced options does not control auto-config for the other options. It
does only that the option name
implies.
Someone has configured open objects to 1000, way way too low for a productio
n environment. I recommend you set
it back to auto, 0.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Dan Marth" <danmarth@.earthlink.net> wrote in message news:uMtja6nEEHA.1272@.TK2MSFTNGP12.ph
x.gbl...
> when I ran the USE master EXEC sp_configure 'show advanced option', '1' I
> was already set to 1. So I changed it back to '0' and hopefully auto conf
ig
> should work better. What do you think? Below are those settings you ask
> for:
> Server Memory
> Minimum 4
> Maximum: 2147483647
> Config_value: 2147483647
> Run_value: 2147483647
> Open Objects
> Minimum 0
> Maximum 2147483647
> Config_value 1000
> Run_value 1000
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23GEyj7eEEHA.1376@.TK2MSFTNGP10.phx.gbl...
> objects?
> news:uA4ZB5eEEHA.3016@.TK2MSFTNGP11.phx.gbl...
> meg).
> in
> the
> in
>|||How do you set it back to auto? Is the below values correct for auto?
open objects
Minimum: 0
Maximum: 2147483647
Config_Value: 0
Run_Value: 1000
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eZwjB%23nEEHA.3856@.TK2MSFTNGP12.phx.gbl...
> Show advanced options does not control auto-config for the other options.
It does only that the option name
> implies.
> Someone has configured open objects to 1000, way way too low for a
production environment. I recommend you set
> it back to auto, 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Dan Marth" <danmarth@.earthlink.net> wrote in message
news:uMtja6nEEHA.1272@.TK2MSFTNGP12.phx.gbl...
I
config
ask
in
(50
wrote
use
memory
>|||All parameters for sp_configure are documented in Books Online. For Open Obj
ects, 0 is auto config. After
setting this, you need to execute RECONFIGURE and for some parameters, you a
lso need to restart SQL Server
(check BOL if this is one of these). It seems you have already set it to 0,
but that value if not in effect
yes (run_value is 1000) so you either need to do RECONFIGURE or restart SQL
Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Dan Marth" <danmarth@.earthlink.net> wrote in message news:OTI17xzEEHA.3976@.TK2MSFTNGP12.ph
x.gbl...
> How do you set it back to auto? Is the below values correct for auto?
> open objects
> Minimum: 0
> Maximum: 2147483647
> Config_Value: 0
> Run_Value: 1000
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:eZwjB%23nEEHA.3856@.TK2MSFTNGP12.phx.gbl...
> It does only that the option name
> production environment. I recommend you set
> news:uMtja6nEEHA.1272@.TK2MSFTNGP12.phx.gbl...
> I
> config
> ask
> in
> (50
> wrote
> use
> memory
>|||Thanks for all the help! A reboot fixed it, all is working fine now!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23Lks540EEHA.3344@.tk2msftngp13.phx.gbl...
> All parameters for sp_configure are documented in Books Online. For Open
Objects, 0 is auto config. After
> setting this, you need to execute RECONFIGURE and for some parameters, you
also need to restart SQL Server
> (check BOL if this is one of these). It seems you have already set it to
0, but that value if not in effect
> yes (run_value is 1000) so you either need to do RECONFIGURE or restart
SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Dan Marth" <danmarth@.earthlink.net> wrote in message
news:OTI17xzEEHA.3976@.TK2MSFTNGP12.phx.gbl...
in
options.
'1'
auto
you
wrote
open
database
<tibor_please.no.email_karaszi@.hotmail.nomail.com>
will
message
>

Keep RS awake.

Any ideas as to how to keep Reporting Services awake? I have tried setting
up a simple report that gets the current time and then created a
subscription that runs ever 5 minutes, but it often still takes time to open
the home page.Here is a response from another poster:
"If you are running Windows 2003 server for your IIS reportserver, then this
is a simple issue - I'll explain what happens:The report service engine,
once it is idle for more than the default 20 minutes, the worker process is
shutdown.This is controlled by IIS.Open up the Internet Information Services
(IIS) Manager
Expand the server node then the application pools.On my IIS machine, I
created an application pool dedicated to the reportserver & reportmanager
virtual webs.
But anyways, for the application pool that the reportserver is pointing to
if you left everything to their defaults will be the DefaultAppPool.
Right click the default app pool and select properties.
There are two things that are checked by default - On the recycling tab
there is a checkbox for recycling worker processes - it is currently set to
1740 minutes (29 hours). Leave it.
The other one is on the performance tab - which is the one you are
interested in changing...
See the "Idle Timeout" section and increase the number of minutes to be 8
hours a typical working day - 8*60 = 480 minutes.
Next, to be sure the "morning person" that runs the first report doesn't get
the delay, set up a schedule for either a dummy or adhoc report to fire off
like at 6am so that the report component worker processes get loaded.
I hope this helps you.
There is no need to have a report fire off every minute to keep things
alive - it is just that the report service was "unloaded" and needed to load
back up.
=-Chris"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shawn" <shawn.camner@.ccci.org> wrote in message
news:e2WCz9ahHHA.392@.TK2MSFTNGP06.phx.gbl...
> Any ideas as to how to keep Reporting Services awake? I have tried setting
> up a simple report that gets the current time and then created a
> subscription that runs ever 5 minutes, but it often still takes time to
> open the home page.
>|||Thanks, I will give it a whirl...
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23GYWyNbhHHA.3960@.TK2MSFTNGP02.phx.gbl...
> Here is a response from another poster:
> "If you are running Windows 2003 server for your IIS reportserver, then
> this is a simple issue - I'll explain what happens:The report service
> engine, once it is idle for more than the default 20 minutes, the worker
> process is shutdown.This is controlled by IIS.Open up the Internet
> Information Services (IIS) Manager
> Expand the server node then the application pools.On my IIS machine, I
> created an application pool dedicated to the reportserver & reportmanager
> virtual webs.
> But anyways, for the application pool that the reportserver is pointing to
> if you left everything to their defaults will be the DefaultAppPool.
> Right click the default app pool and select properties.
> There are two things that are checked by default - On the recycling tab
> there is a checkbox for recycling worker processes - it is currently set
> to 1740 minutes (29 hours). Leave it.
> The other one is on the performance tab - which is the one you are
> interested in changing...
> See the "Idle Timeout" section and increase the number of minutes to be 8
> hours a typical working day - 8*60 = 480 minutes.
> Next, to be sure the "morning person" that runs the first report doesn't
> get the delay, set up a schedule for either a dummy or adhoc report to
> fire off like at 6am so that the report component worker processes get
> loaded.
> I hope this helps you.
> There is no need to have a report fire off every minute to keep things
> alive - it is just that the report service was "unloaded" and needed to
> load back up.
> =-Chris"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shawn" <shawn.camner@.ccci.org> wrote in message
> news:e2WCz9ahHHA.392@.TK2MSFTNGP06.phx.gbl...
>> Any ideas as to how to keep Reporting Services awake? I have tried
>> setting up a simple report that gets the current time and then created a
>> subscription that runs ever 5 minutes, but it often still takes time to
>> open the home page.
>

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

Keep a Group Together

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