Custom maps in Reporting Services mobile reports
Note
SQL Server Mobile Report Publisher is deprecated for all releases of SQL Server Reporting Services after SQL Server Reporting Services 2019. It's discontinued starting in SQL Server Reporting Services 2022 and Power BI Report Server.
Geographic maps in SQL Server Mobile Report Publisher are defined in a format known as ESRI shapefiles.
Designed by a private company, this format is now a widespread semi-open format used in a large portion of GIS applications. In accordance with this format, Mobile Report Publisher requires two files to be provided when defining a map:
- A .SHP file for shape geometries
- A .DBF file for metadata
The base files names must match, for example, canada.shp and canada.dbf. The metadata must include the field NAME with the value of the corresponding shape's name, or key, to be used when populating the map with data.
The two map files together, the SHP and the DBF, can be no bigger than 512 KB. If your map files are too large, use a tool like https://mapshaper.org/ to reduce their size.
See how to add custom maps to mobile reports.
Technical information
- The official specification: https://www.esri.com/library/whitepapers/pdfs/shapefile.pdf
- The Wikipedia shapefile article: https://en.wikipedia.org/wiki/Shapefile
Create and edit map geometry
Creating and editing shapefiles is a complex process that is beyond the scope of this document. Here are some resources and applications to help you get started:
- ArcGIS: https://www.arcgis.com/
- MAPublisher plug-in for Adobe Illustrator: https://www.avenza.com/mapublisher
- QuantumGIS (free): https://www.qgis.org/