SSRS Reporting Services | Parameters exercise | Navigation link, hidden green line

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.

Software ==> SSRS Reporting Services  (99 exercises)
Version ==> SSRS 2012 and later
Topic ==> Parameters  (15 exercises)
Level ==> Harder than average
Subject ==> SSRS training
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 report which shows either a green line or a red square, depending on which parameter you choose:

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

What you see if you choose the green line!

Save this report as Green or red, then close it down.

Too easy?  Create another report which displays a list of films by certificate:

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

We will create a navigation link for the number of films for each certificate, as shown here

When you click on any of the white cells, you should be taken to a separate report listing out of all the films which make up this number:

SQL Server Reporting Services 2008 R2 exercise - Parameters (image 3)

The 8 certificate U films you should see for the above example

Save your reports with names starting with Green, then close them down.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post