SQL Server 2016 Reporting Services Cookbook电子书

SQL Server 2016 Reporting Services Cookbook

SQL Server 2016 Reporting Services Cookbook

Credits

About the Authors

About the Reviewers

www.Packtpub.com

Why subscribe?

Preface

What this book covers

What you need for this book

Who this book is for

Sections

Getting ready

How to do it…

How it works…

There's more…

See also

Conventions

Reader feedback

Customer support

Downloading the example code

Downloading the color images of this book

Errata

Piracy

Questions

1. Getting It Ready – Configuring Reporting Services

Introduction

Selecting the edition

Getting ready

How to do it...

How it works...

See also

Installing Reporting Services with default configurations

Getting ready

How to do it...

How it works...

There's more...

See also

Installing Reporting Services-related tools

Getting ready

How to do it...

How it works...

There's more...

See also

Accessing Reporting Services Configuration Manager

Getting ready

How to do it...

How it works...

There's more...

See also

Configuring the service account of Reporting Services

Getting ready

How to do it...

How it works...

There's more...

Configuring Reporting Services URLs

Getting ready

How to do it...

How it works...

There's more...

Configuring the Reporting Services database

Getting ready

How to do it...

How it works...

There's more...

See also

Executing post-installation tasks

Getting ready

How to do it...

How it works...

There's more...

2. Authoring Reports with SQL Server Data Tools

Introduction

The designer tool - exploring SSDT

Getting ready

How to do it...

How it works...

Visual Studio 2015 support

Getting ready

How to do it...

How it works...

Creating reports with a table data region

Getting ready...

How to do it...

How it works...

There's more...

Creating reports with a matrix data region

Getting ready

How to do it...

How it works...

Creating reports with a chart data region

Getting ready

How to do it...

How it works...

There's more....

Managing and configuring parameters

Getting ready

How to do it...

How it works...

3. Advanced Report Authoring with SQL Server Data Tools

Introduction

Creating reports with multiple axis charts

Getting ready

How to do it...

How it works...

Creating reports with multiple data regions

Getting ready

How to do it...

How it works...

Creating reports with nested data regions

Getting ready

How to do it...

How it works...

Creating reports with a map data region

Getting ready

How to do it...

How it works...

Creating reports with cascading parameters

Getting ready

How to do it....

How it works...

Creating reports with dynamic datasets

Getting ready

How to do it...

How it works...

How to publish reports

Getting ready

How to do it...

How it works...

How to view the XML code related to reports

Getting ready

How to do it...

How it works...

4. Authoring Reports with Report Builder

Introduction

Is this for a developer or business user?

Getting ready...

How to do it...

How it works...

Enhancements to Report Builder

Getting ready...

How to do it...

How it works...

Connecting Report Builder to Reporting Services

Getting ready

How to do it...

How it works...

How to design reports with the wizard

Getting ready

How to do it...

How it works...

There's more...

How to design reports manually

Getting ready...

How to do it...

How it works...

Working with published data sources

Getting ready

How to do it...

How it works...

Working with published datasets

Getting ready

How to do it...

How it works...

How to publish reports to Reporting Services

Getting ready

How to do it...

How it works...

Working with published report parts

Getting ready

How to do it...

How it works...

Changing reports published in Reporting Services

Getting ready

How to do it...

How it works...

5. Improving User Experience – New Designing and Visualization Enhancements

Introduction

Positioning parameters

Getting ready

How to do it...

How it works...

Visualizing data with modern styles

Getting ready

How to do it...

How it works...

There's more...

Visualizing data with the TreeMap data region

Getting ready

How to do it...

How it works...

Visualizing data with the Sunburst data region

Getting ready

How to do it...

How it works...

There's more...

Integrating R with Reporting Services

Getting ready

How to do it...

How it works...

There's more...

See also

6. Authoring Reports with the Mobile Report Publisher

Introduction

Understanding the new Mobile Report Publisher

Getting ready

How to do it...

How it works...

How to create a mobile report

Getting ready

How to do it...

How it works...

Using simulated data

Getting ready

How to do it...

How it works...

Setting up data sources

Getting ready

How to do it....

How it works...

