Chapter 9
Gauges, Sparklines, and Indicators
Section 1
Queries Optimized for Gauges, Sparklines, and Indicators
Gauges, sparklines, and indicators are report objects in SSRS which provide an impressive way to display summarized information for presentations, documents, and web pages. Each object requires specific data elements for proper operation and to give the user the scope of the data. - For gauges, it is best that the query returns an amount, a target value, and a percentage for a specific item - For sparklines, the query needs to return a series of numbers, preferably showing how a value changes over time - For indicators, the query can return an amount, a target value and a percentage for multiple items