locked
How to change the Sheet Name of Exported Excel sheet in RDLC RRS feed

  • Question

  • Hi,

    How to change the Sheet Name of Exported Excel sheet in RDLC.

    I have done the same RDL successfully.

    Thanks & Regards

    Poomani Sankaran

    Monday, April 18, 2016 9:17 AM

Answers

All replies

  • Hi Suresh,

    We cannot change the name of it in Reporting Services level. If you have to change it, we need to change it on EXCEL manually. If you have any concerns about this feature, you can submit a feedback athttp://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product.


    Please Dont forget to mark as answer and Helpful Post. It helps others to find relevant posts to the same question. Milan Das

    Monday, April 18, 2016 11:12 AM
  • Hi Suresh Sankaran,

    According to your description, you want to change the sheet name when exporting report to excel. Right?
    In SSRS, you can change Tablix Property “Page Name” to control sheet name in both RDL and RDLC.

    For more detail, you can refer to the article below:

    https://blogs.msdn.microsoft.com/robertbruckner/2010/05/16/report-design-naming-excel-worksheets/

    If you have any question, please feel free to ask.
    Thanks,
    Xi Jin.



    Tuesday, April 19, 2016 6:30 AM