Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Create Custom Maps for SQL Server Reporting Services SSRS Mobile Reports


By:   |   Last Updated: 2017-03-02   |   Comments (1)   |   Related Tips: > 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


next webcast button


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




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



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


Learn more about SQL Server tools