Key Performance Indicator (KPI) is one of the most import kind of reports, specially to decision makers. There are a few ways of implementing KPIs in SQL Server Reporting Services 2012.
Using graphs with the combination of expressions that manipulate bar, cell, and font colors corresponding to certain conditions is a common method of producing KPI reports. Gauge and indicator objects give better KPI implementation in most cases.
Let's create a table report with an inline gauge in one of its columns.
Before we proceed, execute the T-SQL script called
SalesPersonQuota.sql, which came with the downloadable code files for this chapter. This script creates a new table called
SalesPersonQuota, based on the view