Book Image

SQL Server 2014 with PowerShell v5 Cookbook

By : Donabel Santos
Book Image

SQL Server 2014 with PowerShell v5 Cookbook

By: Donabel Santos

Overview of this book

Table of Contents (21 chapters)
SQL Server 2014 with PowerShell v5 Cookbook
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

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

Lastly, pick a report you want to display using the ReportViewer object. Identify the full path, and replace the value of the $reportViewer.ServerReport.ReportPath variable in the script.

How to do it...

This list shows how we can display a...