SQL Server Reporting Services allows us to export the opened report into different formats such as Excel and Word. When exporting into Excel, it is a common requirement that rows need to be organized in different Excel sheets based on added groups and it is something we always see in many forums. How it can be done with the designer?
It can be implemented using two properties related to group; BreakLocation and PageName. All we have to do is, set these two properties as per the requirement;
As you see, Matrix data region is formed with a dataset populated from AdventureWorksDW2014 and it is grouped by Category. If we need to get Excel sheets generated based on groups, properties have to be changed as shown.
Once changed and exported using Excel, sheets will be created just like below Excel;