Google+ Followers

Friday, June 19, 2015

Export SQL Server Reporting Services Report Data into Multiple Excel with Worksheets

Sometimes SQL Server Reporting Services users want to export SSRS reports into Excel with multiple sheets, but when the SSRS report data region (Tablix/Matrix) doesn't have any grouping then all the data will be exported into a single sheet. How can we export a SSRS report into Excel with multiple sheets?
In this tip we will first review the problem and then demonstrate the solution. To demonstrate, I will use theAdventureworksDW2008R2 sample database and SQL Server 2012 Reporting Service.
This tip assumes that you have previous real world work experience building a simple SSRS Report.

Read complete article here.

1 comment:

Keith Gibson said...

Thanks for this information good one..

Also Refer: OST to PST Converter