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.
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:
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.