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:
Nishant, are there any licencing implications around use of bing maps, i.e. would the company need to have a Bing maps licence per user in order to use this?
LikeLike
No Richard i do not think so, as we are using the one in codeplex https://mapgallery.codeplex.com/license
LikeLike