SQL Server 2016 Reporting Services Cookbook

Create interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services

SQL Server 2016 Reporting Services Cookbook

Cookbook
Dinesh Priyankara, Robert C. Cain

Create interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services
$43.99
$54.99
RRP $43.99
RRP $54.99
eBook
Print + eBook

Instantly access this course right now and get the skills you need in 2017

With unlimited access to a constantly growing library of over 4,000 eBooks and Videos, a subscription to Mapt gives you everything you need to learn new skills. Cancel anytime.

Free Sample

Book Details

ISBN 139781786461810
Paperback596 pages

Book Description

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

Chapter 1: Getting It Ready – Configuring Reporting Services
Introduction
Selecting the edition
Installing Reporting Services with default configurations
Installing Reporting Services-related tools
Accessing Reporting Services Configuration Manager
Configuring the service account of Reporting Services
Configuring Reporting Services URLs
Configuring the Reporting Services database
Executing post-installation tasks
Chapter 2: Authoring Reports with SQL Server Data Tools
Introduction
The designer tool - exploring SSDT
Visual Studio 2015 support
Creating reports with a table data region
Creating reports with a matrix data region
Creating reports with a chart data region
Managing and configuring parameters
Chapter 3: Advanced Report Authoring with SQL Server Data Tools
Introduction
Creating reports with multiple axis charts
Creating reports with multiple data regions
Creating reports with nested data regions
Creating reports with a map data region
Creating reports with cascading parameters
Creating reports with dynamic datasets
How to publish reports
How to view the XML code related to reports
Chapter 4: Authoring Reports with Report Builder
Introduction
Is this for a developer or business user?
Enhancements to Report Builder
Connecting Report Builder to Reporting Services
How to design reports with the wizard
How to design reports manually
Working with published data sources
Working with published datasets
How to publish reports to Reporting Services
Working with published report parts
Changing reports published in Reporting Services
Chapter 5: Improving User Experience – New Designing and Visualization Enhancements
Introduction
Positioning parameters
Visualizing data with modern styles
Visualizing data with the TreeMap data region
Visualizing data with the Sunburst data region
Integrating R with Reporting Services
Chapter 6: Authoring Reports with the Mobile Report Publisher
Introduction
Understanding the new Mobile Report Publisher
How to create a mobile report
Using simulated data
Setting up data sources
How to use datasets for mobile reporting
Understanding mobile report graphical elements
Understanding the mobile report layout
Configuring navigators
Configuring parameters for drill-through reports
Chapter 7: Consuming Reports – Report Access Enhancement
Introduction
Exploring the new Web Portal
Managing reports with the Web Portal
Viewing reports on any web browser
Caching the report
Refreshing the cache
Creating a KPI with predefined values
Creating a KPI with shared datasets
Customizing the look-and-feel of the Web Portal
Printing reports with the PDF rendering extension
Embedding reports in other applications
Chapter 8: Reporting Solutions for BI – Integration
Introduction
Making Reporting Services as a part of BI
Creating a report using Multidimensional models
Getting formatting from the Multidimensional model
Getting aggregated values from the Multidimensional model
Creating a report using Tabular models
Connecting to the HDInsight cluster and getting unstructured data
Chapter 9: SharePoint Integration
Introduction
Configuring SharePoint for Reporting Services
Handling security with SharePoint
Creating dashboards using Reporting Services
Configuring e-mail with SharePoint
Configuring subscriptions
Configuring data alerts
Chapter 10: Administering and Managing Reporting Services
Introduction
Managing data sources
Assigning configured data sources to published reports
Caching reports
Creating snapshots of reports
Backing up Reporting Services
Monitoring Reporting Services
Chapter 11: Securing Reports in Reporting Services
Introduction
Authenticating users for Reporting Services
Becoming a Report Portal System Administrator
Authorizing users for accessing reports via SSRS roles
Creating new roles in Reporting Services
Editing existing roles in Reporting Services
Filtering data for the current user
Handling security on shared data sources
Securing the channel using certificates
Chapter 12: Custom Programming and Integration to .NET Applications
Introduction
Adding embedded codes to reports
Referencing external .NET assemblies
Opening reports using URL access
Using ReportViewer control for accessing reports

