Free Report Builder exercises

This page lists 42 Report Builder exercises. You can use the menu 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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

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.

Go to exercise ...

You can search our full list of Report Builder exercises here.

This page has 0 threads Add post