This forum is same as my post: I have SSRS 2008 R2 Visual Studio 2008 R2 project. My Report has matrix on it. Matrix has row group by Month-Year & PostedDate and Column Group by : Country, State and City. In Column group property on Page Breaks tab, I selected Between each instance of a group. But when I export report to excel file, it does not create seperate excel spreadsheet tab for each column group by. Output of my matrix looks like: Australia New South Wales Queensland Tasmania Sydney New Castle Wollongong Brisbane Gold Coast Hobart May-2011 01-May-2011 15 12 45 10 15 45 02-May-2011 18 56 89 15 28 68 ...... ...... I follow below below links but no help: http://msdn.microsoft.com/en-us/library/ms156434.aspx http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/ea9d795b-8d17-41d2-a1d7-a4069ebb4539 Any idea how to add page break in matrix column group by to export in individual spreadsheet tab by Country? so for each country colmun group will be created in new spreadsheet tab ? Thanks.

Hi, Sorry for delayed response. As the FAQ you referred, one possible workaround is to nest the Matrix in a List. Please follow the steps below: 1. Add a List control and place it below the existing matrix. 2. Select the List by clicking its handle at top-left corner. In the Properties pane, specify the DataSetName property to the same dataset of the matrix. 3. Right click the (Details) group in the Row Groups pane and select Group Properties… 4. Click the Add button, and select the [Country] field in the Group on dropdown list. 5. Select the Page Breaks in the left list, and the check Between each instance of a group. 6. Click OK. 7. Drag and drop the matrix in to the new List. After that, each instance of the Country group will be displayed in separate page. If anything is unclear, please feel free to ask. Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.