title: Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
body: <p>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.</p>
  
  <p>I have a table that has a conditional visibility expression, and I need a page break at the end of the table.</p>
  
  <ul>
  <li>If I set the PageBreakAtEnd property to true. It is ignored no matter what. Remove the visibility condition and it works.</li>
  <li>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.</li>
  <li>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.</li>
  </ul>
  
  <p>Any other ideas on what to try? I'm almost at the point where I need a separate report rather than conditional visibility :(</p>
  
  <p><strong>Edit: @Josh:</strong> 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.</p>
  
  <p>@<strong>Erick:</strong> 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. </p>