Is there any way to change the sheet names in excel export....................can anyone help me regarding this.......

Are you using SQL 2008R2? See the following post regarding how it can be achieved in R2. http://www.bidn.com/blogs/bretupdegraff/bidn-blog/234/new-features-of-ssrs-2008-r2-part-1-naming-excel-sheets-when-exporting-reports There is no direct support for this in prior versions. However workarounds exist using XSLT etc. See the following thread for links on how to do that http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/21d8b4c0-3e75-49d1-a94b-4b79e462aa4e/