Tutorial Gateway

  • C Language
  • Java
  • R
  • SQL
  • MySQL
  • Python
  • BI Tools
    • Informatica
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • QlikView
  • Js

Indicators in SSRS

by suresh

In this article, we will show you, How to create and configure the Indicators in SSRS. For this, We are going to use the below-shown report. Please refer to SSRS Table Report, Data Source and Dataset articles to understand the creation of Data Source, Dataset and Table report.

If you observe the below screenshot, It was a normal Table report with City, Name, Job Title, Sales Last Year and Sales Year to Date columns.
Indicators in SSRS 1

We used the Embedded Dataset for the above report and the Dataset is shown in below screenshot

Indicators in SSRS 2

SQL Command we used as the Dataset is:

SELECT [City]
      ,[FirstName]+' '+[LastName] AS [FullName]
      ,[JobTitle]
      ,[SalesYTD]
      ,[SalesLastYear]
  FROM [AdventureWorks2014].[Sales].[vSalesPerson]

Creating Indicators in SSRS

In this example, We will create and add the Indicator on the right-hand side of the Sales YTD and the Indicator should satisfy the below conditions:

  • If the value of Sales YTD is less than Sales Last year then display Red Indicator.
  • Anything Greater than Sales Last Year, Display Yellow Indicator.

First, Let us create an Empty column by right-clicking on the Sales YTD column and select the Insert Column option and then select the Right option.

Next, Drag and drop the Drop the Indicator from Toolbox to an Empty column. When you drag and Drop the Indicator from Toolbox to an Empty column, a new window called Select Indicator Type will be opened to select required Indicators (Directional, Symbols, Shapes and Ratings) from the available once.

In this example, we are selecting Simple Shape Indicator as shown in below screenshot.
Indicators in SSRS 3

Click Ok to add Indicator to a newly created empty cell. Now, we have to configure the Indicator value. First, Click on the Indicator will open the Gauge Data window.

In this example, we want to show the Indicator for Sales YTD. So, Please drag and drop or select the Sales YTD as the Indicator Value.
Indicators in SSRS 4

NOTE: Please be careful when dragging the columns to values region, if you mishandled or dropped in design area will end up in mess.

Next, we have to configure the Indicator Properties so, Right Click on the Indicator will open the context menu. Please select the Indicator Properties option from it.

Indicators in SSRS 5

Once you select the Indicator Properties option, a new window will be opened to configure the indicator values. First, go to the Values and State tab, you can notice the default settings of the indicator values here.

By default States Measurement Unit value is Percentage and from 0 to 33 Red Indicators, 33 to 66 Yellow Indicator and 66 to 100 Green Indicator. If you want to change the percentage values, you can replace the default value or else use the fx button for custom expressions.

Indicators in SSRS 6

In this example, we want to display the indicators based on Numeric values. So, Please change the States Measurement Unit value from Percentage to Numeric as shown in below screenshot. We are also removing Green Indicator by selecting the Green and deleting it.

Indicators in SSRS 7

From the above screenshot, For the Red indicator, we are fine with the Start value 0. However, we have to change the End value. So, we are selecting the fx button next to End value Textbox and write the following expression.
Indicators in SSRS 8

It means, If the Sales YTD value is between 0 and Sales Last Year Value then Red Indicator will be displayed.

Next, We are changing the Starting value of the Yellow indicator. By clicking the fx button next to the Start value Textbox and write the following expression.

Indicators in SSRS 9

Next, We are leaving the End value of a Yellow Indicator empty. It means, If the Sales YTD value is greater than Sales Last Year then Yellow Indicator will be displayed.

Indicators in SSRS 10

Click Ok to finish configuring the Indicator properties. Let’s see the Report preview by clicking on the preview tab

Indicators in SSRS 11

Thank you For Visiting Our Blog

Placed Under: SSRS

Stay in Touch!

Sign Up to receive Email updates on Latest Tutorials

  • C Programs
  • Java Programs
  • SQL FAQ’s
  • Python Programs
  • SSIS
  • Tableau
  • JavaScript

Copyright © 2019 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy