So I've installed the SQL Server 2008 November CTP and I was hoping to be able to create some reports that I saw at TechEd with the bubbles on the map etc...How would I go about doing this? I have data in my SQL Server that corresponds to a geography dimension... so I have customers that have customer ID's and I have Countries and Cities tied to those customers. I want to be able to map volume on a map similar to how Microsoft MapPoint works.Does anyone know how to do this with SQL Server 2008 Reporting Services?Thanks in advance from a SQL Server 2008 Newb.Letni

SQL Server 2008 will not contain the map report items at RTM. We are investigating including this functionality for future releases. Right now, the only way to create these reports will be using SQL Server 2005 and the Dundas Map control for Reporting Services. -Sean

Wow, that's a real bummer! Any word if there will be a seperate fee to purchase this functionality from Dundas if Microsoft already paid for it... and thus we paid for it by purchasing SQL Server 2008? Thanks for the info!

Its actually not as bad as you would think. I have evaluated the Dundas products andin all honesty Dundas maps for ASP.NET with linked imagesis a much better solution. John

In CTP6 we are adding support for the 2005 Custom Report Item interfaces. As such, you can purchase a Map control from Dundas or other another visualization control vendor.I understand where you're going with the'already paid for'argument, however there's no such deal to be had. Take care and good luck, -Lukasz

Did support for 2005 CRIs make it into CTP6? I can't see it mentioned in the 'What's New' section. I already have a licenced copy of Dundas Maps for RS (2005), so I'm trying to add this component into Visual Studio 2008 CTP6, but not having much luck....

The 2005-style CRIs will only be supported ona RS 2008report server at runtime, starting with the next CTP after CTP6. You will still need to design your Dundas Maps for RS reports in BIDS (BI Development Studio)2005. The old CRI interfaces won't be supported in BIDS 2008. -- Robert

The following should help out:How to make a spatial database: http://www.youtube.com/watch?v=BtnW5hyzStgSQL 2008: Add Maps in reports:http://www.youtube.com/watch?v=zHwi_Q6Jhb8Add Bing Maps in reports: http://www.youtube.com/watch?v=_KziCH0Qm0U[citation needed]

Is there a way to mimic the zoom in and zoom out in the Map (SSRS 2008 R2) - Right now I have a CA Map with customers... if I zoomed in, i would like to see the map break down into categories, cities, zip code, etc, right now, the map is just the state of CA