This recipe shows you how to download an SSRS report in Excel and PDF format.
In previous versions of SSRS, the
ReportViewer redistributable was a separate download and this needed to be installed on your machine prior to following this recipe. As of SSRS 2014, the Report Viewer 2014 runtime is part of the SSDT-BI installation. At the time of writing, SSDT-BI for SQL Server 2014 and Visual Studio 2013 can be found at https://msdn.microsoft.com/en-us/library/mt204009.aspx.
After installing the
ReportViewer control, select a report that you wish to download as an Excel or PDF version.
This recipe demonstrates how to download a report published to a local Report Server and export it to Excel ...