Freigeben über

Conditional PageBreak With Rectangles in a Report

  • Artikel

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

  • Anonymous
    January 06, 2008
    PingBack from http://geeklectures.info/2008/01/06/conditional-pagebreak-with-rectangles-in-a-report/
  • Anonymous
    December 15, 2009
    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
  • Anonymous
    December 15, 2009
    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))
  • Anonymous
    December 16, 2009
    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
  • Anonymous
    November 23, 2014
    Thanks,Helped me a lot.