SQL Server training -  Reporting Services

SSRS Training

Reporting Services (2 days)

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

If you're wondering whether you should be learning SQL Server Reporting Services, the answer is yes! This increasingly popular product will allow you to create impressive reports and then publish them directly to your company's website. This two-day course explains how!

Course details

  • Locations for Reporting Services coursesLocations:London, Manchester
  • Next Reporting Services course locationNext course:Thu 10 November 2016
  • Reporting Services course timesTime:09.30-16.30

Course Contents

Introduction to SSRS

  • Training topicBIDS and Report Manager
  • Training topicSolutions and projects
  • Training topicThe 4 main Visual Studio windows

Designing a Simple Report

  • Training topicAuthoring a report
  • Training topicUsing report items
  • Training topicSelecting and formatting report items
  • Training topicNumber formats

Data sources and datasets

  • Training topicShared data sources
  • Training topicShared versus embedded datasets
  • Training topicUsing Query Designer


  • Training topicStructure of a table
  • Training topicFormatting tables
  • Training topicInserting rows
  • Training topicInteractive sorting
  • Training topicRepeating page headers

Grouping tables

  • Training topicUsing the grouping panes
  • Training topicRow and column groups
  • Training topicDisplaying subtotals
  • Training topicOutlining


  • Training topicCalculated fields
  • Training topicThe ReportItems collection
  • Training topicUsing built-in fields
  • Training topicConditional formatting using expressions

Pages and printing

  • Training topicPage headers and footers
  • Training topicPagination between groups
  • Training topicHeader and footer expressions


  • Training topicUsing query parameters
  • Training topicCreating drop lists
  • Training topicMulti-value drop lists
  • Training topicFormatting using parameters


  • Training topicCreating indicators
  • Training topicChanging the symbols displayed
  • Training topicStopping indicators stretching


  • Training topicCreating and formatting gauges
  • Training topicGauge panels
  • Training topicPointers, scales and ranges


  • Training topicAreas of a matrix
  • Training topicSorting and grouping matrices
  • Training topicCreating and formatting subtotals


  • Training topicThe areas of a chart
  • Training topicCreating charts
  • Training topicFormatting charts

Data bars and sparklines

  • Training topicNeed for a grouped row
  • Training topicCreating data bars
  • Training topicCreating sparklines


  • Training topicCreating and formatting lists
  • Training topicGrouping using lists
  • Training topicUsing rectangles in lists

Covered if time allows If time


  • Training topicCreating a child report
  • Training topicCreating the main report
  • Training topicCreating and formatting subreports

Deploying to Report Manager

  • Training topicChoosing a target folder
  • Training topicWays to deploy reports

Using Report Manager

  • Training topicUsing Report Manager
  • Training topicCreating folders
  • Training topicMoving and deleting reports


  • Training topicHow subscriptions work
  • Training topicCreating a new subscription
  • Training topicManaging subscriptions

Covered if time allows If time


  • Training topicESRI shapefiles / SQL spatial data
  • Training topicLinking to datasets
  • Training topicMap layers
  • Training topicCenter points and point layers

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Very well structured course, and run at a very good, attentive pace. Will definitely be booking a follow up course in future (Intro to SQL). Very well structured course, well adapted to the needs and abilities of the delegates (SSRS)."

Gary McIsaac (Live Nation (Music) UK Limited)

"Excellent courses which covered everything I wanted to learn and then some. The exercises challenging and interesting. The subject data is a very good idea and appeals to users from any background. This will be my last course for now – I’ve got used to the Minshull Street site! I can’t recommend the courses enough, great site, great trainers, great content. Hopefully my colleagues will be coming to you in the future."

David Bell-Hartley (UHSM NHS Foundation Trust)

"Great manual. Extremely helpful and informative tutor. I had attended the basic course, which was very good and so decided to attend the advanced course."

Marvin Perrott (Imperial College Healthcare NHS Trust)

"Perfect pace and flexibility."

Steven Esdale (Long Road Sixth Form College)

"Useful and well paced. Good that only 2 delegates on this session, so more personal support - good for me! Clear handouts - nice pen and lunch too!"

Frank Vyvyan (Guy's and St. Thomas' NHS Foundation Trust)

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

You do not need any prior knowledge of SQL to attend this course (although you should have an understanding of tables and databases).

Related Courses

Introduction to SQL RECOMMENDED


2 day course

Advanced SQL


2 day course

Advanced SSRS


2 day course

Other SQL Server Reporting Services training resources

SSRS exercises

SSRS exercises

Lest you not be sure if this is the right course for you, we've published all of our Reporting Services exercises online.

View SSRS 2008 R2 or Report Builder 3.0 exercises

SSRS videos

SSRS videos

Look at our range of videos on SSRS, which provide and alternative way of learning to classroom training.

View Reporting Services videos

SSRS blogs

SSRS blogs

There are lots of good blogs on Reporting Services, which you can inspect at your leisure.

View SSRS blogs

This page has 0 threads Add post