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?
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
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
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?