SQLBits 2010

You can create UK maps with SSRS 2008 R2

Corporate data is expensive to create, expensive to report. Adding free data sources and mapping can lift the simplest of reports to a stunning presentation.
The Presentation will take the simplest export to excel report then combine the Ordnance survey open data with RS 2008 R2 to create an interactive visual map report.
“http://www.ordnancesurvey.co.uk/oswebsite/opendata/”
What types of data is available
UK Open data provides the back bone to the Geo – Coding to provide a post code to latitude and longitude translation.
An introduction to spatial data types and why the UK open data does not plot natively to Bing maps.
Demo data types
An introduction to the new Mapping features
 Demo new mapping features
Linking mapping data to corporate data
 Demo linking data
Creating your report 
 Demo combining mapping and open data
All of that done on SQL 2008 R2  express
Creating your own UK report  templates