SQL Server 2014 with PowerShell v5 Cookbook

Using ReportViewer to view your SSRS report

This recipe shows how to display a report using the ReportViewer redistributable.

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 ReportViewer 2014 runtime is part of the SQL Server Data Tools (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.

You will also need to identify your SSRS 2014 Report Server URL. We will need to reference the ReportService2010 web service, and you can reference it using:

<ReportServer URL>/ReportService2010.asmx ...