Hi,
Recently I was working on a SSRS Report that will show the countries in the world map (Country was a custom entity in our CRM)
To create such a report, drag the Map report item to the report designer.
OOB we do not have world map in the Map Gallery.
Download it from the following location
https://mapgallery.codeplex.com/releases
Copy the download RDL to the following location (in my case – SQL Server Data Tools for VS 2012)
Select the world map
Add a Bing Map layer
Select Basic map
Click Next and select appropriate value
Click on Finish.
Next inside report designer, right click Layer Data
And specify mapping between the spatial and analytical dataset (our custom dataset here which has 2 column in it, name of the country and A2.
Suppose we have following countries in our CRM
The final report with countries highlighted in colors.
Hope it helps..
Share this:
