Reporting Services Issue:



Our team is having a problems with the functionality in Reporting Services that generates page breaks. The page breaks don't seem to function when you add conditional logic to the visibility property of a control.



Project Goal:



Some sections of our reports are not to be displayed based on certain user entered parameters. When these sections are hidden, the page breaks were still displaying and creating multiple blank pages.



Attempted Solutions:



In an effort to resolve this issue, conditional logic was added to the page break rectangles in order to display or not display along with the other controls. This is where the issue was first noticed. The page breaks quit displaying regardless of the conditional logic.



After that attempt, there was a subreport created with the only object being a page break rectangle in order to abstract the page break from the conditional logic. On the report the conditional logic was then added to the subreport item containing the page break. The same results were observed.



In addition to the above mentioned solution attempts, embedding all page objects in a rectangle, multiple rectangles containing a page break, and every toolbox object was tested. All attempted solutions had the same results. Also, although this seems to be an issue others must have encountered, there is little information about page break logic online.



Questions:



Has anyone observed this problem, and if so, is there a solution?

Hi,

Did you get any answer to this? I am facing this problem myself.

I am having the same exact problem that you are having. I am using a rectangle to set a conditional page break. Trying everyting I set a border color for my rectangle. When I run the report I see the rectangle. So my conditional statement is definately working. However it doesn't do the page break part.

If I take the conditional logic out, the rectangle does produce a page break.

What is really driving me crazy is that I have another report with conditional page breaks that appear to be working. I'm not sure if I got lucky or there is some setting that I have different.

Good luck with this one.

Dennis Branson

I searched all over the web and finally found the answer. I just applied it to my report and it worked perfectly.

You need to next two rectangles inside one another. Apply the conditional formatting to the outside rectangle. Then apply the page break to the inside rectangle.

You have now separated the conditional formatting from the page break.

Since the inside rectangle is only visible when the conditional statement is true, it only applies the page break when it is visible.

Pretty neat. Wish I could take credit for figuring this one out.

Dennis Branson

This is a great post. I was struggling with the same problem that's reported.

Thank you very much.

I was also having the same problem. Now, I got it solved with the help of ur post. thank u.



with regards,

So that's exactly what I tried before I hit the forums and it hasn't been working for me.

Any ideas? This is really frustrating.