O'Reilly logo

SQL Server 2014 with PowerShell v5 Cookbook by Donabel Santos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Downloading an SSRS report in Excel and as a PDF

This recipe shows you how to download an SSRS report in Excel and PDF format.

Getting ready

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required