Change Indicator Icons and Indicator Sets (Report Builder and SSRS)

Reporting Services provides preconfigured indicators sets, which might not always depict your data effectively and work well in the delivered report. This topic provides procedures to change the appearance of indicator icons and change the indicator sets to include different, more, or fewer indicator icons.

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 change the color of an indicator icon

Right-click the indicator you want to change and click Indicator Properties.

Click Values and States in the left pane.

Click the down arrow in the Color column next to the icon that you want to change and click the color to use, No Color, or More colors.

Optionally, click the Expression (fx) button to edit an expression that sets the value of the Color option.

If you clicked More Colors, the Select Color dialog box opens, where you can choose from a wide array of colors. For more information about its options, see Select Color Dialog Box (Report Builder and SSRS). Click OK to close the Select Color dialog box.

Click OK.

To change the icon

Right-click the indicator you want to change and click Indicator Properties.

Click Values and States in the left pane.

Click the down arrow next to the icon that you want to change and select a different icon.

Optionally, click the Expression (fx) button to edit an expression that sets the value of the Icon option.

Click OK.

To use a custom image as an indicator icon

Right-click the indicator you want to change and click Indicator Properties.

Click Values and States in the left pane.

Click the down arrow next to the icon that you wan to change and select Image.

In the Select the image source list, click External, Embedded, or Database.

Depending on the source of the image, do the one of the following:

To use an image that is stored externally to the report, click Browse and locate the image. The report will include a reference to the image.

To use an image that is embedded in the report, click Import and locate the image. The image will be added to the report definition and saved with it.

To use an image that is in a database, in the Use this field list. select the field from the list and then in the Use this MIME type list, select the MIME type of the image.

Click OK.

To add an icon to the indicator set

Right-click the indicator you want to change and click Indicator Properties.

Click Values and States in the left pane.

Click Add. An indicator is added, using the default icon and the No Color option.

Configure the indictor to use the icon and color you want. Procedures earlier in this topic describe the steps to do this.

Click OK.

To delete an icon to the indicator set

Right-click the indicator you want to change and click Indicator Properties.