Books & Videos

Table of Contents

Chapter: INSTALLATION AND SETUP

The Course Overview

03m 19s

Installing and Configuring SQL Server 2016 Developer Edition

06m 45s

Installing SQL Server Management Studio

02m 19s

Installing Visual Studio

02m 57s

Installing SQL Server 2016 Data Tools

04m 17s

Installing SQL Server Sample Databases

06m 10s

SQL Server 2016 Reporting Services Configuration Manager

03m 59s

Chapter: WIZARDING YOUR FIRST REPORT

Data Sources

04m 40s

Report Queries

02m 56s

Tabular Report Types and Their Configuration

03m 54s

Matrix Report Types and Their configuration

03m 22s

Deployment Location and Completing the Wizard

05m 51s

Chapter: FORMATTING A TABULAR REPORT

Adding a Column after the Wizard

04m 45s

Formatting Column Headers

03m 33s

Interactive Sorting

02m 25s

Adding Calculated Fields and Using Expressions

03m 14s

Formatting Cells

05m 6s

Viewing the Report on the Report Server

05m 19s

Formatting the Report for Printing

02m 51s

Chapter: ADDING HEADERS AND FOOTERS

Adding the Header and Footer

02m 46s

Using Built-in Fields

03m 6s

Adding Query-Defined Fields

02m 48s

Adding Images to the header

02m 54s

The Importance of Displaying Report Metadata on the Report

03m 13s

Chapter: CREATING A DRILL-DOWN REPORT

Queries Specialized for Drill- Down Reports

02m 45s

Creating the Drill- Down Report

04m 30s

Grouping in SSRS

02m 37s

Toggling the Display

02m 59s

Adding Summary Rows

04m 36s

Chapter: USING PARAMETERS IN A REPORT

Parameter Types

04m 11s

Available and Default Values

03m 31s

Filtering by the Parameter Value

02m 12s

Displaying Parameter Values Within the Report

05m 54s

Chapter: CREATING A DRILL-THROUGH REPORT

Creating a Child Report

03m 50s

Adding a Parameter to a Query

04m 5s

Configuring the Drill-Through Reporting Action

03m 55s

Deploying the Drill-Through Reports to the Report Server

03m 13s

Chapter: BAKING PIE AND BAR CHARTS

Queries Optimized for Pie Charts and Bar Charts

05m 57s

Creating the Pie Chart Report

02m 3s

Creating the Bar Chart Report

02m 27s

Formatting the Legends and Labels

05m 24s

Placing Two Subreports Onto One Report

03m 34s

Chapter: GAUGES, SPARKLINES, AND INDICATORS

Queries Optimized for Gauges, Sparklines, and Indicators

02m 31s

Creating a Report Containing a Gauge

06m 27s

Creating a Report Containing a Sparkline

04m 14s

Creating a Report Containing an Indicator

04m 31s

Creating a Dashboard

03m 42s

Chapter: ANALYTICAL MAPS

Queries Optimized for Analytical Maps

02m 58s

Creating a Point Map

04m 49s

Creating an Analytical Line Map

04m 46s

Creating a Bubble Map

05m 39s

Creating a Polygon Map

05m 48s

Chapter: THE REPORTING SERVICES WEB PORTAL

Web Portal Folder Structure

02m 38s

Deploying Reports to the Portal

04m 20s

Securing Reports on the Portal

04m 26s

Web Portal Functionality

07m 35s