Book Image

SQL Server 2016 Reporting Services Cookbook

By : Dinesh Priyankara, Robert Cain
Book Image

SQL Server 2016 Reporting Services Cookbook

By: Dinesh Priyankara, Robert Cain

Overview of this book

Microsoft SQL Server 2016 Reporting Services comes with many new features. It offers different types of reporting such as Production, Ad-hoc, Dashboard, Mash-up, and Analytical. SQL Server 2016 also has a surfeit of new features including Mobile Reporting, and Power BI integration. This book contains recipes that explore the new and advanced features added to SQL Server 2016. The first few chapters cover recipes on configuring components and how to explore these new features. You’ll learn to build your own reporting solution with data tools and report builder, along with learning techniques to create visually appealing reports. This book also has recipes for enhanced mobile reporting solutions, accessing these solutions effectively, and delivering interactive business intelligence solutions. Towards the end of the book, you’ll get to grips with running reporting services in SharePoint integrated mode and be able to administer, monitor, and secure your reporting solution. This book covers about the new offerings of Microsoft SQL Server 2016 Reporting Services in comprehensive detail and uses examples of real-world problem-solving business scenarios.
Table of Contents (18 chapters)
SQL Server 2016 Reporting Services Cookbook
Credits
About the Authors
About the Reviewers
www.Packtpub.com
Preface

Configuring SharePoint for Reporting Services


In this opening recipe, we'll see how to configure SharePoint 2016 to host reports. You'll see how to create a Reporting Services SharePoint application, and set it up so when reports are uploaded to SharePoint they can be viewed right within it.

Getting ready

For this recipe, all you'll need is a SharePoint instance you can work with. Be aware you will need administrative access to the SharePoint site. If you have an Azure account, free or paid, you could set up a test instance of SharePoint and use it to follow the instructions in this chapter. Note the setup of such an Azure instance is outside the scope of this chapter. In this chapter, we assume you are using an on premises SharePoint installation.

How to do it...

  1. Open the SharePoint 2016 Central Administration web page.

  2. Click on Manage service applications under the Application Management area:

    Figure 9.01

  3. The Service Applications tab now appears at the top of the page. Click on the New menu...