# Free Report Builder exercises

This page lists 42 Report Builder exercises. You can use the menu on the left to show just exercises for a specific topic.

This page lists 42 Report Builder exercises. You can use the menu above to show just exercises for a specific topic.

 Software: Report Builder Version: RB 3 or RB 2016 Topic: Basic reports Level: Relatively easy Course: Report Builder Exercise: Create a simple report with 3 images and a couple of text boxes.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Matrices Level: Relatively easy Course: Report Builder Exercise: Create a matrix showing the average length of films by certificate and country.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Matrices Level: Relatively easy Course: Report Builder Exercise: Create a report based on a cube, with a matrix and subtotals.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Parameters Level: Relatively easy Course: Report Builder Exercise: Use a cube to create a report with two parameters.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Tables Level: Relatively easy Course: Report Builder Exercise: Create a simple table which gives the name, birth date and gender of each film director, and apply interactive sorting.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Tables Level: Relatively easy Course: Report Builder Exercise: Use a cube as the basis for a simple table report, with sorting.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Expressions Level: Relatively easy Course: Report Builder Exercise: Create a report on a cube, with a header, footer and expression.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Parameters Level: Relatively easy Course: Report Builder Exercise: Create a report which lists out actors born between two given dates, entered by the user.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Expressions Level: Relatively easy Course: Report Builder Exercise: Create a table with a page header and footer, and including a simple calculated field.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Lists Level: Relatively easy Course: Report Builder Exercise: Create a list, giving the details of one film at a time.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Graphical indicators Level: Relatively easy Course: Report Builder Exercise: Create a report based on a cube with a simple indicator in a table.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Graphical indicators Level: Relatively easy Course: Report Builder Exercise: Incorporate indicators into a report to show the length of each film in a table graphically.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Charts Level: Average difficulty Course: Report Builder Exercise: Create a chart with custom colours, with a legend and title.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Graphical indicators Level: Average difficulty Course: Report Builder Exercise: Create and format a gauge to measure the running length of a film in minutes.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Expressions Level: Average difficulty Course: Report Builder Exercise: Use ReportItems to calculate the age of an actor when a film was made.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Charts Level: Average difficulty Course: Report Builder Exercise: Create and format a column chart comparing average film lengths by certificate and country.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Lists Level: Average difficulty Course: Report Builder Exercise: Create a cube-based report, with a table and chart for each list item.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Matrices Level: Average difficulty Course: Report Builder Exercise: Using a cube, create a matrix with cells formatted conditionally.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Miniature charts Level: Average difficulty Course: Report Builder Exercise: Use a cube to show data bars in each cell of a matrix.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Exporting reports Level: Average difficulty Course: Report Builder Exercise: Create a cube report so in Excel you get one sheet per group member.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Tables Level: Average difficulty Course: Report Builder Exercise: Use a cube to create a table, with filters and a subtotal.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Tables Level: Average difficulty Course: Report Builder Exercise: Create a report giving a table of films winning more than 10 nominations, in nomination order.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Miniature charts Level: Average difficulty Course: Report Builder Exercise: Create a table graphing box office takings by film director on 2 ways - using data bars, and a chart.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Exporting reports Level: Average difficulty Course: Report Builder Exercise: Create a report which allows you to export to Excel, creating one worksheet for each group in the table.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Parameters Level: Average difficulty Course: Report Builder Exercise: Create a report listing all of the films made by the country chosen from a drop down list.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Grouping Level: Average difficulty Course: Report Builder Exercise: Create a table listing films by country, and toggle display of films using the ToggleItem property.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Parameters Level: Average difficulty Course: Report Builder Exercise: Create a report based on a cube, including dropdown parameters.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Grouping Level: Average difficulty Course: Report Builder Exercise: Create a report based on a cube, with grouping levels / toggle items.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Expressions Level: Average difficulty Course: Report Builder Exercise: Use the SWITCH function and format expressions in a report of a cube.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Subreports Level: Average difficulty Course: Report Builder Exercise: Create a main report of film directors and subreport of their films, or do using actions instead.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Tables Level: Harder than average Course: Report Builder Exercise: Create a table of films for directors whose names start with E, with sorting, interactive sorting and subtotals.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Graphical indicators Level: Harder than average Course: Report Builder Exercise: Using a cube, create a report with gauges in each matrix cell.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Parameters Level: Harder than average Course: Report Builder Exercise: Use a cube to create a report with linked dropdown parameters.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Graphical indicators Level: Harder than average Course: Report Builder 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 Version: RB 3 or RB 2016 Topic: Parameters Level: Harder than average Course: Report Builder 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 Version: RB 3 or RB 2016 Topic: Lists Level: Harder than average Course: Report Builder 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 Version: RB 3 or RB 2016 Topic: Matrices Level: Harder than average Course: Report Builder Exercise: Create a matrix comparing Oscar nominations to wins, and hide the empty cells.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Parameters Level: Harder than average Course: Report Builder Exercise: Create a report with two parameters: a multivalue list of languages, and a nullable minimum film length.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Grouping Level: Harder than average Course: Report Builder Exercise: Use a cube to create a table with 2groups and expand/collapse symbols.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Tables Level: Harder than average Course: Report Builder Exercise: Use a cube for a report with a table inside a rectangle.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Expressions Level: Harder than average Course: Report Builder Exercise: Amend a report so that it has an alternating row colour and flashing background, using expressions.
 Software: Report Builder Version: RB 3 or RB 2016 Topic: Grouping Level: Harder than average Course: Report Builder Exercise: Create a grouped table of characters by director and then by actor gender, with subtotals and filtering.

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 classroom Report Builder training courses in the UK, or on one of our live online Report Builder courses wherever you are in the world?