Two column report page break issue

Hey folks,

I have a 2 column report that is not page breaking the way I would like. The report has a list that is grouped by a "Type" field. The header includes this type, though I had to use an aggregate of the report field like:

=Max(ReportItems!PlanType.value) & " Contacts"

I want a brand new page when the type changes, but since RS treats columns like pages, if my type ends in the first column, the new type begins in the second column. Is there any way to force it to leave that column blank and start a brand new page



Answer this question

Two column report page break issue

  • Pete_M

    I had an idea, but I can't get it to work. Could anybody help with this idea...

    I added an empty List to the bottom inside my original List. Both the original list and the new list have Page Break at End=True, but I don't always want a double page break, I only want it if my PlanType ends in the first column. So I figured I could hide the new list if I'm in the second column. But how do I determine if I'm in the second column I thought of using Globals!TotalPages.value to determine if it's odd or even, but I'm only allowed to use that variable in the header and footer.

    Does anyone know if there is a way

    Thanks.


  • CTA

    Ok :-)

    Thank you very much for answering.

  • Syed Murad Ali

    It's been a while, so it's hard to remember, but I don't think I ever resolved this.


  • hbjcr

    Hi

    Did you ever found a solution to your problem
    I got the same now http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=2720324&SiteID=17



  • Two column report page break issue