tricky page break with groupings

  • Hey folks!

    I'm pretty new to SSRS, using Reporting Services 2008.

    I've build a pretty lang report. It's just one tablix. But it uses many groups, partially nested 3 times.

    What I need now is a possibility for a pagebreak which is pending on the external group. BUT only if the pages is at the bottom.

    Explicit I do NOT want a pagebreak after every instance of that group - I know I can do that easily, but this would make the report to long.

    Let´s say that this is my data:

    Category Product Value

    A A1 1

    A A1 2

    B B1 3

    B B1 4

    B B1 5

    B B1 6

    C C1 7

    C C2 8

    C C3 9

    D D1 10

    D D2 11

    WITHOUT any special pages breaks, actually my report shows me this:

    Category Product Value

    A A1 1

    A A1 2

    B B1 3

    B B1 4

    B B1 5

    B B1 6

    C C1 7

    C C2 8

    ------------------ page break

    C C3 9

    D D1 10

    D D2 11

    So, the instance of category C is devided and shown on 2 pages.

    In this case I would like to have everything of instance C shown on the 2nd page, like this:

    Category Product Value

    A A1 1

    A A1 2

    B B1 3

    B B1 4

    B B1 5

    B B1 6

    ----------------- page break

    C C1 7

    C C2 8

    C C3 9

    D D1 10

    D D2 11

    And what you can see here, is that there is no page break between A and B, and no one between C and D.

    Well, i think using an example is a pretty nice idea and this shows my problem and needs.

    A page break only for the special case when an instance is shown on 2 pages.

    have a nice one,

    Sven

  • Can anybody help me with this, please?

  • Did you ever get this working? I'm trying for a similar thing with a report of mine too.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply