Exercise: Two gauges in panel, budget and box office

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 ==> Gauges  (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 table/report which uses gauges to show film budgets against film box office takings:

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

This is what your report could look like in design view

A suggestion for how the final report might look is shown overleaf.  In the meantime, here's some information which may be helpful:

  • The title banner is a label, whose height/width is set relative to the containing gauge panel, rather than to one of the individual gauges
  • The font of the title is hard-coded to 6 points, rather than being automatically set according to the text it contains
  • The other two labels are offset relative to the gauge to which they pertain
  • The gauges measure the budget and box office takings divided by one million
  • The scaling of each gauge goes from 0 to 2000, and the number format of the labels has been set

Here is what the final report might look like:

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

The first two and a bit films

Save this report as Multiple Gauges, then close it down.

This page has 0 threads Add post