THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.

Exploding maps in Reporting Services 2008 R2 - T-SQL Tuesday #005


Well, that was the imagery that secretly appeared in my mind when I saw “USA By State Exploded” in the list of installed maps in Report Builder 3.0 – part of the spatial offering of SQL Server Reporting Server 2008 R2.


Alas, it just means that the borders are bigger. Clicking on it showed me.


Unfortunately, I’m not interested in maps of the US. None of my clients are there (at least, not yet – feel free to get in touch if you want to change this ‘feature’ of my company).

So instead, I’ve recently been getting hold of some data for Australian areas. I’ve just bought some PostCode shapes for South Australia, and will use this in demos for conferences and for showing clients how this kind of report can really impact their reporting.

One of the companies I was talking about getting shape files sent me a sample. So I chose the “ESRI shapefile” option you see above, and browsed to my file. It appeared in the window like this:

08-Apr-10 11-42-43 AM

Australians will immediately recognise this as the area around Wollongong, just south of Sydney. Well, apart from me. I didn’t. I had to put a Bing Maps layer behind it to work that out, but that’s not for this post.

The thing that I discovered was that if I selected the Exploded USA option (but without clicking Next), and then chose my shape file, then my area around Wollongong would be exploded too!



Huh! I think this is actually a bug, but a potentially useful one!

Some further investigation (involving creating two identical reports, one with this exploded view, one without), showed that the Exploded View is done by reducing the ScaleFactor property of the PolygonLayer in the map control. The Exploded version has it below 1. If you set to above one, your shapes overlap.


I discovered this by accident… I guess I hadn’t looked through all the PolygonLayer options to work out what they all do.

And because this post is about Reporting, it can qualify for this month’s T-SQL Tuesday, hosted by Aaron Nelson (@sqlvariant).

Published Tuesday, April 13, 2010 10:06 AM by Rob Farley

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Rob Farley said:

I’m giving a presentation on May 12th at the Adelaide .Net User Group, around the topic of spatial data,

May 10, 2010 11:57 PM

Rob Farley said:

Interestingly, my favourite new feature of SQL Server 2008 R2 isn’t any of the obvious things. 

June 7, 2010 8:09 PM

George Doubinski said:

"I’ve just bought some PostCode shapes for South Australia"

Rob, whatever you paid, it was too much. ABS has published some of the census data in SHP format:


January 30, 2011 9:52 PM

Rob Farley said:

Thanks George - good to know. I was happy to pay a small amount at the time, as I'd had no luck trying to find anyone who was publishing data like that, and it was cheap enough for me to not worry too much.

January 30, 2011 10:14 PM

Leave a Comment


This Blog



News? Haven't you read my blog?

My Company

Can't find something?

Contact Me

Twitter: @rob_farley
Skype: rob_farley

MVP (SQL Server)


Adelaide SQL UG

Privacy Statement