Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Reporting on spatial data in SQL Server 2008 R2

Reporting on spatial data in SQL Server 2008 R2

  • Comments 2
  • Likes

Report Builder 3 the latest version of the end user reporting tool in SQL Server 2008 R2  has built in support for Bing Maps and you can try this for yourself in the November CTP.

To help you along I have posted a 9 minute screencast to TechNet Edge and published a step by step guide here.  BTW don’t worry if you haven’t got any spatial data to hand as I have included guidance on how to get some.

My example simply shows the attendance at a few SQL Server events in the UK that I have been to..

image

..and is actually very straightforward. So an easy way to impress your boss or users in the many organisations that are becoming interested in understanding where things are happening.

Addendum 27th November.

I have just found out that you don't need to license Bing Maps if you you use Reporting Services as I have done here, i.e. for either aerial or the road view.  However you would have to have a license if you used Bing Maps in any other way outside of reporting services for business use.

You can access the license agreement for Bing Maps through the map control when you add the Bing Maps layer on a report  

Comments
  • This looks great - i had a go at it on friday, and managed to plot points from my data, but couldn't get the bing layer to work.. I kept getting HTTP Status 417 messages instead of the bing background.  Any quick suggestions on what might be going wrong?

  • Rich

    a couple of thoughts...

    I assume you can get to bing maps from where you are desining the report. You can embed the bing map once you have connected for other users who might not be conected when they run your report.

    I had trouble at SQLBits and preparing this with permissions around the spaital dataaset. So I deliberatley didn't create a shared dataset for this.  

    Andrew

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment