Format RDLC report to export to an excel, group wise

• Bind data to a dataset.

• Use a matrix to present the data.

• If we want to export this report to an excel sheet wise by name, it can be done as follows.
• Right click on the "Name" in Row groups and select Group Properties.
• Mark the check box as follows.

• After exporting to an excel it will be like this.

• If we want to get the "Name" as sheet name, instead of Sheet1, Sheet2....it can be done with the following simple modification.
• First select the "Name" group in the Row Groups pane so that its properties are displayed in the Properties pane.  In the Properties pane, locate the Group > PageName property and specify the following expression:

[code] =Fields!Name.Value [/code]

• Result will be like this.

Where The Sheets Have A Name