Reporting Services Reports - Map Functionality
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
January 8th, 2008 12:10am

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
Free Windows Admin Tool Kit Click here and download it now
January 14th, 2008 11:43pm

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!
January 15th, 2008 12:14am

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
Free Windows Admin Tool Kit Click here and download it now
January 15th, 2008 6:57am

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
February 3rd, 2008 6:19am

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....
Free Windows Admin Tool Kit Click here and download it now
March 7th, 2008 4:57pm

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
March 11th, 2008 5:53am

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]
Free Windows Admin Tool Kit Click here and download it now
August 19th, 2009 3:14pm

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
November 15th, 2010 11:34am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics