An Introduction to Data Bars in SQL Server Reporting Services 2008 R2

Data Bars are a new feature in SQL Server Reporting Services 2008 R2 introduced with the November CTP.  Data Bars are useful for building what are often referred to as “trellis” and “table lense” displays that help report consumers indentify possible correlations between multiple values, or in the case of a single column, to simply…

7

SQL Server Reporting Services 2008 R2 Map Tip: Address Geocoding with SQL Server 2008 Spatial

This post is just a pointer to a great blog post on Spatial Ed’s blog that addresses (pun intended) one of the most common questions I get regarding the map in Reporting Services which is, “In my database, all of my store locations, customers, etc. are just addresses. Can you map that?” The answer to…

0

Building Win-Loss Sparklines in SQL Server Reporting Services 2008 R2

With the November CTP of SQL Server Reporting Services 2008 R2, we are introducing a new visualization in SSRS, sparklines.  Sparklines were developed by Edward Tufte and are described as “small, intense, simple data words”.  In this post we’ll look at how you can add a “win-loss” sparkline to your reports.  For this example, we’ll…

0

Working with XY Scatter Charts in Reporting Services 2008

Recently, I’ve been fielding a few questions regarding XY Scatter Charts in Reporting Services 2008 (see MSDN Forum Question).  We have definitely noticed that working with XY Scatter charts is a bit difficult, and we do appreciate the feedback and will work to improve them in a future release.  The remainder of this post will…

8

Enabling Drilldown on (SSRS) Reporting Services 2008 Charts

In this post I’m going to spend some time covering a subject that comes up quite a bit on our forums, which is how to enable drill-down on a chart in Reporting Services. In this example, I’m using the Analysis Services 2008 AdventureWorks cube.  First, create a connection to the Analysis Services database, and in…

12