Indicators in SSRS Report

Indicators in SSRS Report

In this article, I will show you how to use Indicators in SSRS Report.

1. First of all create table named as TopFootballPlayers in Database and insert some data as in following script :

CREATE TABLE TopFootballPlayers
(
	No					INT,
	PlayerName			VARCHAR(50),
	Country				VARCHAR(50),
	InternationalGoals	INT
)

INSERT INTO TopFootballPlayers VALUES (1,'Ali Daei',' Iran',109)
INSERT INTO TopFootballPlayers VALUES (2,'Ferenc Puskás',' Hungary',84)
INSERT INTO TopFootballPlayers VALUES (3,'Kunishige Kamamoto',' Japan',80)
INSERT INTO TopFootballPlayers VALUES (4,'Pele',' Brazil',77)
INSERT INTO TopFootballPlayers VALUES (5,'Sandor Kocsis',' Hungary',75)
INSERT INTO TopFootballPlayers VALUES (6,'Bashar Abdullah',' Kuwait',75)
INSERT INTO TopFootballPlayers VALUES (7,'Kiatisuk Senamuang',' Thailand',71)
INSERT INTO TopFootballPlayers VALUES (8,'Stern John',' Trinidad and Tobago',70)
INSERT INTO TopFootballPlayers VALUES (9,'Hossam Hassan',' Egypt',69)
INSERT INTO TopFootballPlayers VALUES (10,'Gerd Müller',' West Germany',68)
INSERT INTO TopFootballPlayers VALUES (11,'Miroslav Klose',' Germany',67)
INSERT INTO TopFootballPlayers VALUES (12,'Majed Abdullah',' Saudi Arabia',67)
INSERT INTO TopFootballPlayers VALUES (13,'Jassem Al-Houwaidi',' Kuwait',63)
INSERT INTO TopFootballPlayers VALUES (14,'Ronaldo',' Brazil',62)
INSERT INTO TopFootballPlayers VALUES (15,'Hussain Saeed Mohammed',' Iraq',61)
INSERT INTO TopFootballPlayers VALUES (16,'Imre Schlosser',' Hungary',59)
INSERT INTO TopFootballPlayers VALUES (17,'Didier Drogba',' Côte dIvoire',58)
INSERT INTO TopFootballPlayers VALUES (18,'Gabriel Batistuta',' Argentina',56)
INSERT INTO TopFootballPlayers VALUES (19,'Carlos Pavón',' Honduras',56)
INSERT INTO TopFootballPlayers VALUES (20,'Romario',' Brazil',55)
INSERT INTO TopFootballPlayers VALUES (21,'Kazuyoshi Miura',' Japan',55)
INSERT INTO TopFootballPlayers VALUES (22,'Jan Koller',' Czech Republic',55)
INSERT INTO TopFootballPlayers VALUES (23,'Joachim Streich',' East Germany',55)
INSERT INTO TopFootballPlayers VALUES (24,'Carlos Ruiz',' Guatemala',55)
INSERT INTO TopFootballPlayers VALUES (25,'Cha Bum-Kun',' South Korea',55)
INSERT INTO TopFootballPlayers VALUES (26,'Robbie Keane',' Republic of Ireland',54)
INSERT INTO TopFootballPlayers VALUES (27,'Adnan Al Talyani',' United Arab Emirates',54)
INSERT INTO TopFootballPlayers VALUES (28,'Samuel Etoo',' Cameroon',53)
INSERT INTO TopFootballPlayers VALUES (29,'Poul Nielsen',' Denmark',52)
INSERT INTO TopFootballPlayers VALUES (30,'Zico',' Brazil',52)
INSERT INTO TopFootballPlayers VALUES (31,'David Villa',' Spain',52)
INSERT INTO TopFootballPlayers VALUES (32,'Fandi Ahmad',' Singapore',52)
INSERT INTO TopFootballPlayers VALUES (33,'Jon Dahl Tomasson',' Denmark',52)
INSERT INTO TopFootballPlayers VALUES (34,'Lajos Tichy',' Hungary',51)
INSERT INTO TopFootballPlayers VALUES (35,'Hakan Sukur',' Turkey',51)
INSERT INTO TopFootballPlayers VALUES (36,'Thierry Henry',' France',51)
INSERT INTO TopFootballPlayers VALUES (37,'Karim Bagheri',' Iran',50)
INSERT INTO TopFootballPlayers VALUES (38,'Hwang Sun-Hong',' South Korea',50)

Let us check output after a simple select query.

SELECT		* 
FROM		TOPFOOTBALLPLAYERS

Output is as below :

1-Indicators in SSRS Report

2. Now open Visual Studio 2010 and open your SSRS project. Then add report named as DemoIndicator in your project.

Now create a Dataset. In the dataset, we will use following query :

SELECT		* 
FROM		TOPFOOTBALLPLAYERS
ORDER BY	PLAYERNAME

3. Now right click on report area and go to Insert–>Table. Then select data fields as a column in table. After that your Report Design will look like below.

3-Indicators in SSRS Report

4. Then right click on 3rd column and insert columns on right side.

4-Indicators in SSRS Report

In 4th column select data field Internationalgoals.

Repeat 4th step to add another column which is for indicator.

5. Now your report design will looks like below:

5-Indicators in SSRS Report

6. Now right click on last column and Select Insert–> Indicator.

6-Indicators in SSRS Report

7. A Select Indicator Type window opens. Then select Directional from left pane & select 3 Arrows(Colored). Then click on Ok button.

7-Indicators in SSRS Report

8. Now right click on Indicator & select Indicator Properties.

8-Indicators in SSRS Report

9. A Indicator properties window opens up. In that window, select Value and States from left pane. Then select Value, States Measurement Unit & Add Indicator States as shown in below screen :

9-Indicators in SSRS Report

Then click on Ok button.

10. So we have done with indicators in SSRS. To see the result click on Preview Tab.

10-Indicators in SSRS Report

Congratulations! We successfully completed Indicators in SSRS Report.

8 thoughts on “Indicators in SSRS Report

  1. Pingback: Gauge Data Region in SSRS

    • Hello,

      i.e. when there is a report with row and column grouping applied showing list of Sales Team employees with amount of participation in selling number of products, for example the data will look something like this:
      EmployeeID EmployeeName Product1 Product2 Product3
      102 Smith 25000 76000 9839
      103 Albert 7700 9090
      …….
      in this cas if you use SSRS built-in indicators, in the second row (Albert) an indicator will appear for Product2 although this employee is not participating in this product sales.

      Regards,

Leave a Reply to Jeeva Cancel reply

Your email address will not be published. Required fields are marked *