Pro SQL Server 2012 Reporting Services

CHAPTER 5  IMPLEMENTING DASHBOARD STYLE REPORT OBJECTS

Figure 5-11. ESRI Shapefile of Duval County, Jacksonville, FL

The third way you can get your spatial data is by using a SQL Server Spatial query. This allows you to

create your own queries to display geographical details along with quantifiable data. For example, it is

easy to create a query that returns a listing of total sales amount for every State in the US. You can then

overlay those details on top of a map.

 Note Out of the box, the map gallery included with Reporting Services consists of the United States as well as

each individual State within the US. However, you can create your own maps. You can also download more map

galleries from the codeplex website (http://mapgallery.codeplex.com/releases). In order for the Map Wizard

to see the map files that you create or download, you will need to save them in “<drive>:\Program Files

(x86)\Microsoft Visual Studio ##.0\Common7\IDE\PrivateAssemblies\MapGallery”, “C:\Program Files\Microsoft

Visual Studio ##.0\Common7\IDE\PrivateAssemblies\MapGallery” or <drive>:\Program Files\Microsoft SQL

Server\Report Builder 3.0\MapGallery after downloading or creating them.