We're excited to announce that from 14th April we'll be running live online training courses too!
From 14th April we'll be running live online training courses too!
Business Intelligence training -  Advanced SSRS

SSRS Training

Advanced SSRS Training Course

£750 + VAT for most venues (£895 + VAT for London)

2 days

If you can already create reports using either Report Builder or Reporting Services, we'd like to show you what else SSRS can do! This two-day advanced course will show you how to create and use variables; why and how you should base your reports on views and stored procedures; and how to use bookmarks, document maps and dynamic reports.  If you're getting a group of people up to speed on SSRS from scratch, combining this and our two-day Introduction to SSRS course together makes for a nice three-day onsite course.

Course details

  • Locations for Advanced SSRS coursesLocations:Manchester
  • Next Advanced SSRS course locationNext course:Thu 16 July 2020
  • Advanced SSRS course timesTime:09.30-16.30

Course Contents

The content of this course are as follows:

Revision of grouping

  • Training topicCreating grouped tables
  • Training topicFixing page headers
  • Training topicCollapsing and expanding

Revision of expressions

  • Training topicCalculated fields
  • Training topicUsing the expression builder
  • Training topicConditional formatting

Advanced expressions

  • Training topicUnderstanding scope
  • Training topicUsing RowNumber
  • Training topicRunning totals


  • Training topicHow variables work
  • Training topicReport variables
  • Training topicGroup variables

Embedding code

  • Training topicSetting code for a report
  • Training topicCalling functions in expressions
  • Training topicBetter ways to write code

Using SQL views

  • Training topicWhy views are a good idea
  • Training topicDesigning views
  • Training topicScripting views
  • Training topicCreating virtual tables

Revision of parameters

  • Training topicConfiguring parameters
  • Training topicReferencing parameters
  • Training topicDealing with no rows
  • Training topicDefault and null values
  • Training topicDropdown parameters

Stored procedures in SSRS

  • Training topicPros and cons of stored procedures
  • Training topicServer Explorer vs SSMS
  • Training topicCreating and editing procedures
  • Training topicUsing for reports

Stored procedure parameters

  • Training topicCreating report parameters
  • Training topicRefreshing fields
  • Training topicDefault and null values

Dropdowns with procedures

  • Training topicThe stored procedures needed
  • Training topicCascading dropdowns
  • Training topicReplacing SELECT A VALUE

Multivalue parameter procedures

  • Training topicSplitting the choices made in SQL
  • Training topicDisplaying the chosen data
  • Training topicRestricting the number of choices

Improving report navigation

  • Training topicDocument maps
  • Training topicUsing bookmarks
  • Training topicSetting tooltips

Dynamic reports

  • Training topicDynamic datasets
  • Training topicDynamic grouping
  • Training topicDynamic matrices

The ideal preparation for this course is to attend our two-day Reporting Services course. We will accept other delegates, but you must have a good understanding of how to create reports in SSRS. Delegates must also know some SQL. This course is taught using SQL Server 2016, although the version isn't particularly important.

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"(Intro Power BI course) Excellent pace for 2 days. Plenty of interaction and humour. Great lunch breaks. (DAX course) Excellent course. Very well delivered on a "tricky" topic which could have sent me slightly mad. Great pace of delivery. This is the first time I felt I could do the same course again! (Advanced Power BI course) Excellent delivery of a new course. Quick measures were very useful after the DAX course (a good compliment)."

John Pelan (Coloplast Ltd)

"The trainer was very competent, knowledgeable and enthusiastic. Well done!"

Sandro Fasolo (Moorfields Eye Hospital NHS Foundation Trust)

"Excellent course, excellent trainer and excellent course manual."

Ilkka Laurmaa (Delta Motor Group)

"Nicely paced with great instructor. Also, worth mentioning that the tutor went the extra mile to help me with material at the end of each day. I had seen many of his videos online which I found immensely helpful and was really pleased to find he was just as great a teacher face-to-face."

Quentin Harris (NEL CSU (NHS))

"The course is brilliant. I now feel, after a long time tinkering with SSRS by myself that I am now on the right track, simply because of this course. The trainer is great at explaining the complexity of it in simple terms. I would happily recommend this course! The online courseware is excellent and really helped me understand my requirements to get the most out of this course."

Adil Zeshan (James Brindley School)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Advanced SSRS training dates

Here are the Advanced SSRS courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Thu/Fri 16-17 July 2020 2 £750 Book places
Thu/Fri 01-02 October 2020 2 £750 Book places
Thu/Fri 03-04 December 2020 2 £750 Book places
Date(s) Venue

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite SSRS training at your offices (we'll even provide and set up the computers).

Related Courses

Reporting Services


2 day course

Introduction to SQL


2 day course

Advanced SQL


2 day course

Other Reporting Services training resources

SSRS exercises

SSRS exercises

To help you decide whether you like the Wise Owl approach to classroom training, take a look at some of the Reporting Services exercises we've published online.

View SSRS 2016 exercises

SSRS videos

SSRS videos

We don't just do classroom training! There is a whole series of Reporting Services videos on the Wise Owl YouTube channel too.

View Reporting Services - Introduction, SSRS 2016, Report Builder 2016 or Reporting Services - Advanced videos

SSRS blogs

SSRS blogs

Exercises, videos and blogs on Reporting Services too, as you can see by following this link.

View SSRS blogs

This page has 0 threads Add post