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
|
[quoted text, click to view] | "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
| > |
[quoted text, click to view] | > | "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