Report Builder Training
Report Builder training course
£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.
We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking - or you could consider an onsite Report Builder training course.
Course Contents
The content 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
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
If time
Subreports
- Creating a child report
- Creating the main report
- Linking the two reports
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
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 6 people per class- Proper restaurant lunch included
- 515 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Vanessa Murray (NHS Digital)
Andrew King (NHS Digital)
Julie Clements (Liverpool Mutual Homes)
Niklas Eriksson (John Deere)
Elaine Wrath (Lincolnshire County Council)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Related Courses
Other Report Builder training resources
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
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
There are blogs on Report Builder here, which are always worth referring to in an emergency!
View SSRS blogs