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

Embedding reports in other applications


What if you need to embed a report in your organization's website? How do we do? We have seen a common answer for this requirement; many save the output of the report as an image and add it to the website because it is the easiest way of embedding an output of a report to another application.

Reporting Services supports report embedding. It allows us to make the report as an embedded report without much effort. It only needs an additional tag to the URL and it works for both mobile and paginated reports. Once we have the URL, it can be used with another web page or applications using an iframe along with its parameters for showing the report with the same functionalities.

Reporting Services supports embedding reports into Power BI dashboards. This is called as Pinning to Power BI. This is really useful and it eliminates the necessity of creating the same outputs in Power BI dashboards, saving time and resources.

Getting ready

With the How to do it... section...