WISE OWL EXERCISES
SSRS EXERCISES
SSRS REPORTING SERVICES EXERCISES
- Designing a Simple Report (3)
- Data sources and datasets (1)
- Tables (5)
- Grouping tables (6)
- Expressions (8)
- Pages and printing (2)
- Parameters (15)
- Indicators (3)
- Gauges (4)
- Matrices (5)
- Charts (6)
- Data bars and sparklines (2)
- Lists (4)
- Subreports (2)
- Revision of expressions (3)
- Variables (3)
- Embedding code (3)
- Basic Custom Assemblies (2)
- Examples of custom assemblies (1)
- Customising reports (2)
- Using SQL views (3)
- Stored procedures in SSRS (2)
- Stored procedure parameters (2)
- Dropdowns with procedures (3)
- Multivalue parameter procedures (1)
- Improving report navigation (2)
- Linking reports (drilldown) (4)
- Dynamic reports (2)
SSRS Reporting Services | Gauges 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 one of more of the courses listed below!
| Software ==> | SSRS Reporting Services (99 exercises) |
| Version ==> | SSRS 2012 and later |
| Topic ==> | Gauges (4 exercises) |
| Level ==> | Harder than average |
| Courses ==> | Reporting Services / Fast track SSRS |
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:
This is what your report could look like in design view
A suggestion for how the final report might look is shown below. 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:
The first two and a bit films
Save this report as Multiple Gauges, then close it down.