Report Builder 3.0 training course (2 days)

Report Builder 3.0 allows you to create reports directly from the Intranet for your company, without having to load any additional software (think of it as a cut-down version of SQL Server Reporting Services - in practice there are precious few differences between the two). This two-day Report Builder 3.0 course explains what a report model is, then shows you how to create reports in all their glory, including using tables, matrices (a bit like pivot tables), charts, indicators, gauges and more!

Click here to show prices, dates and venues for this course

Report Builder 3.0 training - Course Contents

The contents of our Report Builder 3.0 course are as follows (any items marked with a * will be covered if time allows):

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

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

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

Click on any link above to show free exercises for the topic in question. 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. There will be a maximum of 6 people on each course, and each person will have their own computer.

Report Builder 3.0 training course (2 days)

Report Builder 3.0 training - Course Contents

Top menu

Microsoft Office

SQL Server training

.NET / SharePoint

Training venues

SITE MAP

Microsoft Office training and consultancy

SQL Server training and consultancy

.NET and SharePoint training

Computer training venues