SSRS 2008 R2 Map Reports
We have a user that would like to create a multi-tab report in SSRS. One tab would be a map where they could have tool-tips to the data related to that area on the map. A few questions: - how do we go about getting maps that we could use for Europe? Seems SQL only includes maps for USA - would the map export to excel with the tooltips in the report? Thanks! EmilioEmilio
February 21st, 2011 4:17pm

Hi Emilio, Generally, to find spatial data to use in your map, you can use the following sources: · ESRI Shapefiles, including publicly available Shapefiles that you can search for on the Internet. · Spatial data from SQL Server spatial data sources. · Maps from reports in the Map Gallery. · Third-party sites that offer spatial data as ESRI Shapefiles or SQL Server spatial data. · Bing map tiles, which provide a background for the map view. To display tiles in a map, the report server must be configured to support Bing Maps Web Services. In order to get maps for Europe, we can search the ESRI shapefiles of Europe which are available on the Web. For more information about Finding ESRI Shapefiles for a Map, please refer to: http://social.technet.microsoft.com/wiki/contents/articles/finding-esri-shapefiles-for-a-sql-server-2008-r2-reporting-services-map-ssrs.aspx In addition, there are also some websites provide free spatial data, for example DIVA-GIS (http://www.diva-gis.org/Data). Please be aware that spatial data and other data that is contained in ESRI shapefiles can be politically sensitive and possibly copyrighted. For the second, the map will be converted to a picture in rendering Excel, and I’m afraid it doesn’t support tooltips. 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.
Free Windows Admin Tool Kit Click here and download it now
February 21st, 2011 9:11pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics