Post reply

Page Breaks in SSRS based on column values

  • January 19, 2012 at 11:54 am

    #249851

    I have a report whose layout is as follows:

    http://i.imgur.com/9XRJh.png

    My requirement is that each Regions data should be shown on a new page in SSRS (HTML as well as PDF). In other words , there would be as many pages as many regions there are.

    How can I achieve this?

    Thanks!!

  • January 19, 2012 at 1:43 pm

    #1436160

    Create a Row Group, and in the properties of the Row Group (Page Break section) you will be able to check the option that will force a page break between each instance of the group.

    In your case, the Row Group will be created on Region.

  • January 19, 2012 at 1:45 pm

    #1436162

    From the snapshot what I can guess is, you are using 3 tables to display data for a region. Am I correct?

    Then you just need to club the 3 tables under a List, group the List based on the Region and force page break at the end from the List properties.

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

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