This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	SSRS Reporting Services (99 exercises)
Topic ==>	Expressions (8 exercises)
Level ==>	Harder than average
Subject ==>	SSRS training

Create a report listing film directors by age (including calculating this age with an expression and conditional formatting)

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

Create a new report, and within this a dataset listing the following columns:

DirectorName (from the tblDirector table)

DirectorDob (from the tblDirector table)

FilmName (from the tblFilm table)

FilmReleaseDate (from the tblFilm table)

Apply a criteria to show only directors of films winning exactly 3 Oscars - this should give 4 rows.

Create a report to include an expression giving the age of each director at the time a film was released (see hint below), with a subtotal at the bottom showing the average director's age: