Introduction

Master the full reporting lifecycle of designing, managing, and accessing reports in a Microsoft SQL Server.

This is a hands-on course. It includes plenty of time to experiment with what you are being taught and try things out for yourself.

By the time you finish, you’ll be comfortable working independently in SSRS.

✔ A complete SSRS course that covers all of MS SQL Reporting Services.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.

What Will I Learn?

This course is in three discrete parts.

Days 1 & 2

You will become familiar with SQL Server Reporting Services’ (“SSRS”) development tools and learn to use them to create and author reports. Initially these are simple but the course soon progresses to more complex reports.

You will also learn about the data regions used in report design, including tables, matrices, lists, and charts.

Interactive features such as drilldown and drill-through reports are also covered in this section, as are the implementation and use of report parameters.

Day 3

You build on the knowledge gained over the previous two days by covering advanced report design concepts such as using Analysis Services as a data source, making your reports more dynamic (eg. allowing users to interactively select groups for a matrix through parameters), alternating background colours for table rows, and other handy tips to enable developers to design truly professional reports.

Day 4

The last day of the course deals specifically with the role of the Report Server itself. Here, you will learn how to deploy reports to a Report Server, manage Report Server content, handle subscriptions, and control access to reports.

Am I Ready For This Course?

No prior knowledge of SSRS is required for this course.

Ideally, you should already be familiar with basic programming concepts, and understand the fundamentals of relational databases and data normalization.

Some prior working knowledge of SQL Server and the use of SQL Server Management Studio, is assumed. In addition you should additionally be familiar with the SQL query language, in particular, the SELECT statement used for retrieving data.

The Training Day

Our courses run from 9.30am to roughly 4.15pm with refreshments throughout the day and a break for a tasty, freshly prepared lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the best instructors on the planet.

Also, you’ll receive:

✔ A full-colour A4 manual covering everything in the course so that you can recap.
✔ A USB stick for the course exercises to let you practice more in your own time.
✔ A Certificate of Attendance.

Course details

Overview of Reporting Services
The Reporting Life Cycle
Reporting Services Architecture
Reporting Services Tools

Introduction to SQL Server Data Tools (SSDT)
Creating a Report Project
The Report Designer Environment
Table Reports
Grouping and Aggregating Data
Sorting Data
Using a Matrix
Using a List
Using Text Boxes, Lines, and Images
Formatting Reports
Page Breaks
Report Headers and Footers
Implementing Expressions
Using Variables

Controlling Layout with Rectangles
Interactive Sorting
Drill-Down Reports
Document Maps
Bookmarks

Using Parameters to Restrict Query Results
Using Parameters to Filter Report Data
Creating Dynamic Parameter Lists
Cascading Parameters
Displaying User Selected Parameters in a Report
Subreports
Drill-Through Reports

Working with Charts
Gauges
Indicators and KPIs
Data Bars
Spark Lines

Overview of Report Builder
Designing a Report in Report Builder
Implementing Report Parts

Using an Analysis Services Data Source
Implementing Maps with Spatial Data
Embedding Code in Reports
Implementing Custom Assemblies
Creating Templates
Using Parameters with a Stored Procedure
Dynamic Data Sources and Datasets
Dynamic Grouping
Hiding/Showing Columns
Adjacent Groups
Recursive Hierarchy Grouping
Alternating Background Colours
Compact Grouping Layout
Handling the Absence of Data in a Report
Other Report Design Tips and Tricks

Configuring Reporting Services
Deploying Reports
Introduction to the Report Manager
Executing Reports on Demand

Managing Report Server Content
Linked Reports
Managing Data Source Properties
Caching Reports
Report Snapshots
Report History
The My Reports Folder
Rendering Reports to Different Formats

Introduction to Report Subscriptions
Creating a Standard Subscription
Creating a Data-Driven Subscription
Managing Report Subscriptions

Securing Report Server Content
Implementing Data Security
Using URL Access to Display a Report

MS SQL Server Reporting Services (“SSRS”) Course

Introduction

What Will I Learn?

Am I Ready For This Course?

The Training Day

Course details

Dates & Prices