Format RDLC report to export to an excel, group wise with expanded data

• Bind data to a dataset.
• Use a matrix to present the data.
• If you want expanded data within the group, the highlighted check box should be unchecked.

• If you want to export this report to an excel sheet wise by name, it can be done by changing page break options under Group Properties.

          Format RDLC report to export to an excel, group wise

Show report header on all work sheets

• Click that small drop down arrow at the right corner of column groups as below.

• Select the first static member under Row Groups, and set "KeepWithGroup" as After and "RepeatOnNewPage" as True.

• This will now copy the headers on all worksheets.

Reference: Generate Multiple Worksheets by Groups in SSRS Exported Excel Spreadsheets