O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server 2016 Database Reporting

Video Description

Create impressive reports from your SQL Server data

About This Video

  • Utilize graphical report elements in the SQL Server 2016 Reporting Services developer toolbox

  • Write SQL Server queries that are optimized for specific report types

  • Learn advanced concepts such as drill-through reports and analytical maps

  • In Detail

    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.

    Table of Contents

    1. Chapter 1 : Installation and setup
      1. The Course Overview 00:03:19
      2. Installing and Configuring SQL Server 2016 Developer Edition 00:06:45
      3. Installing SQL Server Management Studio 00:02:19
      4. Installing Visual Studio 00:02:58
      5. Installing SQL Server 2016 Data Tools 00:04:17
      6. Installing SQL Server Sample Databases 00:06:10
      7. SQL Server 2016 Reporting Services Configuration Manager 00:04:00
    2. Chapter 2 : Wizarding Your First Report
      1. Data Sources 00:04:40
      2. Report Queries 00:02:57
      3. Tabular Report Types and Their Configuration 00:03:55
      4. Matrix Report Types and Their configuration 00:03:22
      5. Deployment Location and Completing the Wizard 00:05:52
    3. Chapter 3 : Formatting a Tabular Report
      1. Adding a Column after the Wizard 00:04:46
      2. Formatting Column Headers 00:03:33
      3. Interactive Sorting 00:02:25
      4. Adding Calculated Fields and Using Expressions 00:03:15
      5. Formatting Cells 00:05:06
      6. Viewing the Report on the Report Server 00:05:19
      7. Formatting the Report for Printing 00:02:52
    4. Chapter 4 : Adding Headers and Footers
      1. Adding the Header and Footer 00:02:46
      2. Using Built-in Fields 00:03:06
      3. Adding Query-Defined Fields 00:02:48
      4. Adding Images to the header 00:02:54
      5. The Importance of Displaying Report Metadata on the Report 00:03:14
    5. Chapter 5 : Creating a Drill-Down Report
      1. Queries Specialized for Drill- Down Reports 00:02:46
      2. Creating the Drill- Down Report 00:04:31
      3. Grouping in SSRS 00:02:38
      4. Toggling the Display 00:02:59
      5. Adding Summary Rows 00:04:37
    6. Chapter 6 : Using Parameters in a Report
      1. Parameter Types 00:04:12
      2. Available and Default Values 00:03:32
      3. Filtering by the Parameter Value 00:02:13
      4. Displaying Parameter Values Within the Report 00:05:54
    7. Chapter 7 : Creating a Drill-Through Report
      1. Creating a Child Report 00:03:51
      2. Adding a Parameter to a Query 00:04:06
      3. Configuring the Drill-Through Reporting Action 00:03:55
      4. Deploying the Drill-Through Reports to the Report Server 00:03:13
    8. Chapter 8 : Baking Pie and Bar Charts
      1. Queries Optimized for Pie Charts and Bar Charts 00:05:57
      2. Creating the Pie Chart Report 00:02:04
      3. Creating the Bar Chart Report 00:02:28
      4. Formatting the Legends and Labels 00:05:25
      5. Placing Two Subreports Onto One Report 00:03:34
    9. Chapter 9 : Gauges, Sparklines, and Indicators
      1. Queries Optimized for Gauges, Sparklines, and Indicators 00:02:31
      2. Creating a Report Containing a Gauge 00:06:27
      3. Creating a Report Containing a Sparkline 00:04:15
      4. Creating a Report Containing an Indicator 00:04:31
      5. Creating a Dashboard 00:03:43
    10. Chapter 10 : Analytical Maps
      1. Queries Optimized for Analytical Maps 00:02:58
      2. Creating a Point Map 00:04:49
      3. Creating an Analytical Line Map 00:04:46
      4. Creating a Bubble Map 00:05:40
      5. Creating a Polygon Map 00:05:48
    11. Chapter 11 : The Reporting Services Web Portal
      1. Web Portal Folder Structure 00:02:38
      2. Deploying Reports to the Portal 00:04:21
      3. Securing Reports on the Portal 00:04:27
      4. Web Portal Functionality 00:07:35