Rename sheet when export to excel in SSRS 2008

Question

Hi All

Is there any way to rename sheet when export to excel in SSRS 2008.

regards

Srinivas

Answer 1

Hi Srinivas,

 

Please refer to the link below.

 

http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx

 

Hope this helps

Answer 2

Hi Srinivas,

"PageName" is a new feature that supported in SQL Server 2008 R2 and later version. We can use page breaks and page names to provide different names for each worksheet tab.
In order to meet your requirement, you can upgrade the Reporting Services instance to SQL Server 2008 R2 and refer to the article post above to rename the Excel sheet.

Regards,
Fanny Liu

---

Fanny Liu
TechNet Community Support

Answer 3

Hello,

See this link will help you sheet name ssrs 2008

http://spacefold.com/lisa/post/2007/10/03/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx

---

blog:My Blog/

Hope this will help you !!!
Sanjeewan

Answer 4

If you're running 2008 R2, I believe the following article should prove interesting: Where The Sheets Have A Name

---

MCITP SQL Server 2008 (DEV); MCTS SQL Server 2008 (BI, DEV & DBA)
Check out my articles at BI: Beer Intelligence?