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.

 

 

Advertisements

4 thoughts on “Maps in SQL Server 2012 Reporting Services

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s