4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

You can create UK maps with SSRS 2008 R2.

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

  • Downloads
  • SpeakerBIO
    I Started in the IT industry working as a land surveyor with Unix ( Sun OS)  back in  late eightes ,   Then moved on to support Microsoft products first supporting Windows NT4 & Windows 95 ; on to qualify as a Microsoft Trainer;  Microsoft Certified system engineer  and Red Hat certified engineer.



    The mix of both has served me well and  I  seemed happy in my Role. Untill I was lucky enought to attened a training course with A SQL MVP in early part of 2000. Since then I have grown in my appreciation of reporting services and what it can visually do for data.


    I am currently pasionate aboout SSRS 2008 R2/ SQL Azure / SQL 2012  mapping 

    This product combines the mapping from my early days in IT with passion I witnessed in a SQL MVP.







    http://edgsonrobert.wordpress.com/
  • Video