EXceptional training for data analysts

SQL Server Reporting Services Training Course

Retrieve Your Corporate Data With SQL Server Reporting Services - And Gain A Competitive Advantage!

1 Apr London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

SQL Server Reporting Services training course (code: SSRSEXT)


This Microsoft SQL Server Reporting Services SSRS training course gets delegates to grips with a key part of the Microsoft BI stack, The course covers the discovery and preparation of data, the modelling of the data, and the presentation of the data in insightful and attractive reports and dashboards.

We spend two days looking at Reporting Services (SSRS) and other visualisation tools such as Power BI – when you return to the office, you will easily be able to create wonderful and informative reports and dashboards.

All the work you do is saved and you can take it with you for future reference.


Developers and analysts who need to design and build reports. Administrators who wish to deploy and manage reports. Some basic SQL skills would be an advantage.




SSRS Fundamentals


SSRS overview

Reporting Services
Report Server
Report Designer
Report Builder
Report Manager


Designing reports – fundamentals

Report Wizard in SSDT-BI (aka BIDS/Visual Studio)
SQL relational reports
Tablixes (tables and matrixes)
Previewing reports
Deploying reports to Report Manager


Designing reports – further techniques

Formatting (including dates and currency)
Using expressions
Conditional formatting (and green-band reporting)
Grouping and drilldown
Grand totals, subtotals, and running totals
Interactive sorting
Charts and gauges
Parameterized SQL reports
Exporting reports to Excel or PDF
Report templates with global parameters


Multiple reports

Drilldown versus drillthrough
Jump reports
Linked reports



Reporting Services Configuration Manager
Report caching
Report snapshots
Report subscriptions (emailing reports)
Security overview

  • Create BI Reports
  • Deploy BI Reports
  • Manage BI Reports
  • Maximize powerful, integrated SSRS capabilities
  • Optional days - SSRS more broadly and in more depth.
Receive the latest version of this course into your inbox


1st Apr 2019 - 2 days £995

see all dates


Show Discount for this course


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote

  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote

Get in touch
0800 028 6400

Excellent feedback, consistently !

►"great tips help reduce build times"
► "we got access to exclusive content"
► "Short course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"

Newsletter ! Get exclusive news about upcoming programs, technical insights & special offers