If you have ever wanted to put a geographic map into a SQL Reporting Services report this is the article for you. I wrote this article a while back but thought it might be prudent to share it on my blog since I talk to people all the time who want to do this type of thing. Having a map can really give you a great visual tool to analyze your custom data within a geographic area.
I titled the article Integrating Map Suite with SQL Reporting Services, in hindsight I probably should have picked some different data to base the map on since many of the states don't change color when you choose a different display option. However if you watch Oregon you will notice that it changes between Medium and High shading when “Total Sales Amt”is chosen versus the “Number of Orders“ as the display option. All of the data in the report is based upon the AdventureWorks2000 database that is optionally installed with SQL Reporting Services, if you want to play around with the report or build your own map you can download all the .NET source code.