Rename Sheet when report exported to excel
Home > IT Answers > SQL Server > Rename Sheet when report exported to excel
Rachi
5 pts.
0
Q:
Rename Sheet when report exported to excel
SSRS, SSRS reports, Exporting SSRS to Excel
hi,

When i export SSRS report to excel, each new page comes with new sheet. The sheet names are default names (sheet1, sheet2.. sheetn). Is there a way to rename these sheet names while exporting.

Thanks in Advance,
Rachitha.
ASKED: Nov 28 2008  6:55 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Suraj
45 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Hi Rachitha

It is not possible to do this with SSRS out of the box.

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4876ffe0-f0c0-413e-9890-0c85615b3edf/

But there is an work around by creating XSLT and attaching it to SSRS. Refer below link.

http://spacefold.com/lisa/post/2007/10/03/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx
Last Answered: Nov 23 2009  11:22 AM GMT by Suraj   45 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

IT Knowledge Exchange Community Update for 12/02/08 - ITKE Community Blog   0 pts.  |   Dec 2 2008  6:01PM GMT

[...] >> Renaming sheets when exporting SSRS to Excel [...]

 
0