all groups > sql server reporting services > december 2005 >
You're in the

sql server reporting services

group:

Newbie Question: Conditional rules based on pages breaks and the like


Newbie Question: Conditional rules based on pages breaks and the like Robert Hooker
12/13/2005 2:10:06 PM
sql server reporting services:
I suspect the answer is "yes - any modern reporting tool allows this" - but
I need to ask anyway, so please bear with me :-)

Given a report which contains 2 tables (or lists) - both of which have a
dynamic number of rows - as the creator of the report, do I have good
control over things like:
- Can I decide to "split" one of the tables across pages, if the first
table is long enough such that the 2nd wont completely fit of the same page?
- Can I alternatively, decide to insert a page break, so the 2nd list
prints 'whole', but on a 2nd page?

Rob.

Re: Newbie Question: Conditional rules based on pages breaks and the like Robert Hooker
12/14/2005 8:56:21 AM
I understand that I can make these changes in the designers...

But, can I make these changes in _code_, at the time the report is actually
generated? At the time I'm _designing_ the report, I don't know if both
tables will fit on the page.
If, at the time the report is actually generated (forthe given underlying
data) the 2nd table wont fit on the 1st page - can I dynamically decide if I
should insert a page break (so the 2nd table fits entirely on the 2nd page),
or split the 2nd table, so some of it appears on the first page...?


[quoted text, click to view]

RE: Newbie Question: Conditional rules based on pages breaks and the like petery NO[at]SPAM online.microsoft.com
12/14/2005 9:59:06 AM
Hello Robert,

Please see the inline comments:

- Can I decide to "split" one of the tables across pages, if the first
table is long enough such that the 2nd wont completely fit of the same page?

You could add a page break the following steps:

In Layout view, right click the table->Properties->General, and select
"Insert a page break before/after this table"


- Can I alternatively, decide to insert a page break, so the 2nd list
prints 'whole', but on a 2nd page?

You could do same to the list item.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

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.


--------------------
[quoted text, click to view]
Re: Newbie Question: Conditional rules based on pages breaks and the like petery NO[at]SPAM online.microsoft.com
12/15/2005 7:25:47 AM
Hello Robert,

Based on my scope, this feature is currently not supported in SRS 2000/2005
unless you implement your own render extension. However, I think it is a
good idea and you could click "send feedback" toolbar button in 2005 BOL to
send your feedback directly to product team.

Also, please rest assured that this has been routed to the proper channel.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

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.


--------------------
[quoted text, click to view]
AddThis Social Bookmark Button