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?