Map Gallery on Codeplex for your SSRS 2008 R2 Reports

If you are using maps in SSRS 2008 R2, you might be aware that the Map Wizard only provides U.S. based maps.  However, it is totally possible to add more maps to the gallery.  Head on over to http://mapgallery.codeplex.com/ where a community project has started up to provide maps for other locations.  The site also includes links…

3

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

SSRS and Microsoft Chart Control How To: Change the Width of Bars and Columns

Every once and I while I get asked this question, and it fits nicely with a series I’ve been planning to blog on what you can do with custom attributes in charts in SQL Server Reporting Services 2008.  The question is, "How do I change the width of the bars and columns on the charts?". …

7

How To: Build Sparkline Reports in SQL Server Reporting Services

This is my first post in what I hope is a long series of how to’s related to data visualization.    For my first post I’m going to demonstrate how you can add sparklines to your SSRS reports.  Below is a screenshot of what a sparkline may look like in SSRS.    Sparklines are effectively miniature…

9