sql server reporting services: Parameterizing page break in a group -- sql server reporting services

You're in the

sql server reporting services

group:

Parameterizing page break in a group

Alec Hardy
10/14/2005 11:50:05 AM

sql server reporting services:

We would like to have the Page Break for a group be based on a Yes/No
Parameter that would be a the parameter section of the report. In the
Grouping and sorting options where the "Page Break at End" check box is,
there is no way to enter an expression. Is there any way to do this without
writing code, and/or what would be the code that would make the Page Break

Re: Parameterizing page break in a group

Bob Fisher
10/17/2005 10:44:57 AM

I think this will work though I haven't tried it. Put a Rectangle in the
bottom of your group footer with PageBreakAtEnd set to true. Then set the
Rectangle.Hidden expression (under visiblility) to =not
cbool(Parameters!PageBreaks.Value) assuming you have a parameter called
PageBreaks.

[quoted text, click to view]

Re: Parameterizing page break in a group

Alec Hardy
10/26/2005 3:07:04 PM

Thanks Bob, we're going to look into it.

[quoted text, click to view]

Re: Parameterizing page break in a group

brianpmccullough
12/13/2005 3:09:02 PM

Can anyone verify if this worked?

I tried entering and expression that would evaluate to true or false in the
element, but it did not work:

<PageBreakAtEnd>=CBool(iif(Parameters!GroupBreak1.Value = "true", true,
false))<PageBreakAtEnd>

Thanks!!!!

-Brian

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn