Hi,

How can i get a shapefile for western australia suburbs? I want to plot customers by suburbs on a map but not sure where to get the file to link my table to.

Thanks

Hi lrj1985,

SQL Server Reporting Services Maps are based on spatial data that typically consists of points, lines, and polygons. For example, a polygon can represent the outline of a county, a line can represent a road, and a point can represent the location of a city. Each type of spatial data is displayed on a separate map layer as a set of map elements.

In this case, we can download shapefile for Western Australia, then create a custom map by following steps:

1. Download shapefile for Western Australia from shapefile.
   
2. Use SQL Server Spatial Tools to convert shapefiles to SQL Server spatial data.
   
3. Create a connection to the database.
   
4. Create a map with the SQL Server spatial data source.

For detail information about Using ESRI shape files, please refer to the following document:
http://blogs.msdn.com/b/querysimon/archive/2012/06/17/bi-data-on-maps-in-sql-server-2012.aspx

If you have any more questions, please feel free to ask.

Thanks,
Wendy Fu