Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Mapping data with SSRS 2008 R2

Posted by denglishbi on August 12, 2009

So I was testing out the new Map Report Item in SSRS 2008 R2 August CTP last night and this morning.  Still trying to get a feel for the new data visualization, but here are a couple of reports I put together using some data from the AdventureWorks2008 database.

image image

The first report is using the Map Gallery option and I am using the StateProvinceName field mapped to the STATENAME and displaying the 2003 Sales information.  The second one is using a SQL Server Spatial Query using the SpatialLocation information in the Address table for the Sales people which I added into the Sales.vSalesPerson view and it is using bubbles to display the 2003 Sales information on a Bing map with the Hybrid map option.  The nice thing about bubbles is that they provide you a way to evaluate two measures at once if you wanted – one by the size and the other by the color of the bubble.

Here are a few screenshots of the steps that I did to create these two reports:

image image  image
Select source for the spatial data Arrange the map and add a Bing map image reference if you want Select Visualization option
image image image
Match the spatial field to dataset field Select Theme, Field to visualize, and color rule Load the report (new loading visualization in SSRS 2008 R2)
image image image
Select source for the spatial data (going to utilize the spatial data in the SQL Server table) Select dataset for source of spatial data Choose spatial field layer type and map options
image image image
Picked the option to add Bing Map and changed type to Hybrid (options are Road, Ariel, or Hybrid) Select the visualization type Choose the analytical dataset
Specify the Theme and Bubble options (size or color) and the field(s) to visualize    

That is a quick run through of two of the spatial source options with the Map Report Item.  I will have to work with these a little more and come up with some more interesting layouts and visualizations using this new Report Item.

UPDATE (12/12/2009): If you are going to be using the Map Gallery option you should know that this is case sensitive and that your analytical data needs to match exactly to the geographical data – Mapping data with Report Builder 3.0 (SSRS 2008 R2) Case Sensitive.

2 Responses to “Mapping data with SSRS 2008 R2”

  1. Simon said

    Thanks for this sample. I’m really excited about the Map potential for RS. Does anyone know where I can get some Canadian maps, though?

  2. […] Mapping data with SSRS 2008 R2 […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: