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!

Answer 1

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