Exercise: Basic tables - list of films, fixed page headers

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.

The answer to the exercise will be included and explained if you attend the Wise Owl course listed below!

Category ==> SSRS Reporting Services  (53 exercises)
Topic ==> Tables  (2 exercises)
Level ==> Harder than average
Course ==> Reporting Services
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Create a new report with a dataset which shows a list of actors, with the films they have appeared in:

SQL Server Reporting Services 2008 R2 exercise - Tables (image 1)

The 3 tables that you will need for the dataset

Now create the report itself to look something like this (see hint below):

SQL Server Reporting Services 2008 R2 exercise - Tables (image 2)

The cast list appears in alphabetical order of actor name

The top (grey) box consists of a rectangle containing 4 text boxes, while the orange title is a table header merged across the 3 table columns.

See if you can arrange it so that, when you preview your report, the column headers stay visible both when you scroll down and when you move between pages.

Save this report as Who has done what, then close it down.

This page has 0 threads Add post