Specify the Size of an Indicator Using an Expression (Report Builder and SSRS)
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.
In SQL Server Data Tools (SSDT), you use the Properties window to set the member properties. If the Properties window is not open, press the F4 key.
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).
You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.
To specify the indicator icon size using an expression
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).