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

Classroom Training

Report Builder training course

Classroom training course - online version also available

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

2 days

Report Builder is almost identical to Reporting Services (the difference is that Report Builder allows you to create reports without having to download or learn Visual Studio). If you're not sure of the differences, speak to us and we can talk you through which application you should be using (or have a look here). 

This two-day course explains how to create reports in Report Builder 2016 (this is pretty much identical to Report Builder 3, so if you're using the older version you can still attend).  During the course you'll learn how to create tables, lists and matrices, format reports so that they look beautiful and add fancy devices like indicators and gauges.

Course details

  • Locations for Report Builder coursesPossible locations:London, Manchester, Online
  • Next Report Builder course locationNext classroom course:Tue 23 February 2021
  • Report Builder course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

Data sources and datasets

  • Data sources
  • Datasets
  • Using query designer

Tables

  • Creating tables
  • Interactive sorting
  • Floating headers

Grouping

  • Inserting groups
  • Group headers/footers
  • Displaying group totals
  • Expanding and collapsing

Expressions

  • The expression builder
  • The ReportItems collection
  • Built-in fields
  • Conditional formatting expressions

Page set-up

  • Page headers and footers
  • Page names and numbers

Exporting reports

  • The various report formats
  • Using RenderFormat.Name

Parameters

  • Creating parameters
  • Filtering using parameters
  • Drop list parameters
  • Coping with empty tables

Matrices

  • Row and column groups
  • Sorting and filtering matrices
  • Creating subtotals

Charts

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

Basic reports

  • Text boxes and images
  • Selecting report items
  • Formatting parts of a report

Covered if time allows If time

Miniature charts

  • Creating sparklines
  • Creating data bars

Graphical indicators

  • Creating and customising indicators
  • Linear and radial gauges

Lists

  • Page-per-record lists
  • Dashboard lists
  • Other list ideas

Covered if time allows If time

Subreports

  • Creating a child report
  • Creating the main report
  • Linking the two reports

Covered if time allows If time

Drill-through reports

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

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

There are no particular pre-requisites for this course, although a passing knowledge of how relational databases are formed will help. In particular, no knowledge of SQL is needed.

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).

"Very good - covers a lot of areas in detail but also efficiently."

Flora Mclean (Refuge)

"Great content, well delivered."

Damian Clegg (Cargill plc)

"Fantastic course, excellent content."

Niklas Eriksson (John Deere)

"Trainer and course are engaging. Comprehensive and informative."

Andrew King (NHS Digital)

"Large amount of useful content."

Morgan Howard (SCC DS (incl M2 Digital))

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

Scheduled Report Builder training dates

Here are the classroom Report Builder courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Tue/Wed 23-24 February 2021 2 £695 Book places
Tue/Wed 20-21 April 2021 2 £695 Book places
Thu/Fri 27-28 May 2021 2 £695 Book places
Thu/Fri 08-09 July 2021 2 £695 Book places
Date(s) Venue
23/02
20/04
27/05
08/07

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

Related Courses

Reporting Services RECOMMENDED

Introduction

2 day course

Advanced SSRS

Advanced

2 day course

Introduction to SQL

Introduction

2 day course

Other Report Builder training resources

Report Builder exercises

Report Builder exercises

We've put all of our exercises on Report Builder online, to allow you to inspect them before booking this two-day course.

View Report Builder or SSRS 2016 exercises

Report Builder videos

Report Builder videos

You can have a look at our Report Builder videos, to help you to learn how to create reports.

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

Report Builder blogs

Report Builder blogs

There are blogs on Report Builder here, which are always worth referring to in an emergency!

View SSRS blogs

This page has 0 threads Add post