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 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?
This page has 0 threads
Add post