Saturday, July 21, 2012

Creating Map Drill Down Reports in SSRS - SQL Server 2008 R2

In my last article, I talked about creating map report based on ESRI shapefile. In this article I will be talking about creating a map report with drill down functionality, so basically I will be creating two reports as follows:
  • Main report based on SQL Server Spatial data for showing countries wide sales
  • Drill down map report based on ESRI shapfile for showing statewise sales for the selected country
The idea behind this article is to demonstrate how you can use a combination of sources of spatial data and create a map drill down report. Also I will explain how you can import ESRI shapefile to SQL Server as a spatial data type and use it in a map report; for more information click here.


  1. Hello Arshad, can you help me, I need .shp or .rdl maps supported in SSRS R2 of India, Panama, Ecuador, Costa Rica, all with basic boundaries. You know where can find this?


  2. Environmental Systems Research Institute, Inc. provides shapefiles, which can be used as source for geographical data or spatial information. These shapefiles are freely available here.