Hi, Im using SSRS for generating reports in multiple excel sheets. It is coming up fine but i want to rename the sheets when it is generated. Is this possible in SSRS. If possible then how to do? Thanks in advance, Bhaskar

Hi, Im using SSRS for generating reports in multiple excel sheets. It is coming up fine but i want to rename the sheets when it is generated. Is this possible in SSRS. If possible then how to do? Thanks in advance, Bhaskar I dont think it is possible , it comes out with Report Name . Rajkumar Yelugu

Hi Bashkar , I recon you can't do that is SSRS. by the way what version are you using at the moment???Dasari

im using SSRS 2008.

http://excelsheets.codeplex.com/ Take a look at thisPraxy

is there any way to achieve this without using excel object.

In SQL Server 2008 R2, this feature was made as an out of box offering. We need to set a property and the sheet names will automatically gets replaced with approriate names. You need to set the pagename property to get the appropriate name associated with the sheet name. Phani Note: Please mark the post as answered if it answers your question.

Hi, I have a report in SSRS 2005 and on exporting to excel, multiple worksheets are created. How to rename worksheets? SSRS 2005 do not have property "Page name" for Table as in SSRS 2008. What property does this functionality? Or how can we write custom code to achieve this? Thanks, Umamahesh

This feature was added in Report Builder 3.0. http://technet.microsoft.com/en-us/library/dd255234.aspx#WorksheetTabNames http://technet.microsoft.com/en-us/library/dd255278.aspx "To provide the sheet name, you set the PageName property of a table, matrix, list, group, or rectangle." "Use the InitialPage property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the PageName property to provide different names for each worksheet. Each new report page, defined by a page break, is exported to a different worksheet named by the value of the PageName property."