KPI in SSRS 2005, 2008 and 2008 R2

KPI - Key Performance Indicator is used as a measure of performance (success/failure) of a particular activity. Sometime it is very useful to define a new strategy for the organization.

Let's talk about KPI in SSRS 2008 R2, they have introduced new item in toolbox called 'Indicator'. So we directly drag and drop that indicator to define KPIs in 2008 R2. There are many choices available for KPI presentation like Directional, Symbols, Shapes, Ratings in SSRS 2008 R2.

But in SSRS 2005, 2008 version, There are two ways to define KPIs in the reports 1) by adding images and image value expression and 2) by adding a new column with background color expression.

1) Ex. you want to define KPIs for sales amount > 200 'Green', <= 200 and >= 100 'Yellow', <100 'Red'

Simply add a new column and go to the background color property -->add expression there

Method1: (Using IIF statement)

=iif(fields!salesamt.value > 200, "Green", iif(fields!salesamt.value >= 100 and fields!salesamt.value <=200, "Yellow", "Red"))

Mehotd2: (Using SWITCH statement)

=switch(fields!salesamt.value > 200, "Green", (fields!salesamt.value >= 100 and fields!salesamt.value <=200), "Yellow", true, "Red"))

2) You can also do this by adding images (right click on the image (left in report data) --> add image and select circle, square, arrow etc (red, green, yellow) images and add there.

Next drag image to the column and go to the image value property --> select the image source (Embedded) --> add expression

Method1:
=iif(fields!salesamt.value > 200, "BlueCircle", iif(fields!salesamt.value >= 100 and fields!salesamt.value <=200, "YellowCircle", "RedCircle"))

Method2:

=switch(fields!salesamt.value > 200, "BlueCircle", (fields!salesamt.value >= 100 and fields!salesamt.value <=200), "YellowCircle", true, "RedCircle"))