Create Custom Maps for SQL Server Reporting Services Mobile Reports

By:   |   Comments (1)   |   Related: > Reporting Services Development


Geospatial reporting inevitably requires reporting data on a map. SQL Server Mobile Report Publisher provides a set of maps out-of-the-box for authoring mobile reports. Often there is a need for custom maps which are not available in the limited set of maps available, so in this tip we will look at how to use custom maps in SQL Server Mobile Reports.


SQL Server Mobile Report Publisher provides options to use custom ESRI Shape files as maps for mobile reports development.

  1. Assuming that you have already installed SQL Server Mobile Report Publisher, open the application as shown below. In the maps section you should be able to see Geospatial Maps
  2. .

    SQL Server Mobile Report Publisher

  3. Drag any map on the grid and enlarge it for a clear view.

  4. New Mobile Report in SQL Server Mobile

  5. Click on the Map dropdown, and you should be able to see the out-of-the-box maps. The Custom map button allows you to select any custom ESRI shapes that can be used as a map. An ESRI Shape file is a .SHP file for shape geometries and a .DBF file for metadata. These files are required to be in the same location and should have the same file name. You can read more about the specifications here.

  6. New Custom Map in SQL Server Mobile Report Publisher

  7. Click on the Custom Map button and select a .SHP and .DBF file of a custom map. You can download this sample shape from here.

  8. Shape files in SQL Server Mobile Report Publisher

  9. Once you have successfully opened the shape file, it will be applied to the control and you should be able to visualize the custom map.

  10. Final Report Report in the SQL Server Mobile Report Publisher

In this way, any ESRI shape can be used as a custom map for a mobile report.

Next Steps
  • You can explore QGIS tool to author custom GIS Shapes.
  • Consider exploring this link to learn more about how to create your own ESRI Shapes to create custom maps.
  • Read these other Reporting Services Maps Tips.

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Siddharth Mehta Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

Tuesday, July 25, 2017 - 4:12:54 AM - Saad Back To Top (63203)



I'm getting the following error while trying to open this shapefile in QGIS:

"Layer is not valid, the layer ... is not valid and can't be added to the map" 

 any ideas how can I edit this file?



get free sql tips
agree to terms