Maps in SQL Server 2012 Reporting Services

I had a quick play with the map part in SQL Server 2012 Reporting Services. The good news is that is is so easy to try out, that you will reach the limitations very soon without too much of a time investment.


When would you want to use a map in SSRS?

  • Your data items have locations specified in SQL Server spatial data types.
  • You have a limited amount of data to display (roughly less than 100)
  • You don’t need your map to be interactive

What scenarios are suited?

  • A quick dashboard display
  • Embedding in a printed report

What scenarios are not suited?

  • Interactive web pages
  • Geo spatial manipulation in the Report itself
How do I try this out?
Step 1: Create a table or view with at least one column with the Geography data type.


Step 2: Add a new Report (not Wizard) to your project.


Step 3: Pull a Map control from the toolbox onto the Report canvas


Step 4: In the following dialog box, specify that you want to use a SQL Server spatial query


Step 5: Specify the connection to that data source


Step 6: Design your query. I made life easy for myself by creating a View, and letting the Report just use that.


Step 7: Choose to embed a Bing map into your report, and show the area you want to display. Full global view is fine for me.


Step 8: Choose a Basic map visualization. (You can rerun the wizard later if you want to try out something else)


Step 9: Specify some last theme items, including whether you want to display labels next to your points on the map.


Step 10: That’s all. No go to the ‘Preview’ tab to see how it looks.



4 thoughts on “Maps in SQL Server 2012 Reporting Services

  1. Have you been able to configure SSRS 2012 to get access bing via a proxy? I was able to do it in 2008, but can’t now…

    1. I’m not sure what the proxy issue would be. Presumably the security has been strengthened for 2012…

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s