SQL Server 2008 R2 August CTP includes map visualization functionality in Reporting Services, as briefly described yesterday. In this posting, I’m going to provide an introduction of how to use spatial data and Bing Maps with Reporting Services Maps.
The attachment of this posting includes the final report so you can try it out yourself in Report Builder 3.0. The data source for the report is the Person.Address table in the AdventureWorks2008 sample database (download) which includes a geospatial column.
The report scenario is about showing the addresses of all your customers in the Los Angeles area. Accomplishing this requires just a few steps in Report Builder 3.0, and you don’t even need to write a single RDL expression! Btw, I will cover some of the new interesting spatial functions added to the RDL expression language in another posting.
Let’s start with the screenshot of the final map visualization of this report:
Of course, you can do a lot more with Map and the geospatial data integration in the RDL expression language – I’ll cover this in upcoming postings.