Microsoft Report Builder 3.0 training exercises (page 1 of 3)

Showing exercises 1-20 (out of 42)

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
Topic: Tables
Level: Average difficulty
Course: Report Builder
Exercise: Use a cube to create a table, with filters and a subtotal.

Go to exercise ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
Topic: Grouping
Level: Average difficulty
Course: Report Builder
Exercise: Create a report based on a cube, with grouping levels / toggle items.

Go to exercise ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
Topic: Expressions
Level: Relatively easy
Course: Report Builder
Exercise: Create a report on a cube, with a header, footer and expression.

Go to exercise ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
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 ...

Category: Report Builder 3.0
Topic: Parameters
Level: Relatively easy
Course: Report Builder
Exercise: Use a cube to create a report with two parameters.

Go to exercise ...

This page has 0 threads Add post