i have dataset city names, zipcode, lat , long among other data. want show number of contacts city or zipcode. state maps come ssrs have county level available. yeah, can show how many contacts took place on county level, need city or zipcode. way state maps come ssrs? thanks.
you can convert latitude , longitude geographic point in sql. ssrs let add markers @ points on map. can still use labels etc. sql function this:
geography::parse('point(' + cast([longitude] varchar(20)) + ' ' + cast([latitude] varchar(20)) + ')') here's reference: http://www.sql-server-helper.com/sql-server-2008/convert-latitude-longitude-to-geography-point.aspx
edit:
use "new layer wizard" add layer state map.
select "sql server spatial query" option.
specify geographic point dataset.
this add points layer on map.
