SQL Server 2016 Reporting Services Cookbook
图书信息
| 作者 | Dinesh Priyankara |
| 出版社 | Packt Publishing |
| ISBN | 9781786467997 |
| 出版时间 | 2016-11-01 |
| 字数 | 180.2万 |
| 分类 | 进口书,外文原版书,电脑,网络 |
读书简介
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
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...
- 经济数学-微积分习题解答(安徽财经大学大学数学教学研究中心)
- 新手学Dreamweaver CS6+Flash CS6+Photoshop CS6网页设计(实例版)(全彩)(含DVD光盘1张)(鼎翰文化)
- 中华学生百科全书——控制论与自动化(读书堂)
- 不要在草台班子里拼命努力(HCJ)
- 第11集 趋势定位:如何从消费市场往创业市场和资本市场转型(此商品为视频课程)(周导)
- 侯大利刑侦笔记8:旧案寻踪(集侦查学、痕迹学、社会学、尸体解剖学、犯罪心理学的教科书式破案小说)(读客知识小说文库)(小桥老树)
- 交易圣经((澳)布伦特·奔富)
