SQL Server 2016 Database Reporting [Video]

SQL Server 2016 Database Reporting [Video]

Learning
Dr. Dallas Snider

Create impressive reports from your SQL Server data
$106.25
RRP $124.99
Preview in Mapt

Video Details

ISBN 139781787121249
Course Length3 hours 45 minutes

Video Description

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.

Style and Approach

This course is a practical, step-by-step approach based on the author's experience with SQL Server Reporting Services in the workplace. Each topic is covered comprehensively and accompanied by practical examples to help you master the topics.

Table of Contents

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
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
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
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
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
Using Parameters in a Report
Parameter Types
Available and Default Values
Filtering by the Parameter Value
Displaying Parameter Values Within the Report
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
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
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
Analytical Maps
Queries Optimized for Analytical Maps
Creating a Point Map
Creating an Analytical Line Map
Creating a Bubble Map
Creating a Polygon Map
The Reporting Services Web Portal
Web Portal Folder Structure
Deploying Reports to the Portal
Securing Reports on the Portal
Web Portal Functionality

What You Will Learn

  • Define a SQL Server Reporting Services data source in the Report Wizard
  • Add a new column and change the column headers in a report
  • Create new data fields for use in the report without changing the query or stored procedure
  • Write queries that are specialized for drill-down reports, and create the drill-down report object
  • Explore different parameter types in SQL Server Reporting Services
  • Configure the parent report to support drill-through actions
  • Write queries that are optimized for maps and add maps to your reports
  • Write queries to utilize gauges, spark lines, and indicators in a report
  • Deploy and secure reports on the web portal

Authors

Table of Contents

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
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
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
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
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
Using Parameters in a Report
Parameter Types
Available and Default Values
Filtering by the Parameter Value
Displaying Parameter Values Within the Report
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
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
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
Analytical Maps
Queries Optimized for Analytical Maps
Creating a Point Map
Creating an Analytical Line Map
Creating a Bubble Map
Creating a Polygon Map
The Reporting Services Web Portal
Web Portal Folder Structure
Deploying Reports to the Portal
Securing Reports on the Portal
Web Portal Functionality

Video Details

ISBN 139781787121249
Course Length3 hours 45 minutes
Read More

Read More Reviews

Recommended for You

Creating Reports with SQL Server 2012 Reporting Services [Video] Book Cover
Creating Reports with SQL Server 2012 Reporting Services [Video]
$ 72.25
SQL Database for Beginners [Video] Book Cover
SQL Database for Beginners [Video]
$ 85.00