SQL Server 2016 Database Reporting [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.

SQL Server 2016 Database Reporting [Video]

Learning
Dallas Snider

Create impressive reports from your SQL Server data

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 2017

With unlimited access to a constantly growing library of over 4,000 eBooks and Videos, a subscription to Mapt gives you everything you need to learn new skills. Cancel anytime.

Code Files

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.

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.

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 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
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

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
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

Video Details

ISBN 139781787121249
Course Length4.5 hours
Read More

Read More Reviews