How can i page my report by specific group?


  • hi,

    i am new to ssrs and i have a report that shows client performance with different measures, group by REGION.

    the user that uses this report needs to export it to excel, and cut & paste to different worksheets - each represent a different Region.

    can i perform in ssrs something that allows me to export this report to excel with the data divided in to Regions - each represented by a different sheet?


    Wednesday, March 06, 2013 1:08 PM


  • Hi,

    I guess you must have REGION field in Row Group. If not, create it

    So Just go to your table or matrix --> Right Click on REGION cell

    Select RowGroup --> Group Properties

    Go to Page Breaks --> Check "Between each instance of a group"

    Click 'OK'. Thats it :)

    Please Mark as Answer if my post solved your problem or Vote As Helpful if this helps. Blogs:

    • Proposed as answer by tom2163 Wednesday, March 06, 2013 2:30 PM
    • Marked as answer by nf75 Wednesday, March 06, 2013 3:14 PM
    Wednesday, March 06, 2013 1:29 PM