Report Builder Training

Report Builder (2 days)

£625 + VAT for most venues (£750 + VAT for London)

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: creating tables, lists and matrices, formatting reports so that they look beautiful and adding fancy devices like indicators and gauges!

There is no difference that we know of between Report Builder 3.0 and Report Builder for SQL Server 2012 (this course teaches either - or both).

Course details

Locations:Manchester, London
Next course:Tue 24 October 2017
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

Report Models

Data source views
Creating a model
Entities, attributes and roles

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

Report parts

Publishing report parts
The report part gallery
Updating report parts

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
482 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

"Excellent manual, great venue, delivered at just the right level. Thanks for lunch."

Jill Eldon (Health and Social Care Information Centre)

"I did very much enjoy the course. The pace was good and there was plenty of opportunity to ask questions. I was slightly worried beforehand that I may be in the minority and there would be many things that I wouldn’t understand, but the group meant that this wasn’t a problem. I now need to have time to practice what I’ve learnt! Lunch in a restaurant was good too, it made a good break in the day to clear the mind for the afternoon session. Many thanks for all your help. I will certainly bear you in mind for any further training we may need. "

Ginny Lefebvre (Aiglon College)

"Course was brilliant and very helpful trainer. Was very friendly and knowledgeable. Thank you."

Marcio Franco (Royal Borough of Kensington & Chelsea)

"Will be back - probably for SQL."

Chris Bell (BSI Group)

"Really great course - vvv helpful!"

Kayleigh Ougham (Imperial College London)

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

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.