<div>
Short answer: &nbsp;You don't.<br />
<br />
SSRS reports are intended to be printed on paper or .pdf with a single rendering, and not with real advanced logic beyond that rendering in exporting sets such as an Excel spreadsheet with multiple tabs. &nbsp;<br />
<br />
You CAN create an SSIS package that has multiple connections that are the same Excel spreadsheet/multiple named ranges, and export that way.
</div>


Short answer:  You don't.

SSRS reports are intended to be printed on paper or .pdf with a single rendering, and not with real advanced logic beyond that rendering in exporting sets such as an Excel spreadsheet with multiple tabs.  

You CAN create an SSIS package that has multiple connections that are the same Excel spreadsheet/multiple named ranges, and export that way.

2018-03-30_23-41-42.jpg

SSRSReportWithMultipleExcelTabExport.rdl

<div>
<div class="content wysiwyg-content">
How would I create a SSRS report that would automatically output and excel spreadsheet with multiple tabs?
</div>
</div>


How would I create a SSRS report that would automatically output and excel spreadsheet with multiple tabs?

output a SSRS report in excel with multiple tabls

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.