Multi-State Maps in Reporting Services

March 24, 2011

In SQL Server 2008 R2 Reporting Services, you can now create maps for reports using the built-in map gallery of the United States or individual states, ESRI shapefiles, or a spatial query. In a previous post, I explained how to obtain an ESRI shapefile for another country and convert it into spatial data so that […]

0

Do-It-Yourself Map Gallery in SQL Server 2008 R2 Reporting Services

August 31, 2010

A common question that I get when introducing the map feature in SQL Server 2008 R2 Reporting Services is why the map gallery is limited to maps of the United States and individual states in the US. The reason as I’ve heard it explained is that the political boundaries for other countries are sometimes in […]

2

SQL Server 2008 R2 Reporting Services – The World is But a Stage (T-SQL Tuesday #006)

May 11, 2010

Host Michael Coles (blog|twitter) has selected LOB data as the topic for this month’s T-SQL Tuesday, so I’ll take this opportunity to post an overview of reporting with spatial data types. As part of my work with SQL Server 2008 R2 Reporting Services, I’ve been exploring the use of spatial data types in the new […]

4