COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  Reporting Services

Classroom Training

Reporting Services (SSRS)

Classroom training course - online version also available

£695 + VAT for most venues (£850 + VAT for London)

2 days

If you're wondering whether you should be learning SQL Server Reporting Services, the answer is yes! SSRS (as it's often called) allows you to create impressive reports, including drill-through, indicators, gauges and lots of other whizzy features.  You can then publish these reports directly to your company's website in a number of different formats, or push them out to subscribers by email.

Course details

  • Locations for Reporting Services coursesPossible locations:London, Manchester, Online
  • Next Reporting Services course locationNext classroom course:Thu 01 October 2020
  • Reporting Services course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

Introduction to SSRS

  • Visual Studio and SSDT
  • Solutions and projects
  • The Visual Studio environment

Designing a Simple Report

  • Authoring a report
  • Using report items
  • Selecting and formatting report items
  • Number formats

Data sources and datasets

  • Shared data sources
  • Shared versus embedded datasets
  • Using Query Designer

Tables

  • Structure of a table
  • Formatting tables
  • Inserting rows
  • Interactive sorting
  • Repeating page headers

Grouping tables

  • Using the grouping panes
  • Row and column groups
  • Displaying subtotals
  • Outlining

Expressions

  • Calculated fields
  • The ReportItems collection
  • Using built-in fields
  • Conditional formatting - expressions

Pages and printing

  • Page headers and footers
  • Pagination between groups
  • Header and footer expressions

Parameters

  • Using query parameters
  • Creating drop lists
  • Multi-value drop lists
  • Formatting using parameters

Indicators

  • Creating indicators
  • Changing the symbols displayed
  • Stopping indicators stretching

Gauges

  • Creating and formatting gauges
  • Gauge panels
  • Pointers, scales and ranges

Matrices

  • Areas of a matrix
  • Sorting and grouping matrices
  • Creating and formatting subtotals

Charts

  • The areas of a chart
  • Creating charts
  • Formatting charts

Data bars and sparklines

  • Need for a grouped row
  • Creating data bars
  • Creating sparklines

Lists

  • Creating and formatting lists
  • Grouping using lists
  • Using rectangles in lists

Covered if time allows If time

Subreports

  • Creating a child report
  • Creating the main report
  • Creating and formatting subreports

Drill-through reports

  • Parent and child reports
  • Creating actions
  • Passing values to a child report

Covered if time allows If time

Maps

  • ESRI shapefiles / SQL spatial data
  • Linking to datasets
  • Map layers
  • Center points and point layers

Deploying reports

  • Setting the target server
  • Deploying an entire project
  • Deploying single reports

The SSRS web portal

  • Browsing to the web portal
  • Viewing reports
  • Managing reports

Covered if time allows If time

KPIs and mobile reports

  • Creating a KPI
  • Installing Mobile Report Publisher
  • Creating a mobile report

Covered if time allows If time

Subscriptions

  • How subscriptions work
  • Creating a new subscription
  • Managing subscriptions

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

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"I really enjoyed the course and learnt lots! The handbook, exercises and memory stick are great to take away. (SQL)The speed of the course was just right. (SSRS) A fab course - learnt lots, my brain feels a little bit blown though! The course manual will be really useful back at work."

Harriet Taylor (Macclesfield College)

"Really worth while course. Very glad I did it. Brilliant trainer, would recommend to anyone. Very knowledgeable and enthusiastic. Great feedback on your website. Great location and course choice/content. Very good value for money."

Duncan Barber (DBS Datamarketing Ltd)

"Great content, very informative, well structured. Manager recommended this course."

Holly Palmer (Derbyshire County Council)

"Very well delivered course with excellent guidance and manual. (Recommendation came from our ICT team.)"

Graham Rose (City of Lincoln Council)

"Course was great and informative."

Ian Spencer (CAS Behavioural Health / Cygnet Health)

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

Scheduled Reporting Services training dates

Here are the classroom Reporting Services courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Thu/Fri 01-02 October 2020 2 £850 Book places
Thu/Fri 08-09 October 2020 2 £695 Book places
Tue/Wed 17-18 November 2020 2 £850 Book places
Thu/Fri 26-27 November 2020 2 £695 Book places
Thu/Fri 03-04 December 2020 2 £850 Book places
Date(s) Venue
01/10
08/10
17/11
26/11
03/12

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

Introduction to SQL RECOMMENDED

Basic

2 day course

Advanced SQL

Advanced

2 day course

Advanced SSRS

Advanced

2 day course

Other 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 2016 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 - Introduction, SSRS 2016, Report Builder 2016 or Reporting Services - Advanced 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