Embedding Map Data in Report Builder 3

OK now we have some data (see the 2 previous articles) we can now add a map using this spatial data to a report.

OK First open up report builder 3, you can download it from here

Open it and start a new project and select the "Map Wizard" option.

On the source screen select "SQL Server spatial query"

Next add a datasource with a connection to a table / view or Stored Proc that contains some spatial data.

Select the fields you want to view, these will almost certainly be labels under the points on the map, or in some cases bubble sizes on a map.

On the next screen the spatial data will be plotted, at this point you want to add a bing map overlay so select the "Add a bing layer" option and then watch the map appear along with your plotted data!!!

The next couple of screens are just layout screens for the map, you can then go ahead and add additional information to your now more professional report.