当当云阅读 > 进口书 > 外文原版书 > 电脑/网络 > SQL Server 2016 Reporting Services Cookbook

| | 手机阅读

扫描下载当当云阅读App

SQL Server 2016 Reporting Services Cookbook电子书

售价：¥

11人正在读 | 0人评论

9.8

作者：Dinesh Priyankara

出版社：Packt Publishing

出版时间：2016-11-01

字数：180.2万

所属分类：进口书 > 外文原版书 > 电脑/网络

温馨提示：数字商品不支持退换货，不提供源文件，不支持导出打印

为你推荐

读书简介
目录
累计评论(0条)

读书简介
目录
累计评论(0条)

Create interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services About This Book Get up to speed with the newly-introduced enhancements and the more advanced query and reporting features Easily access your important data by creating visually appealing dashboards in the Power BI practical recipe Create cross-browser and cross-platform reports using SQL Server 2016 Reporting Services Who This Book Is For This book is for software professionals who develop and implement reporting solutions using Microsoft SQL Server. It is especially relevant for professionals who are software engineers, software architects, DW/BI engineers, and DW/BI architects who perform simple to complex report authoring implementations. This book is also suitable for those who develop software solutions that integrate reporting solutions and are keen to learn about Microsoft SQL Server 2016’s features and capabilities. 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 In Detail 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. Style and approach This comprehensive cookbook follows a problem-solution approach to help you overcome any obstacle when creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services. Each recipe focuses on a specific task and is written in a clear, solution-focused style.

目录展开

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...

累计评论(0条) 0个书友正在讨论这本书 发表评论

发表评论

发表评论，分享你的想法吧！

发表评论

买过这本书的人还买过

读了这本书的人还在读

支持设备

Mastering Python Regular Expressions ￥45.77

Félix López

￥45.77

Mastering Python ￥71.93

Rick van Hattem

￥71.93

Learning Python ￥90.46

Fabrizio Romano

￥90.46

Cybersecurity – Attack and Defense Strategies ￥73.02

Yuri Diogenes,Erdal Ozkaya

￥73.02

Beginning C++ Programming ￥90.46

Richard Grimes

￥90.46

Learning Python Application Development ￥80.65

Ninad Sathaye

￥80.65

Godot Engine Game Development Projects ￥73.02

Chris Bradfield

￥73.02

Deep Learning for Computer Vision ￥73.02

Rajalingappaa Shanmugamani

￥73.02

Selenium Essentials ￥54.49

Prashanth Sams

￥54.49

Hands-On Machine Learning for Cybersecurity ￥81.74

Soma Halder

￥81.74

更多同类图书 >