Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services

Tags:

I know there's a bug with conditional visibility and page breaks with SQL 2005, but I wonder if anyone has come up with a work around.

I have a table that has a conditional visibility expression, and I need a page break at the end of the table.

  • If I set the PageBreakAtEnd property to true. It is ignored no matter what. Remove the visibility condition and it works.
  • If I place the table inside a rectangle with the conditional visibility on the table, and the page break on the table. Same result. The page break property is ignored.
  • If I set the rectangle with the PageBreakAtEnd property and the table with the visibility condition, then I still get a page break even when the table isn't shown.

Any other ideas on what to try? I'm almost at the point where I need a separate report rather than conditional visibility :(

Edit: @Josh: That has the same problems. If the second table has conditional visibility it doesn't work. If it doesn't have the visibility expression, then I get the page break all the time.

@Erick: I really wanted that to be the answer but unfortunately it doesn't work. When the visibility expression evaluates to hidden, there's a big gap where the rectangles would be (which I can live with), and when it evaluates to visible, the page breaks still don't work.


Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!