Conditional PageBreak With Rectangles in a Report


If we are trying to insert a page break after a Rectangle based on a Conditional Expression, that does not work. 


Work around:


You need to next two rectangles inside one another. 


Apply the conditional (apply the conditional expression) formatting to the outside rectangle.  Then apply the page break to the inner 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.


This might be a single scenario, but we can apply it to many others reports where we wanted to Force a page break.

Comments (5)

  1. Shankar.C says:

    HI,

    Im having 3 groups in my report i need to set page break after every 20 rows . that 20 rows should include group headers and footers…. any idea…

    regds,

    Shankar.C

  2. The following expression, when placed in the group expression, assigns a number to each set of 20 rows.

    When a page break is defined for the group, this expression results in a page break every 20 rows.

    =CInt(Ceiling(RowNumber(Nothing)/20))

  3. Shankar.C says:

    Hi,

    Thanks for ur reply….. Ur idea works fine when im having single group…. when im having 3 groups it doesnt take group  headers and footers into account…. So it results in more than 20 lines in a page….

    any idea….

    regds,

    Shankar.C

  4. Great Solution says:

    Thanks,

    Helped me a lot.