O'Reilly logo

SQL Server 2012 with PowerShell V3 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 PDF

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

Getting ready

To perform this recipe, you must first download and install the ReportViewer control. The ReportViewer control allows SSRS reports to be displayed and viewed to a web or Windows form.

Note

See the Using ReportViewer to view your SSRS report recipe on how and where to download the ReportViewer control.

After installing the ReportViewer control, select a report that you wish to download into an Excel or PDF version.

In this recipe, we will download a report /Customers/Customer Contact Numbers into Excel and PDF. Alternatively, choose a report you wish to download and replace the $reportViewer.ServerReport.ReportPath variable. ...

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