Recently while browsing in MSDN forum, I was came across of this question. A person wanted to show 5 star rating kind of thing (just like we rate a particular blog in MSDN) in SSRS 2008 R2 using Indicators. As we all know, Indicators is very nice feature introduced in SSRS 2008 R2 which give a very nice look and feel to any report. Here are the steps how we can create 5 star rating in SSRS 2008 R2. Here, I am assuming that the field which is used for showing 5 star rating has values between 0-5 and also this can have decimal values like 2.5, 3.5 etc. I have used following sample SQL Query for this report: SELECT 'Blog0' Title, 0 RatingUNIONSELECT 'Blog1' , 0.5 UNIONSELECT 'Blog2', 1UNIONSELECT 'Blog3', 1.5UNIONSELECT 'Blog4', 2UNIONSELECT 'Blog5', 2.5UNIONSELECT 'Blog6' , 3UNIONSELECT 'Blog7' , 3.5 UNIONSELECT 'Blog8', 4UNIONSELECT 'Blog9', 4.5UNIONSELECT 'Blog10', 5
Recently while browsing in MSDN forum, I was came across of this question. A person wanted to show 5 star rating kind of thing (just like we rate a particular blog in MSDN) in SSRS 2008 R2 using Indicators.
As we all know, Indicators is very nice feature introduced in SSRS 2008 R2 which give a very nice look and feel to any report. Here are the steps how we can create 5 star rating in SSRS 2008 R2.
Here, I am assuming that the field which is used for showing 5 star rating has values between 0-5 and also this can have decimal values like 2.5, 3.5 etc.
I have used following sample SQL Query for this report:
SELECT 'Blog0' Title, 0 RatingUNIONSELECT 'Blog1' , 0.5 UNIONSELECT 'Blog2', 1UNIONSELECT 'Blog3', 1.5UNIONSELECT 'Blog4', 2UNIONSELECT 'Blog5', 2.5UNIONSELECT 'Blog6' , 3UNIONSELECT 'Blog7' , 3.5 UNIONSELECT 'Blog8', 4UNIONSELECT 'Blog9', 4.5UNIONSELECT 'Blog10', 5
Steps:
Indicator
Icon
Start Value
End Value
Indicaor1
1 (Not filled)
0
2 (Half Filled)
0.5
3 (Full Filled)
1
5
Indicaor2
1.5
2
Indicaor3
2.5
3
Indicaor4
3.5
4
Indicaor5
4.5
Run report. You will something like below image
Well, this is my first attempt of writting, hope whoever reads it, find it helpful. Your comments are welcome.