Book Image

SQL Server 2016 Database Reporting [Video]

By : Dallas Harold Snider
Book Image

SQL Server 2016 Database Reporting [Video]

By: Dallas Harold Snider

Overview of this book

With SQL Server 2016 Reporting Services, users are excited about being able to visualize their data in new, creative ways for use in presentations, analysis, and decision support—even on mobile devices. In this course, users will receive step-by-step instructions on how to create stunning, high-impact reports. The course starts with an introduction to the technologies employed. Next, users are shown how to create a basic report and then how to format it and add features (such as headers and footers) to make it more readable, impressive, and practical. The course teaches how to create drill-down and drill-through reports. Pie charts, gauges. and maps are next on the agenda and the course wraps up with lessons on how to assemble a dashboard on the SQL Server Reporting Services web portal. This course will empower you to overcome any obstacle while creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services.

Related Content you might be interested in

Current Title:

Small book image
SQL Server 2016 Database Reporting [Video]
Dallas Harold Snider
Feb, 2017 | 3 hours 45 minutes
No titles found
Table of Contents (11 chapters)
Free Chapter
1
Installation and setup
The Course Overview
Installing and Configuring SQL Server 2016 Developer Edition
Installing SQL Server Management Studio
Installing Visual Studio
Installing SQL Server 2016 Data Tools
Installing SQL Server Sample Databases
SQL Server 2016 Reporting Services Configuration Manager
2
Wizarding Your First Report
Data Sources
Report Queries
Tabular Report Types and Their Configuration
Matrix Report Types and Their configuration
Deployment Location and Completing the Wizard
3
Formatting a Tabular Report
Adding a Column after the Wizard
Formatting Column Headers
Interactive Sorting
Adding Calculated Fields and Using Expressions
Formatting Cells
Viewing the Report on the Report Server
Formatting the Report for Printing
4
Adding Headers and Footers
Adding the Header and Footer
Using Built-in Fields
Adding Query-Defined Fields
Adding Images to the header
The Importance of Displaying Report Metadata on the Report
5
Creating a Drill-Down Report
Queries Specialized for Drill- Down Reports
Creating the Drill- Down Report
Grouping in SSRS
Toggling the Display
Adding Summary Rows
6
Using Parameters in a Report
Parameter Types
Available and Default Values
Filtering by the Parameter Value
Displaying Parameter Values Within the Report
7
Creating a Drill-Through Report
Creating a Child Report
Adding a Parameter to a Query
Configuring the Drill-Through Reporting Action
Deploying the Drill-Through Reports to the Report Server
8
Baking Pie and Bar Charts
Queries Optimized for Pie Charts and Bar Charts
Creating the Pie Chart Report
Creating the Bar Chart Report
Formatting the Legends and Labels
Placing Two Subreports Onto One Report
9
Gauges, Sparklines, and Indicators
Queries Optimized for Gauges, Sparklines, and Indicators
Creating a Report Containing a Gauge
Creating a Report Containing a Sparkline
Creating a Report Containing an Indicator
Creating a Dashboard
10
Analytical Maps
Queries Optimized for Analytical Maps
Creating a Point Map
Creating an Analytical Line Map
Creating a Bubble Map
Creating a Polygon Map
11
The Reporting Services Web Portal
Web Portal Folder Structure
Deploying Reports to the Portal
Securing Reports on the Portal
Web Portal Functionality
Chapter 6
Using Parameters in a Report
Content Locked
Section 2
Available and Default Values
Setting available parameter values and default values reduces the likelihood of a user creating a report with unintended data. As report developers, building this robustness into the report is beneficial to the user and us. - Create a dataset with the list of parameter values to present to the user - Use the dataset's values as the available values in the Report Parameter Properties window. - Define a Default Value for the Report Parameter in the Report Parameter Properties window
Previous Section
End of Section 2
Next Section