SQL Server 2008 introduced new spatial data types including a geography type that can be used to store latitude and longitude coordinates. The new map feature in SQL Server Reporting Services 2008 R2 works with the geography type as well as with state abbreviations, state names, or state numbers.
The built-in map feature allows you to add a map to a report and show the states in the US or the counties within a state. You can use the map to render one or more data points, providing a slick visualization of your data by state or county within a state. Read More.