by Dr. Dallas Snider | Released February 2017 | ISBN: 9781787121249

Create impressive reports from your SQL Server dataAbout This VideoUtilize graphical report elements in the SQL Server 2016 Reporting Services developer toolboxWrite SQL Server queries that are optimized for specific report typesLearn advanced concepts such as drill-through reports and analytical mapsIn DetailWith 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. Show and hide more Publisher resources Download Example Code

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