Our training courses
AI - Articial Intelligence Azure C# Excel Microsoft 365 MySQL Power Apps Power Automate Power BI and DAX Python Report Builder SQL SQL Server VBA Macros

Other training resources
Tips and tricks Guides and tutorials Blogs Exercises YouTube tutorials YouTube shorts Test your skills Consultancy Courseware Self-paced courses Newsletters Publications

Our training venues
London Manchester Across the UK At your site Online

Why we are different
Hundreds of published reviews Small class sizes Outstanding courseware Online classroom (Almost) no cancellations Wise Owl trainers only Genuine integrity Invoices after training 30+ years of Wise Owl Our top 100 clients

Learning to create reports using Report Builder

Our two-day Introduction to Report Builder course shows you how to create reports.  Read on to get an idea of what you'll learn if you attend!

Report Builder is almost identical to SQL Server Reporting Services (SSRS), and given a free choice we'd probably recommend that you choose one of our SSRS courses instead.  However, to use SSRS you have to install Visual Studio, and we recognise that your IT Department may be unwilling to do this.

Tables

On the course you'll learn how to create tables of data like this: 

Table of data

You may even learn how to use more tasteful colours ...

Which when run produce output like this:

Table when run

It doesn't look much better in this view.

Grouping tables

The course will then show how to group rows:

Grouped table

Here we're showing the films made by each director.

Expressions

The course will show how to create expressions like this:

SWITCH expression

This expression will show for each film whether it was an Oscar winner, nominee or loser.

 

Adrian Lyne had mixed results in our database:

Oscar status results

One winner, one nominee and one loser.

Parameters

The course will show how to create dropdown parameters like this:

Dropdown parameter

You can choose to show all of the films for a given director, and winning more than a given number of Oscars.

 Indicators and Gauges

The course will show how to use indicators and gauges to give a visual representation of how big or small numbers are:

Film minutes indicator

Less is more: only short films get smiley faces!

Charts

You'll learn how to create charts - which hopefully interpret the data better than this one:

A Report Builder chart

A chart showing ... something.

 

Matrices

The course will cover how to create matrices like this one:

Matrix of run times

A matrix is like an Excel pivot table.

This is just a selection of the things that will be covered on the course - you can see the full course contents here.
This page has 0 threads Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...