BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Indicators are one of the nicest new features of SSRS 2008 R2 (or SQL Server Reporting Services, to give the software its full name). This blog shows how to add indicators to a table, format them and set scaling correctly.
Posted by Andy Brown on 25 July 2011
You need a minimum screen resolution of about 700 pixels width to see our blogs. 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.
Scaling of Indicators
If you've followed the previous parts of this blog, you'll have an indicator which isn't showing the right pictures. This is because we need to change the indicator's scaling:
Right-click on the indicator itself (and not the box containing it) and choose to change its properties.
The first thing you'll see is the dialog box shown below:
When you click on the Values and States tab, this is what we see initially.
You now need to change the following things:
- Change the measurement units from Percentage to Numeric.
- Delete the second and fourth icon (since we only want to divide the films into 3 bands, not 5).
- Change the Start and End values for each of the remaining 3 indicators to divide the films up into 0-120 minutes, 120-180 minutes and 180+ minutes.
- Change the star colours from the wishy-washy yellow to an easier-to-see brown.
See above for the numbered steps
The effect of these changes should be as follows:
We could do now with making the indicators bigger and making some other formatting changes.
As a final step, we'll format the indicators to look a bit better!
Note that if you have a grouped table and are using Percentage scaling, you can set the Synchronization scope to scale over a group, rather than over the entire report.