Conditional Page Break in SRSS Reports

one of the cases that I faced recently is having conditional page break in SRSS report. this is not an out of the box feature in SRSS and I had to do a workaround in order to accomplish this feature. To do so, I followed these steps:

  1. Add a rectangle to your report
  2. Right click on the rectangle and select “rectangle properties “
  3. Check the checkbox related to “Add a page break after” or “Add a page break before”; depending on the location of the rectangle and where the page break is intended to be.
  4. The tricky point is to set a visibility condition that control when the rectangle. The point is if the rectangle is invisible; then there will be no page break.