Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 74
  • Last Modified:

SQL Server 2005 Reporting Services: Change the worksheet name in Reporting Services 2005

Hello Folks,

I want to change the default worksheet name i.e. sheet1, sheet2….. to my custom sheet name e.g. customsheet1, customsheet2…… while exporting in reporting services 2005.
I found that it is not possible to give your worksheets a custom name in reporting service 2005.  If report has only one worksheet, it will be the name of the report.  If it is multiple sheets, it will be named like Sheet1, Sheet2... SheetN.  
There is no way to change this, but we certainly hope to add this feature in a future release.
That feature was added in the 2008 R2 release

I also find that it can be possible using office writer but I did not find any tutorial which defines the integration between reporting services and office writer

Could anyone assist me to solve this problem with alternate?

Best Regards,
Mohit Pandit
0
MohitPandit
Asked:
MohitPandit
  • 2
  • 2
2 Solutions
 
Rainer JeschorCommented:
Hi,
I have not done this before but I found an interesting article / blog entry which describes how to export the data as XML and using XSLT to reformat the result where you can now also set the worksheet names. The process is somehow complicated but at least it is an additional option:
http://spacefold.com/lisa/post/2007/10/03/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx

HTH
Rainer
0
 
MohitPanditAuthor Commented:
Yes, you are correct. It looks complex one.

Could you please provide alternate?

Best Regards
0
 
Rainer JeschorCommented:
Hi,
sorry, afaik this is only possible out-of-the-box with SSRS 2008 R2.
HTH
Rainer
0
 
MohitPanditAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now