Learning SQL Server 2016 Reporting Services [Video]

Access cutting-edge content as it's created

Want to access this video course right now? Watch as we develop it as part of our Alpha program.

Learning SQL Server 2016 Reporting Services [Video]

Learning
Dallas Snider

Your guide to creating intuitive, cross-platform reports with SQL Server 2016 Reporting Services

Access cutting-edge content as it's created

Want to access this video course right now? Watch as we develop it as part of our Alpha program.

$89.25
RRP $104.99

Instantly access this course right now and get the skills you need in 2016

With unlimited access to a constantly growing library of over 3,500 courses, a subscription to Mapt gives you everything you need to get that next promotion or to land that dream job. Cancel anytime.

Code Files
+ Collection

Video Details

ISBN 139781787121249
Course Length4.5 hours

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.

This video is your one-stop guide to creating effective reporting solutions using the Reporting Services feature of SQL Server 2016. Get introduced to the revamped as well as the new features in Reporting Services, and implement them to create interactive reports. You’ll build interactive analytical maps with enhanced graphics using gauges and indicators. You will also learn how to create reports using analysis services as a data source. Finally, you’ll cap off the course by learning how to design and deploy reports exclusively for mobile applications.

By the end of this comprehensive tutorial, you will have all the knowledge you need to create visually-appealing reporting solutions and visualize your data in new ways.

Style and Approach

This course will empower you to overcome any obstacle while creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services. There is a comprehensive coverage of each topic accompanied by practical examples to help you better understand the topics.

Table of Contents

Installation and setup
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

What You Will Learn

  • Format a tabular report
  • Create a drill-down and drill-through report
  • See how to create analytical maps and use the Reporting Services Web Portal
  • Generate pie charts using MDX
  • Use Analysis Services and the Database Engine as sources
  • Design a mobile report

Authors

Table of Contents

Installation and setup
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

Video Details

ISBN 139781787121249
Course Length4.5 hours
Read More

Read More Reviews