title: How to get named excel sheets while exporting from SSRS
body: <p>Whenever a single page report is exported to excel, sheet in excel is named by the report name.
  If a report has multiple pages, the sheets are named as sheet1, sheet2,....
  Is there any way to specify sheet names in SSRS 2005 ?</p>
  
  <p>solution: 
  Found this after some googleing:
  <a href="http://spacefold.com/lisa/post/2007/10/03/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx" rel="noreferrer">Changing the Sheet names in SQL Server RS Excel: QnD XSLT</a></p>
  
  <p>Will try out and post an update if it works.</p>