SQL Server 2016 Database Reporting [Video]

SQL Server 2016 Database Reporting [Video]

Dr. Dallas Snider

1 customer reviews
Create impressive reports from your SQL Server data
Mapt Subscription
FREE
$29.99/m after trial
Video
$106.25
RRP $124.99
Save 14%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$106.25
$29.99p/m after trial
RRP $124.99
Subscription
Video
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
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
From 1 reviews

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]
$ 84.99
$ 72.25
SQL Server 2016 - Maintenance and Automation [Video] Book Cover
SQL Server 2016 - Maintenance and Automation [Video]
$ 124.99
$ 106.25
Getting Started with SQL Server 2016 Administration [Video] Book Cover
Getting Started with SQL Server 2016 Administration [Video]
$ 124.99
$ 106.25
SQL Server 2016 Reporting Services Cookbook Book Cover
SQL Server 2016 Reporting Services Cookbook
$ 43.99
$ 30.80
Tabular Modeling with SQL Server 2016 Analysis Services Cookbook Book Cover
Tabular Modeling with SQL Server 2016 Analysis Services Cookbook
$ 43.99
$ 30.80
MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition Book Cover
MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition
$ 43.99
$ 30.80