Tuesday, September 18, 2018

SSRS – How to give Name to sheet(s) while exporting report to excel


When we export the SSRS report to excel, SSRS export report with its default sheet name e.g Sheet1, Sheet2. Below is the example.
SSRS Report

When we export the same report into excel. It will export in Sheet1 by default.
Exported Excel Report

Steps to give Name to the Sheet(s)
      1)      Go to the property of the tablix by selecting the tablix & press F4 button
      2)      You can see the Page Name property, Give the name that you would to display for sheet(s) while exporting to excel

3)      Now Export the report. You can see the Name of the Page given by you.

This implementation is helpful when you export multiple sheet(s) report. It is helpful in identifying the correct report easily.

--------------------------End of Article-------------------

2 comments:

  1. India Wide Many State Education Boards and the CBSE Schools Recommend and follow these Textbook 2023’s Syllabus 2023. The Content that CBSE books Provide is what most of the Exam Paper 2023s in the CBSE Curriculum are Based on. Students our Website lot of options available for lot of Books and we here are Trying to Provide you with one page that Serves CBSE class 6 students with free downloadable. CBSE 6th Class Textbook 2023 All the chapters of CBSE Class 6th Textbook 2023s 2023 are Available for Download. With this Article, Students can Download the Complete Pdf of all Subject English, Hindi, Mathematics, Sanskrit, Science, Social Science, Urdu Chapters Wise. CBSE Exemplar Class 6 Book 2023 are very important for CBSE class 6 Examination 2023. Our Website Providing 100% Download options Pdf format.

    ReplyDelete
  2. Thanks for the effort to publish this... worked great.

    ReplyDelete