Welcome to MSDN Blogs Sign in | Join | Help
Implementation of Sparkline Type Reports within Reporting Services

As with any dashboard implementation, an intuitive user interface design is desired, thus leveraging the latest concepts in dashboard user interfaces.  One of those concepts is to display Sparkline type charts.  A “Sparkline” is a word coined by Edward Tufte to describe “small, high-resolution graphics embedded in a context of words, numbers, and images.” Sparklines are “word-sized graphics” which can be used to add context to data in a sentence. More than that, though, Sparklines are word like graphics that can be used almost as words.

To implement Sparklines within Reporting Services is rather easy…in fact, the charting object within Reporting Services can be shrunk within a table object, thus producing the Sparkline image.

Do note though that placing many inline Reporting Services charts within a table will put more processing burden on the Reporting Services server, since each chart needs to be determined and rendered.

Other than leveraging the chart object within Reporting Services, there are a few third party solutions that “plug into” the Microsoft BI Platform to allow Sparkline and other visualization techniques.  One such offering is from BonaVista Systems – through a product called MicroCharts.  For more information visit this link: http://www.bonavistasystems.com/Products_SparkLinerforMicrosoftBI.html.

Posted: Wednesday, January 09, 2008 10:55 PM by jbasilico

Comments

SQL Server Data Platform @ MTC said:

Wondering how to implement "sparkline" type reports with Reporting Services, well take a look at this

# March 5, 2008 8:38 AM
Anonymous comments are disabled
Page view tracker