SSRS 2008 R2 I need to create a report that shows a map of the US. The report will create icons on the map based on addresses in a database to show where our sale reps are currently located. If possible I would like to be able to click on an icon and have details about the sales rep brought up. It would also be nice if the icon picture varied depending on who the sales rep is.

Hi Scott, It can be achieved that displaying icons on the map based on addresses in database. As an example, I would suggest you read the blog RS Maps with Spatial Data and Bing Maps by Robert at: http://blogs.msdn.com/b/robertbruckner/archive/2009/08/11/rs-maps-with-spatial-data-and-bing-maps.aspx The point on the map also can be customized and support drillthrough action. For more information about Maps, please refer to: http://msdn.microsoft.com/en-us/library/ee240845.aspx Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Scott, It can be achieved that displaying icons on the map based on addresses in database. As an example, I would suggest you read the blog RS Maps with Spatial Data and Bing Maps by Robert at: http://blogs.msdn.com/b/robertbruckner/archive/2009/08/11/rs-maps-with-spatial-data-and-bing-maps.aspx The point on the map also can be customized and support drillthrough action. For more information about Maps, please refer to: http://msdn.microsoft.com/en-us/library/ee240845.aspx Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Unfortunatly, I only have an address. I don't know the longitude and latitude.