<div>
I am not 100% certain, but I wonder if you can implement OPENROWSET in your SSRS export. &nbsp;Something like this:<br />
<br />
SELECT * FROM OPENROWSET('Microsoft.Jet.<wbr />OLEDB.4.0'<wbr />, 'Excel 8.0;Database=C:\Directory\<wbr />ExcelFileN<wbr />ame.xls', 'SELECT * FROM [Sheet1$]')
</div>


<div>
I didn't test it but it looks like you can get multiple sheets by setting page breaks after a table. So this might work with subreports also. Search Google on:<br />
&quot;In SSRS, After Export into excel how to give Sheet name&quot;<br />
(including the quotes). This describes how to get multiple sheets, but also tells you the sheets are always named 'sheet 1', 'sheet 2'. But the article is rather old so maybe this was fixed.<br />
<br />
You can find a completely different and much more complex technique when you search Google for:<br />
&quot;Changing the Sheet names in SQL Server RS Excel: QnD XSLT&quot;<br />
This technique uses an XSLT to create an XML that represents an Excel workbook. A lot of work but very powerful.
</div>


<div>
You might try this...<br />
At the start and end of each sub-report &nbsp;make a rectrangle and place a page break inside it.<br />
This should force a regular page break at that point.
</div>


<div>
In tablix &nbsp;properties under &quot;Page name&quot; you can provide name of the sheet..<br />
<br />
Check this tutorial ., it will help you sure<br />
<br />
<a href="http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx" rel="ugc">http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx</a><br />
<br />
<a href="http://cipherdyn.wordpress.com/2013/06/11/excel-sheets-exported-from-ssrs-can-have-custom-name/" rel="ugc">http://cipherdyn.wordpress.com/2013/06/11/excel-sheets-exported-from-ssrs-can-have-custom-name/</a><br />
<br />
<a href="http://www.bidn.com/blogs/bretupdegraff/bidn-blog/234/new-features-of-ssrs-2008-r2-part-1-naming-excel-sheets-when-exporting-reports" rel="ugc">http://www.bidn.com/blogs/bretupdegraff/bidn-blog/234/new-features-of-ssrs-2008-r2-part-1-naming-excel-sheets-when-exporting-reports</a>
</div>


<div>
Can you provide a working solution , which you have tried yourself , i have searched these links on google , myself , and they are not working for me .<br />
<br />
I request to provide a solution which you have tried with yourself ,i search google links and after that i post my question here. :)
</div>


ExcelExport.rdl

<div>
<div class="content wysiwyg-content">
how can i export data from a report into multiple sheets , and also give each sheet the name i want <br />
<br />
consider a case where i have a SSRS report, and now i want it to export data to Excel sheet such that , one Sub report of the report goes to one sheet of the SSRS , and another Sub report goes to another sheet and also it takes the name of subreport as the name of Excel sheet it goes to.<br />
<br />
I am using SSRS 2008 R2
</div>
</div>


how can i export data from a report into multiple sheets , and also give each sheet the name i want 

consider a case where i have a SSRS report, and now i want it to export data to Excel sheet such that , one Sub report of the report goes to one sheet of the SSRS , and another Sub report goes to another sheet and also it takes the name of subreport as the name of Excel sheet it goes to.

I am using SSRS 2008 R2

SSRS 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.