What You Will Learn

  • Key capabilities, architecture, and components of Reporting Services
  • New features that have been added to Reporting Services
  • Design the architecture for reporting solutions
  • Design the architecture for BI solutions
  • Implement reporting solutions using Reporting Services
  • Improve the performance, availability, and scalability of the reporting solution
  • Enhance reporting solutions with custom programming and improved security

Authors

Table of Contents

Chapter 1: Getting It Ready – Configuring Reporting Services
Introduction
Selecting the edition
Installing Reporting Services with default configurations
Installing Reporting Services-related tools
Accessing Reporting Services Configuration Manager
Configuring the service account of Reporting Services
Configuring Reporting Services URLs
Configuring the Reporting Services database
Executing post-installation tasks
Chapter 2: Authoring Reports with SQL Server Data Tools
Introduction
The designer tool - exploring SSDT
Visual Studio 2015 support
Creating reports with a table data region
Creating reports with a matrix data region
Creating reports with a chart data region
Managing and configuring parameters
Chapter 3: Advanced Report Authoring with SQL Server Data Tools
Introduction
Creating reports with multiple axis charts
Creating reports with multiple data regions
Creating reports with nested data regions
Creating reports with a map data region
Creating reports with cascading parameters
Creating reports with dynamic datasets
How to publish reports
How to view the XML code related to reports
Chapter 4: Authoring Reports with Report Builder
Introduction
Is this for a developer or business user?
Enhancements to Report Builder
Connecting Report Builder to Reporting Services
How to design reports with the wizard
How to design reports manually
Working with published data sources
Working with published datasets
How to publish reports to Reporting Services
Working with published report parts
Changing reports published in Reporting Services
Chapter 5: Improving User Experience – New Designing and Visualization Enhancements
Introduction
Positioning parameters
Visualizing data with modern styles
Visualizing data with the TreeMap data region
Visualizing data with the Sunburst data region
Integrating R with Reporting Services
Chapter 6: Authoring Reports with the Mobile Report Publisher
Introduction
Understanding the new Mobile Report Publisher
How to create a mobile report
Using simulated data
Setting up data sources
How to use datasets for mobile reporting
Understanding mobile report graphical elements
Understanding the mobile report layout
Configuring navigators
Configuring parameters for drill-through reports
Chapter 7: Consuming Reports – Report Access Enhancement
Introduction
Exploring the new Web Portal
Managing reports with the Web Portal
Viewing reports on any web browser
Caching the report
Refreshing the cache
Creating a KPI with predefined values
Creating a KPI with shared datasets
Customizing the look-and-feel of the Web Portal
Printing reports with the PDF rendering extension
Embedding reports in other applications
Chapter 8: Reporting Solutions for BI – Integration
Introduction
Making Reporting Services as a part of BI
Creating a report using Multidimensional models
Getting formatting from the Multidimensional model
Getting aggregated values from the Multidimensional model
Creating a report using Tabular models
Connecting to the HDInsight cluster and getting unstructured data
Chapter 9: SharePoint Integration
Introduction
Configuring SharePoint for Reporting Services
Handling security with SharePoint
Creating dashboards using Reporting Services
Configuring e-mail with SharePoint
Configuring subscriptions
Configuring data alerts
Chapter 10: Administering and Managing Reporting Services
Introduction
Managing data sources
Assigning configured data sources to published reports
Caching reports
Creating snapshots of reports
Backing up Reporting Services
Monitoring Reporting Services
Chapter 11: Securing Reports in Reporting Services
Introduction
Authenticating users for Reporting Services
Becoming a Report Portal System Administrator
Authorizing users for accessing reports via SSRS roles
Creating new roles in Reporting Services
Editing existing roles in Reporting Services
Filtering data for the current user
Handling security on shared data sources
Securing the channel using certificates
Chapter 12: Custom Programming and Integration to .NET Applications
Introduction
Adding embedded codes to reports
Referencing external .NET assemblies
Opening reports using URL access
Using ReportViewer control for accessing reports

Book Details

ISBN 139781786461810
Paperback596 pages
Read More

Read More Reviews

Recommended for You