Using SSRS 2008 I was able to build a county "heat map" of sales for one of our suppliers by following the instructions on https://www.simple-talk.com/sql/reporting-services/report-building-3.0-adding-maps-to-your-reports/ In the map layers property box you can choose "States by County" for the United States, after that it is setting up your analytical dataset query elements to correspond to the fields on the map.