Rename sheet when export to excel in SSRS 2008
-
Friday, January 25, 2013 12:54 AM
Hi All
Is there any way to rename sheet when export to excel in SSRS 2008.
regards
Srinivas
All Replies
-
Friday, January 25, 2013 2:00 AM
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
- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Thursday, January 31, 2013 1:08 AM
- Marked As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Thursday, January 31, 2013 1:42 AM
-
Monday, January 28, 2013 8:43 AMModerator
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 LiuFanny Liu
TechNet Community Support
- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Thursday, January 31, 2013 1:08 AM
- Marked As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Thursday, January 31, 2013 1:42 AM
-
Monday, January 28, 2013 11:39 AM
Hello,
See this link will help you sheet name ssrs 2008
blog:My Blog/
Hope this will help you !!!
Sanjeewan- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Thursday, January 31, 2013 1:08 AM
- Marked As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Thursday, January 31, 2013 1:42 AM
-
Monday, January 28, 2013 1:17 PM 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?- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Thursday, January 31, 2013 1:09 AM
- Marked As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Thursday, January 31, 2013 1:42 AM
.png)
