WISE OWL EXERCISES
REPORT BUILDER EXERCISES
REPORT BUILDER EXERCISES
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. |
| 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.
This page has 0 threads
Add post