Mapping data with SSRS 2008 R2

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.

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:

Select source for the spatial data	Arrange the map and add a Bing map image reference if you want	Select Visualization option
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)
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
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.

About these ads