My SSRS Nuggets

Click on the Group in Row Groups, expand the Group in the Properties window, set the PageName property which becomes the Sheet Name.

https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/exporting-to-microsoft-excel-report-builder-and-ssrs?view=sql-server-ver16  

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/nested-data-regions-report-builder-and-ssrs  

  https://learn.microsoft.com/en-us/sql/reporting-services/report-design/exploring-the-flexibility-of-a-tablix-data-region-report-builder-and-ssrs

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/controlling-the-tablix-data-region-display-on-a-report-page  

  https://learn.microsoft.com/en-us/sql/reporting-services/report-design/create-invoices-and-forms-with-lists-report-builder-and-ssrs

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/tables-matrices-and-lists-report-builder-and-ssrs