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 3rd
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.
