Free Report Builder exercises
You are welcome to try any of the 42 Report Builder exercises listed below, but please do not distribute them in any form without asking for our written permission first.
| Software: |
Report Builder |
| Topic: |
Basic reports |
| Level: |
Relatively easy |
| Exercise: |
Create a simple report with 3 images and a couple of text boxes. |
| Software: |
Report Builder |
| Topic: |
Tables |
| Level: |
Relatively easy |
| Exercise: |
Create a simple table which gives the name, birth date and gender of each film director, and apply interactive sorting. |
| Software: |
Report Builder |
| Topic: |
Tables |
| Level: |
Relatively easy |
| Exercise: |
Use a cube as the basis for a simple table report, with sorting. |
| Software: |
Report Builder |
| Topic: |
Tables |
| Level: |
Average difficulty |
| Exercise: |
Create a report giving a table of films winning more than 10 nominations, in nomination order. |
| Software: |
Report Builder |
| Topic: |
Tables |
| Level: |
Average difficulty |
| Exercise: |
Use a cube to create a table, with filters and a subtotal. |
| Software: |
Report Builder |
| Topic: |
Tables |
| Level: |
Harder than average |
| Exercise: |
Create a table of films for directors whose names start with E, with sorting, interactive sorting and subtotals. |
| Software: |
Report Builder |
| Topic: |
Tables |
| Level: |
Harder than average |
| Exercise: |
Use a cube for a report with a table inside a rectangle. |
| Software: |
Report Builder |
| Topic: |
Grouping |
| Level: |
Average difficulty |
| Exercise: |
Create a report based on a cube, with grouping levels / toggle items. |
| Software: |
Report Builder |
| Topic: |
Grouping |
| Level: |
Average difficulty |
| Exercise: |
Create a table listing films by country, and toggle display of films using the ToggleItem property. |
| Software: |
Report Builder |
| Topic: |
Grouping |
| Level: |
Harder than average |
| Exercise: |
Create a grouped table of characters by director and then by actor gender, with subtotals and filtering. |
| Software: |
Report Builder |
| Topic: |
Grouping |
| Level: |
Harder than average |
| Exercise: |
Use a cube to create a table with 2groups and expand/collapse symbols. |
| Software: |
Report Builder |
| Topic: |
Expressions |
| Level: |
Relatively easy |
| Exercise: |
Create a report on a cube, with a header, footer and expression. |
| Software: |
Report Builder |
| Topic: |
Expressions |
| Level: |
Relatively easy |
| Exercise: |
Create a table with a page header and footer, and including a simple calculated field. |
| Software: |
Report Builder |
| Topic: |
Expressions |
| Level: |
Average difficulty |
| Exercise: |
Use ReportItems to calculate the age of an actor when a film was made. |
| Software: |
Report Builder |
| Topic: |
Expressions |
| Level: |
Average difficulty |
| Exercise: |
Use the SWITCH function and format expressions in a report of a cube. |
| Software: |
Report Builder |
| Topic: |
Expressions |
| Level: |
Harder than average |
| Exercise: |
Amend a report so that it has an alternating row colour and flashing background, using expressions. |
| Software: |
Report Builder |
| Topic: |
Exporting reports |
| Level: |
Average difficulty |
| Exercise: |
Create a report which allows you to export to Excel, creating one worksheet for each group in the table. |
| Software: |
Report Builder |
| Topic: |
Parameters |
| Level: |
Relatively easy |
| Exercise: |
Create a report which lists out actors born between two given dates, entered by the user. |
| Software: |
Report Builder |
| Topic: |
Parameters |
| Level: |
Relatively easy |
| Exercise: |
Use a cube to create a report with two parameters. |
| Software: |
Report Builder |
| Topic: |
Parameters |
| Level: |
Average difficulty |
| Exercise: |
Create a report based on a cube, including dropdown parameters. |
| Software: |
Report Builder |
| Topic: |
Parameters |
| Level: |
Average difficulty |
| Exercise: |
Create a report listing all of the films made by the country chosen from a drop down list. |
| Software: |
Report Builder |
| Topic: |
Parameters |
| Level: |
Harder than average |
| Exercise: |
Create a report with a multivalue dropdown for directors and a linked dropdown for films, to show a list of actors appearing. |
| Software: |
Report Builder |
| Topic: |
Parameters |
| Level: |
Harder than average |
| Exercise: |
Create a report with two parameters: a multivalue list of languages, and a nullable minimum film length. |
| Software: |
Report Builder |
| Topic: |
Parameters |
| Level: |
Harder than average |
| Exercise: |
Use a cube to create a report with linked dropdown parameters. |
| Software: |
Report Builder |
| Topic: |
Matrices |
| Level: |
Relatively easy |
| Exercise: |
Create a matrix showing the average length of films by certificate and country. |
| Software: |
Report Builder |
| Topic: |
Matrices |
| Level: |
Relatively easy |
| Exercise: |
Create a report based on a cube, with a matrix and subtotals. |
| Software: |
Report Builder |
| Topic: |
Matrices |
| Level: |
Average difficulty |
| Exercise: |
Using a cube, create a matrix with cells formatted conditionally. |
| Software: |
Report Builder |
| Topic: |
Matrices |
| Level: |
Harder than average |
| Exercise: |
Create a matrix comparing Oscar nominations to wins, and hide the empty cells. |
| Software: |
Report Builder |
| Topic: |
Charts |
| Level: |
Average difficulty |
| Exercise: |
Create a chart with custom colours, with a legend and title. |
| Software: |
Report Builder |
| Topic: |
Charts |
| Level: |
Average difficulty |
| Exercise: |
Create and format a column chart comparing average film lengths by certificate and country. |
| Software: |
Report Builder |
| Topic: |
Miniature charts |
| Level: |
Average difficulty |
| Exercise: |
Create a table graphing box office takings by film director on 2 ways - using data bars, and a chart. |
| Software: |
Report Builder |
| Topic: |
Graphical indicators |
| Level: |
Relatively easy |
| Exercise: |
Incorporate indicators into a report to show the length of each film in a table graphically. |
| Software: |
Report Builder |
| Topic: |
Graphical indicators |
| Level: |
Harder than average |
| Exercise: |
Include a gauge in a report to show the number of films made by director - pink for girls, blue for boys. |
| Software: |
Report Builder |
| Topic: |
Lists |
| Level: |
Relatively easy |
| Exercise: |
Create a list, giving the details of one film at a time. |
| Software: |
Report Builder |
| Topic: |
Lists |
| Level: |
Average difficulty |
| Exercise: |
Create a cube-based report, with a table and chart for each list item. |
| Software: |
Report Builder |
| Topic: |
Lists |
| Level: |
Harder than average |
| Exercise: |
Create a list, showing for each director a table of films made and pie chart comparing box office takings for each. |
| Software: |
Report Builder |
| Topic: |
Subreports |
| Level: |
Average difficulty |
| Exercise: |
Create a main report of film directors and subreport of their films, or do using actions instead. |
You can search our full list of Report Builder exercises here.
Or why not learn to do them the right way on one of our Report Builder training courses? You can attend our online training classes wherever you are in the world!
