Bullet Charts and Sparklines in Reporting Services 2005

Here at Adatis we’re big fans of Reporting Services.  Yep, it has it’s quirks and frustrations (don’t talk to me about excel export!) but doesn’t deserve all the criticism it gets in our opinion.  You can create some great looking reports with not a lot of extra effort over the defaults (though how many times have you seen a “slate” style report called “Report1” go into production!)

We’re also fans of what some might call the more “trendy” visualisation techniques such as sparklines and bullet charts and with Microsoft acquiring Dundas technology for use in SQL 2008, SSRS has some much improved functionality in this area.  I’ll be taking a look at some of these new features in a future post.

Whilst SSRS 2005 does have it’s limitations, with a little effort you can still create some very effective information visualisations.  The dashboard below is built using completely standard functionality

Adding sparklines and in-table bar charts is very simple (and pretty clever IMO).  This MSDN Article covers how to do it in detail but in essence you simply add a line or bar chart into a cell in your data table.

Whilst the bullet chart (in the Sales Channel Performance region of the dashboard) may be simplistic compared to those available in SSRS 2008 or MicroCharts from XLCubed (from whom I nicked the styling for our dashboard) it still provides a very clear visualisation of the data.  This required a little more trickery in the underlying query but is also just a chart in a table cell – this time a 100% stacked bar.  I’ve explained how this works here