none
How can i page my report by specific group?

    Question

  • 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?

    thanks!

    Wednesday, March 06, 2013 1:08 PM

Answers

  • 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: www.sqlserver2005forum.blogspot.com

    • 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