SQL Server Reporting Services for Developers and DBAs

Create pixel-perfect reports with tables, charts, and maps. Need to schedule them? No problems.

Course Summary

Learn to use SQL Server Reporting Services effectively

Dashboards are great but you need to create standard paginated reports

You want to show information effectively with tables, charts, gauges, and maps
You need to schedule reports to run automatically
You’d like to report from analytic data
You need to know how to use Report Designer and Report Builder
You want to learn to build reports properly, using professional standards = You’ve built reports in the past but not sure you’re doing it properly
You want to learn from an expert

If any of these apply to you, this course is for you! And as well as detailed instruction, the course also offers optional practical exercises and quizzes to reinforce your learning.

Enroll now for $295 USD !

Modules and Lessons

Module 0: Getting started

Who is this course for?
Who is Greg?
What will I learn in this course?
Configuring your lab environment

Module 1: Core concepts

The reporting challenge
Why SQL Server Reporting Services
Reporting Services components
Report Server
Report Manager
Report Manager Branding
Report Designer
RS Command Line Utility
Report Builder
Lab 1a: Core concepts - Installing Reporting Services or Power BI Report Server
Lab 1b: Core concepts - Installing SQL Server Data Tools
Lab 1c: Core concepts - Installing Report Builder

Module 2: Designing reports

Report Wizard
Report Definition Language (RDL)
Data Sources
Datasets
Reporting Services Toolbox
Tables
Text Boxes
Lines and Rectangles
Images
Deploying reports
Previewing and exporting reports
Creating report templates
Lab 2: Designing reports
Lab 2 Walkthrough
Quiz 2: Designing reports

Module 3: Common report elements

Tablix
Charts
Gauges
Other visualizations
Expressions
Collections
Lab 3: Common report elements
Lab 3 Walkthrough
Quiz 3: Common report elements

Module 4: Creating dynamic reports

Report parameters
Query parameters
Available values
Default values
Dynamic parameter values
Multi-valued parameters
Parameter-related expressions
Subreports
Drill-down reports
Report linking
Document maps
Interactive sorting
Lab 4: Creating dynamic reports
Lab 4 Walkthrough
Quiz 4: Creating dynamic reports

Module 5: Report security

Role based security model
Report Manager and UAC
Linked reports
Unattended execution account
Backup encryption key
Lab 5: Report security
Lab 5 Walkthrough
Quiz 5: Report security

Module 6: Report execution and subscriptions

Intermediate report format
Cached reports
Report snapshots
Report subscriptions
Standard subscriptions
Data-driven subscriptions
Data-driven subscriptions in Standard Edition
Lab 6: Report execution and subscriptions
Lab 6 Walkthrough
Quiz 6: Report execution and subscriptions

Module 7: End-user reporting with Report Builder

Why Report Builder?
Launching Report Builder
SQL Server spatial data concepts
Creating a map-based report
Lab 7: End-user reporting with Report Builder
Lab 7 Walkthrough
Quiz 7: End-user reporting with Report Builder

Module 8: Advanced reporting options

Embedding code
Referencing .NET assemblies
Reporting from Analysis Services
Sharing datasets
Sharing report parts
ATOM data feed concepts
Using a data feed as a data source
Quiz 8: Advanced reporting options

Module 9: Next steps

Summary and further steps

Enroll now for $295 USD !