Create Custom Maps for SQL Server Reporting Services SSRS Mobile Reports


By:   |   Updated: 2017-03-02   |   Comments (1)   |   Related: > Reporting Services Maps

Problem

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.

Solution

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.


Last Updated: 2017-03-02


get scripts

next tip button



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

View all my tips





Comments For This Article




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

Hi,

 

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?

Thanks

Saad



download


Recommended Reading

Creating an SSRS Map report with data pinpoints

Maps in SQL Server 2008 R2 Reporting Services

SQL Server Reporting Services Analytical Marker Maps Including Bing Maps





get free sql tips
agree to terms


Learn more about SQL Server tools