Introduction to SSRS

Part Of The On-Demand Courses


  • How to create complex reports
  • Key concepts of Reporting Services from basic reporting, parameters, deploying and scheduling
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

Introduction to SSRS is designed to help you understand all aspects of SQL Server Reporting Services (SSRS), the reporting tool of choice for SQL Server developers. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work, and to prepare you to build your own real-world applications using this SQL Server subsystem.


Click here for a downloadable PDF



Module 00 | Course Introduction
09m 06s total


Module 00A | Course Introduction
09m 06s


Module 01 | Introduction to Reporting Services
17m 01s total


Module 01A | Introduction to Reporting Services
17m 01s


Module 02 | Introduction to the Reporting Environment
33m 02s total


Module 02A | Introduction to the Reporting Environment
33m 02s


Module 03 | Building your First Report
25m 31s total


Module 03A | Building your First Report
25m 31s


Module 04 | Bringing Data into your Reports
45m 76s total


Module 04A | Building a Dataset
18m 02s


Module 04B | Dataset Storage
08m 32s


Module 04C | Previewing Data Options
19m 42s


Module 05 | Using Basic Toolbox Items
53m 38s total


Module 05A | Line, Textbox, Rectangle
31m 19s


Module 05B | Working with Images
22m 19s


Module 06 | Understanding the Table and Matrix
36m 94s total


Module 06A | Tables
18m 48s


Module 06B | Matrix
18m 46s


Module 07 | Building a Report with Parameters
50m 74s total


Module 07A | Working with Parameters
23m 07s


Module 07B | Working with Stored Procedures
10m 19s


Module 07C | Cascading Parameters
17m 48s


Module 08 | Making Reports Dynamic
58m 64s total


Module 08A | Introduction
24m 18s


Module 08B | Expressions
24m 06s


Module 08C | Date Expressions
10m 40s


Module 09 | Reporting on an Analysis Services Data Source
19m 15s total


Module 09A | Reporting on an Analysis Services Data Source
19m 15s


Module 10 | Visualizations for Dashboard Development
125m 83s total


Module 10A | Chart Visualizations
33m 41s


Module 10B | Map Visualizations
24m 10s


Module 10C | Databars and Sparklines
18m 47s


Module 10D | Other Visuals
18m 31s


Module 10E | Subreports and Drillthrough Reports
21m 09s


Module 10F | Indicators
10m 45s


Module 11 | Administration
18m 15s total


Module 11A | Administration
18m 15s


Module 12 | Report Delivery
19m 37s total


Module 12A | Report Delivery
19m 37s


Module 13 | Self-Service Reporting
25m 56s total


Module 13A | Self-Service Reporting
25m 56s



Training Content Manager
Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.


Click Here To Learn More About Mitchell And See Certifications And Reviews

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014 (Some features discussed are Enterprise/Developer edition only)
    • SQL Server Database Engine
    • SQL Server Reporting Services
    • SQL Server Analysis Services (Optional)
    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Follow this installation guide ( to ensure all items are installed correctly
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance

What to Know Before Class

This class assumes that you have no previous knowledge of SSRS. In some of the coding modules, it is useful (but not mandatory) that students have some basic Visual Basic experience. Attendees will also need to know how to run a query inside of SQL Server.


Amazing! I got this through my employer, but I might get it for personal use if I ever lose access. The classes are just that much better than anything on Udemy or Lynda.

Steve H.

Awesome class. One of the best I have taken.


Great trainings and organization.


Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required