SSRS 2005 RDLC Report exporting to excel, how to change sheet name as report name ?

Question

Hi, I am exporting the SSRS 2005 RDLC report to Excel using Winforms. In excel export i need to change the sheet names to the report name. I found another thread which suggests adding PageName property to achieve the Tab Name as Report Name in Excel Export. But PageName property is not available in SSRS 2005. How to achieve this in SSRS 2005?

Answer 1

SSRS 2005 is no longer supported. So you aren't going to get much help on this. You should upgrade to a supported SSRS version such as 2014 or higher. You will then have the feature you are looking for.

Prior to SQL 2008 there doesn't appear to be a way to do that directly. You would need to open the generated Excel file and make the changes programmatically.

Answer 2

Hi @WPF2Web ,
Unfortunately it's not possible to name worksheet tabs in SSRS 2005. That feature was added in the 2008 R2 release. Depending on how criticial it is, you could post-process the excel documents using VSTO, however you would need to create a custom application to do that (either a custom rendering extension or application that proxies a call to report server web service render() method.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.