Specify the Size of an Indicator Using an Expression (Report Builder and SSRS)
Applies To: SQL Server 2016
In addition to color, direction, and shape, you can use size to maximize the visual impact of indicators.
An indicator has a collection of indicator states named IndicatorStates. The IndicatorStates collection typically have multiple states. Each state is a member of the collection and is represented by an icon. Together the states constitute the IndicatorsStates collection.
To dynamically configure the sizes of icons, you set properties of members of the IndicatorsStates collection in the Properties pane of Report Builder. If the Properties pane is not visible, click the View tab and select Properties.
The Properties pane provides access to the properties of the IndicatorStates collection of an indicator. You configure the icons to be different sizes by setting the ScaleFactor property of the IndicatorStates collection members using an expression. For more information, see Expressions (Report Builder and SSRS).
The expression used in this procedure was also used to generate the report with different sizes of indicators, shown in Indicators (Report Builder and SSRS).
Click the indicator you want to change.
In the Properties pane, locate the IndicatorStates property.
If the Properties pane is organized by category, you will find IndicatorStates in the States category.
Click the ellipsis (...) button next to IndicatorStates. The IndicatorState Collection Editor dialog box opens.
Select all members of the collection.
In the Multi-Select Properties list, click the down arrow next to ScaleFactor and then click Expression.
In the Expression dialog box write the expression.
The following sample expression makes the icon a different size based on the value of the SalesYTD field.
=IIF(Fields!SalesYTD.value = 0,0,Fields!SalesYTD.value/Max(Fields!SalesYTD.value,"Indicator"))
For more information, see Expression Examples (Report Builder and SSRS).