SSRS 2008 R2 I need to create multiple points on a US map based upon addresses stored in a database. I have the street, city, state, and zip code. I do not have longitude or latitude cordinates. Extensive online searching has not helped. Everyone seems to be using longitude and latitude. If this cannot be done in SSRS, is there another way to do it? Thank you, Scott

Hi Scott, Actually, 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. If you want to show Point Layer which displays markers for point locations. You have to prepare cordinates, then build the connection between spatial data and your analytical data. For more information about Map, please see: http://technet.microsoft.com/en-us/library/ee240845.aspx Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

As I stated, I do not have longitude or latitude cordinates. Based upon your response I gather that you don't know of any other way. Is there a way I can get the coordinates based upon the address?

Hi Scott, SQL Server can support spacial data and make use of it, however we do not supply spacial data, Many commercial companies offers spatial data you could buy them. Such as: Map Data Sciences (Aust & NZ) ESRI Pitney Bowes MapInfo This is the similar thread at SQL Server Spatial forum http://social.msdn.microsoft.com/Forums/en/sqlspatial/thread/05a7e991-abad-4d21-9330-a8a24acb529f Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.