Working with Indicators in SSRS

How to use Indicators in SSRS :

Indicators in SSRS are useful to show the report in symbolic representation of the Status/Progress of the Fields in the report. By using the Indicators its easy to understand the report. It gives rich interface to the report.

The below example shows how to use indicators in SSRS reports.

Go To Report in Data Tools

Add New Item. Select Report and Click Ok.

Go to Tool Box and Drag and Drop the table.Add 3 columns. Name,marks, Scrore/Grade. 

Create Data Source and Create Data Set using the Report data .

create table #studentmarks (id int identity ,name varchar(50), marks int );

insert into #studentmarks values ('malli',80),('naga',60),('eswar',30),('reddy',50)

select name , marks from #studentmarks

drop table #studentmarks

The above sample query gives output of studentmarks.

Place the Indicator in the Pass/ Grade  text box as shown below. There are 4 different Indicator types as shown below. 

• Directional : Showing Directions
• Symbols : Showing the Pass/Fail Status ,Correct/Incorrect
• Shapes : Showing different shapes triangle/circle etc
• Ratings : Showing rating using different icons stars/bar/charts

Select rating tab. Click Ok.

Right Click the Score Grade text box (Star symbol area) as shown below.

Click on Indicator properties as show below. Go to Value and States tab as shown below.

By default there are two measurement units available for indicators

1) Numberic
2)Percentage 

Here in the below example I have used the numeric to show the indicators

Value drop down can be use the sum and count of integer column fields. To change the expression of the value column click of fx. Select Fields (dataset) Category and select marks field.

Click ok. Then save the indicator properties and run the reports. The Out put of Report UI can been seen below.