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
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.