SSRS Tutorial Part 127- Export Report Items ( Tablix,Matrix,Chart) to Different Sheets in Excel with Names

In this video of SSRS Tutorial, we are going to learn How to export different Report Items such as Tablix, Chart and Matrix to different Sheets. We would also like to have uniqure name for each sheet instead of Sheet1,Sheet2 etc.

You will learn below items in this video

  1. How to Export all items on Single Sheets in Excel from SSRS
  2. How to introduce page break for each of the item ( tablix, Matrix and chart etc.) and export to Excel and see the ourput
  3. Set the PageName property for each items to rename Sheets as required and Export to Excel file to see the output


How to export different Report Items to Excel sheets with custom Names - SQL Server Reporting Services(SSRS) Tutorial