How to use datasets for mobile reporting

Getting ready

How to do it...

How it works...

Understanding mobile report graphical elements

Getting ready

How to do it...

How it works...

Understanding the mobile report layout

Getting ready

How to do it...

How it works...

Configuring navigators

Getting ready

How to do it...

How it works...

Configuring parameters for drill-through reports

Getting ready

How to do it...

How it works...

7. Consuming Reports – Report Access Enhancement

Introduction

Exploring the new Web Portal

Getting ready

How to do it...

How it works...

There's more...

Managing reports with the Web Portal

Getting ready

How to do it...

How it works...

There's more...

Viewing reports on any web browser

Getting ready

How to do it...

How it works...

There's more...

Caching the report

Getting ready

How to do it...

How it works...

There's more...

Refreshing the cache

Getting ready

How to do it...

How it works...

There's more...

Creating a KPI with predefined values

Getting ready

How to do it...

How it works...

There's more...

Creating a KPI with shared datasets

Getting ready

How to do it...

How it works...

There's more...

Customizing the look-and-feel of the Web Portal

Getting ready

How to do it...

How it works...

There's more...

Printing reports with the PDF rendering extension

Getting ready

How to do it...

How it works...

There's more...

Embedding reports in other applications

Getting ready

How to do it...

How it works...

There's more...

See also

8. Reporting Solutions for BI – Integration

Introduction

Making Reporting Services as a part of BI

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a report using Multidimensional models

Getting ready

How to do it...

How it works...

There's more...

Getting formatting from the Multidimensional model

Getting ready

How to do it...

How it works...

There's more...

Getting aggregated values from the Multidimensional model

Getting ready

How to do it...

How it works...

There's more...

Creating a report using Tabular models

Getting ready

How to do it...

How it works...

Connecting to the HDInsight cluster and getting unstructured data

Getting ready

How to do it...

How it works...

There's more...

See also

9. SharePoint Integration

Introduction

Configuring SharePoint for Reporting Services

Getting ready

How to do it...

How it works...

Handling security with SharePoint

Getting ready

How to do it...

Adding a user to your SharePoint site

Altering permissions to a document library

Altering permissions to a specific report item

Removing a user's permissions from a report

How it works...

There's more...

Creating dashboards using Reporting Services

Getting ready

How to do it...

How it works...

Configuring e-mail with SharePoint

Getting ready

How to do it...

How it works...

There's more...

Configuring subscriptions

Getting ready

How to do it...

How it works...

Configuring data alerts

Getting ready

How to do it...

How it works...

10. Administering and Managing Reporting Services

Introduction

Managing data sources

Getting ready

How to do it...

How it works...

There's more...

Assigning configured data sources to published reports

Getting ready

How to do it...

How it works...

There's more...

Caching reports

Getting ready

How to do it...

How it works...

There's more...

Creating snapshots of reports

Getting ready

How to do it...

How it works...

Backing up Reporting Services

Getting ready

How to do it...

How it works...

There's more...

Monitoring Reporting Services

Getting ready

How to do it...

How it works...

There's more...

11. Securing Reports in Reporting Services

Introduction

Authenticating users for Reporting Services

Getting ready

How to do it...

How it works...

Becoming a Report Portal System Administrator

Getting ready

How to do it...

How it works...

Authorizing users for accessing reports via SSRS roles

Getting ready

How to do it...

How it works...

There's more...

Creating new roles in Reporting Services

Getting ready

How to do it...

How it works...

Editing existing roles in Reporting Services

Getting ready

How to do it...

How it works...

Filtering data for the current user

Getting ready

How to do it...

How it works...

There's more...

Handling security on shared data sources

Getting ready

How to do it...

How it works...

There's more...

Securing the channel using certificates

Getting ready

How to do it...

How it works...

12. Custom Programming and Integration to .NET Applications

Introduction

Adding embedded codes to reports

Getting ready

How to do it...

How it works...

There's more...

Referencing external .NET assemblies

Getting ready

How to do it...

How it works...

Opening reports using URL access

Getting ready

How to do it...

How it works...

There's more...

Using ReportViewer control for accessing reports

Getting ready

How to do it...

How it works...

There's more...