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

Possible locations:London, Manchester, Online
Next classroom course:Wed 09 March 2022
Time:10.00-16.30

SCHEDULED DATES Course Contents - PDF

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?

No more than 5 people per class
Proper restaurant lunch included
543 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

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

"The course was absolutely spot on. It was delivered excellently and involved everything that was needed for a beginner to an advanced user. The remote setup worked great with no noticeable disadvantages. Great course and tutor. Keep up the good work."

Phil Memmott (Leeds Community Healthcare NHS Trust)

"I was really impressed with this course, the prep, the content, pace and the excellent trainer. The course materials are fantastic; book, exercises, data files and examples, all of which will be really easy to refer back to. The most well organised and presented course I have been on in years. Wise Owl have seriously got this together from the customer's perspective and thought of everything to make sure the attendee succeeds both during the course and afterwards. "

Glynis Caulfield (Cheshire East Council)

"We had a fantastic trainer, really knew her content and was an expert in Excel. As someone who is self taught in Excel having someone so knowledgeable, showing us the correct way to do things was fantastic."

John David (STMicroelectronics (R&D) Ltd)

"I was impressed with our trainer - his pace was just right and he was very good at guiding from one concept to another, in a logical way. I really enjoyed this course and can't wait to use my new skills in the real world. I really liked the concept of a Fasttrack course, where lots is covered in a relatively short time."

Magda Zarzycka (Emery Planning)

"I thought this was a really well run, well presented & useful course. Our trainer was excellent and clearly very knowledgeable. He managed to keep the course entertaining and maintained energy levels throughout the course which is very impressive given he was running the course remotely. I thought the pace of the course was good and requiring participants to continually work alongside the trainer really helped me concentrate and practice the SQL skills. Finally I was impressed by Wise Owl's organisation in ensuring that there were no IT issues by checking connections etc in advance. Thank you!"

Jen Steel (East of England Co-op)

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
Wed/Thu 09-10 March 2022	2	Manchester	£695	Book places

Date(s)	Venue
09/03	Manchester

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