In the latest release of SQL Server 2008 R2, Microsoft has released an updated version of Report Builder called Report builder 3.0. One of the interesting aspects of this tool is the ability to create map based reports. These reports are built based on spatial data available through SQL Server Database or through the ESRI Shape file. The ESRI shape file can be found on Census sites or through the Dundas Maps site.
Developing MAP based reports and dashboards have been bought to the developers tool set, this should give them the ability to provide more visual reports to the business. This also greatly enhances the value and presentation of the reports. Here is a link to report builder 3.0 tutorial.
http://msdn.microsoft.com/en-us/library/ee240845(SQL.105).aspx
http://msdn.microsoft.com/en-us/library/ee240845(SQL.105).aspx