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’s (“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