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 parameters for drill-through reports


Just as with regular SSRS reports, it is possible to have one mobile report execute a second report, passing parameter values from the source to the target. However, the mechanism for passing parameters is radically different.

In traditional SSRS, you can select a specific value in the report body, and launch the target report with that value. This can be done with Mobile Reports, with the caveat that it should be mapped to a navigator in the target report. Typically it is easiest to map the navigators in the source to the navigators in the target, which is what we'll do with this recipe.

Getting ready

For this recipe, we'll create a new report for the target but will be using Report 06-02, as created in the previous recipe, as our source. Be sure you have it completed.

As in the previous recipe, we'll be brief for the items you've seen before. In addition, we'll leave a lot of the graphical clean-up such as titles up to you.

How to do it...

  1. Create...