SQL Reporting Services SSRS

Discover how to create, format, and manage SQL Server Reporting Services (SSRS) reports by understanding different types of reports and how to use the Report Designer and Report Builder tools. 


No prior product knowledge needed.

Course length: 5 days, Delivery: Online or In-class. 
Please call (475) 328-2227 with questions.

Upcoming Classes

Course Overview

1   SSRS Overview and Tools 

  • Tools Available with SQL Server 2014

  • SQL Server Documentation

2   Working with Solutions and Projects 

  • Working with SSDT-BI for Visual Studio 2013

  • Understanding Solutions and Projects

  • Working with the Visual Studio Developer


3   Creating Basic Reports 

  • Data Sources

  • Datasets

  • Using the Report Wizard

  • Tablix

  • Creating a Tabular Report

  • Creating a List Report

  • Matrix

4    Formatting Reports 

  • Rich Text Formatting

  • Adding and Managing Text Boxes

  • Drawing Lines and Boxes

  • Images

  • Adding Page Headers and Footers

  • Using the Built-in Fields Folder

  • Adding a Document Map

  • Rendering Reports

5    Custom Expressions 

  • Understanding Expressions

  • Defining Expressions

  • Working with Report Variables

  • Accessing Multiple Datasets with Lookup Functions

  • Additional Samples

6    Summarizing and Sorting 

  • Adding Groups with the Report Wizard

  • Creating Groups

  • Parent/Child vs. Adjacent Groupings

  • Adding Totals and Aggregations

  • Creating Aggregates of Aggregates

7    Add Flexibility with Parameters 

  • Adding Parameters to a Report

  • Report Parameters vs. Query Parameters

  • Manage Report Parameter Properties

  • Use Parameters with SQL Queries and Stored Procedures

  • Work with Cascading Parameters

  • Sort Based on a Parameter Setting

  • Filtered Reports

8.    Enhanced Report Items 

  • Charts

  • Gauges

  • Add a Map to a Report

  • Data Bar, Indicator, and Sparkline Report Items

  • Nesting Data Regions

  • Working with Subreports

  • Working with Drillthrough Reports

  • Performance Implications of Subreports and Drillthrough Reports

9    Using Report Manager 

  • Deploying Projects

  • Navigating Report Manager

  • Understanding Permissions

  • Viewing Reports

  • Working with Shared Data Sources

  • Managing Reports

10    Using SQL Server 2014 Report Builder 

  • ClickOnce vs. Stand-alone Installations

  • Installing the Stand-alone Version

  • The Report Builder Tool Interface

  • Creating Shared Datasets with Report Builder

  • Adapt report creation to the Report Builder Application

  • Opening Existing Reports

  • Working with Report Parts

11    Business Intelligence and Data Modelling 

  • Introduction to Business Intelligence (BI)

  • The Microsoft Business Intelligence platform

  • Introduction to reporting services

  • Exploring an enterprise BI solution

12    Reporting Services Data 

  • Data connections

  • Connection strings

  • Filters and parameters

  • Configuring a data connection

13    Implementing Reports 

  • Creating a report with the report wizard

  • Creating a report

  • Showing data graphically

14    Creating a Map Report 

  • Implementing filters and parameters

  • Implementing sorting and grouping

  • Publishing a report

  • Creating a Map Report

15    Creating Mobile Reports 

  • Overview of SQL Server mobile reports

  • Preparing data for mobile reports

  • Mobile report publisher