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.
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?
ReplyDeleteThanks.
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.
ReplyDeletehttp://diva-gis.org/Data