Indicators in SSRS

SQL Server Reporting Services provides several ways to analyze the data. Indicators are minimal gauges that convey the state of a single data value at a glance and are mostly used to represent the state value of Key Performance Indicator (KPI, a measurable value which has business significance with a specific target or goal that indicates whether things are going good or bad). Indicators can be used in either dashboards or free-form reports but more commonly are used in tabular or matrix reports to visualize data in rows or columns. 

Step by step implement Indicators in SSRS.

Here I am using AdventureWorksDW2008R2 data base and want to implement indicator based on the number of product sales unit. My sql query is below

select P.EnglishProductName,Count(FIS.ProductKey)as [Number of sales Unit] from FactInternetSales FIS Inner join DimProduct P ON P.ProductKey=FIS.ProductKey Group by P.EnglishProductName

Now open reporting service project.

Create new Report.

Create new data source.

Now create data set using the above sql query.

Click ok.

Now in report design insert a table having three columns as below.

In 3^rd Column we need to insert Indicator.

Click ok. You will get the following window

According to you requirements you can select the indicators. Click ok.

Select Indicator properties.

You will get below screen.

In general tab you can write the name of the Indicator. If you want to write the tool tip you can.

Now select Value and States Tab

A.     Select the value for the indictor.

B.    Select the Measurement unit either % or Numeric.

C.    Set the Icon, Color Minimum values and maximum value for the Icon

If you want to add more icon click on the add

In place of icon you can put your image for that you need to click on the Image button and browse the image.

Similarly for removing the icon you need to click delete button.

If you want to perform any action select Action tab.

D.   Click ok.

Now you can review the report you will get the desirer report.