<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Reporting Services
»
Reporting Services 2005 Development
»
SSRS 2008 with Dundas Maps
SSRS 2008 with Dundas Maps
Rate Topic
Display Mode
Topic Options
Author
Message
cmickley
cmickley
Posted Thursday, May 21, 2009 6:33 AM
Grasshopper
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 12:56 PM
Points: 18,
Visits: 88
I'm trying to get Dundas Maps to work with SSRS2008. The map component integrates just fine, but I am having trouble getting data to bind to the maps. I am working with just simple Zipcode data, that includes County and State. Just a single sales value in Dollars and Qty per County for the state of MD. Has anyone used this functionality?
Thanks
Charles
Post #721267
Samuel Vella
Samuel Vella
Posted Thursday, May 21, 2009 6:59 AM
Old Hand
Group: General Forum Members
Last Login: Saturday, June 15, 2013 10:38 AM
Points: 329,
Visits: 1,869
A few notes first
Dundas maps uses shapefiles to define areas within the map.
If you open the map properties, click the advanced tab, you should see the shape objects in the drop down box
Check that the name of each shape object corresponds to the values in your database. You don't want to and can't match "NY" to "New York State"
You'll also need to make sure that you have the relavent shape files loaded.
I'm based in the UK and all we get with dundas maps is Scotland, England and Wales (for the mainland), there is nothing at a lower lever than that.
I managed to dig out a free source for the English counties, however at postcode (zipcode) level there are no free resources and so I've not been able to experiement at that level. However I can assure you that loading shape files for that fine a grain will be problematic!
To bind data to the shapefiles
In the data tab you'll need to
specify the dataset name - this being the report dataset
specify the fields and do any manipulation on the values, e.g. rounding decimals down to 2 places
Set the row groupings - as you would with a regular SSRS chart
Set the binding field - this is the column name you specified in Fields which will bind to the Name property of the map shape.
Post #721292
cmickley
cmickley
Posted Thursday, May 21, 2009 8:13 AM
Grasshopper
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 12:56 PM
Points: 18,
Visits: 88
Hey Samuel, thanks for the info. I can after selecting US, I can then select the State (ie: Maryland), then I have the ability to map by County in the State of Maryland, so I do have the ability to get to the granular level, so I am assuming I should be able to map my Zipcode data, that I have ZipCode, County, City, and State, so I should be able to bind the County Data to Counties on the Map.
Do you have any other Mapping controls you can recommend? I was looking at Microsoft's MapPoint, but no sold on that yet, from a SSRS standpoint. It works great as a one time data export.
Thanks
Charles
Post #721371
Samuel Vella
Samuel Vella
Posted Thursday, May 21, 2009 8:47 AM
Old Hand
Group: General Forum Members
Last Login: Saturday, June 15, 2013 10:38 AM
Points: 329,
Visits: 1,869
I've not used any other mapping controls.
When I get a chance I really want to have a proper play with google and the windows live mapping. Neither of those plug into SSRS but they both have well developed API's which should allow for quite a rich user experience.
Post #721397
cmickley
cmickley
Posted Thursday, May 21, 2009 8:53 AM
Grasshopper
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 12:56 PM
Points: 18,
Visits: 88
OK, thanks! I have an email to Dundas tech support, and they said they would help me through building what I need.
I will LYK if we get this worked out.
Post #721401
Samuel Vella
Samuel Vella
Posted Thursday, May 21, 2009 8:58 AM
Old Hand
Group: General Forum Members
Last Login: Saturday, June 15, 2013 10:38 AM
Points: 329,
Visits: 1,869
cmickley (5/21/2009)
OK, thanks! I have an email to Dundas tech support, and they said they would help me through building what I need.
I will LYK if we get this worked out.
I can email you a working example if what I told you didn't get the results
Post #721407
cmickley
cmickley
Posted Thursday, May 21, 2009 9:03 AM
Grasshopper
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 12:56 PM
Points: 18,
Visits: 88
hey that would be great!
Post #721415
Samuel Vella
Samuel Vella
Posted Thursday, May 21, 2009 9:09 AM
Old Hand
Group: General Forum Members
Last Login: Saturday, June 15, 2013 10:38 AM
Points: 329,
Visits: 1,869
On it's way
You can edit that post to take your email address out now
Post #721423
cmickley
cmickley
Posted Thursday, May 21, 2009 9:24 AM
Grasshopper
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 12:56 PM
Points: 18,
Visits: 88
yea, got it... working on it... I am finding that the format of the SQL is kind of NOT user friendly to be able to integrate lots of reports... not sure why I need to format the SQL to get data to find correctly. Working on it though.
Post #721440
Lidou123
Lidou123
Posted Friday, January 25, 2013 2:42 PM
SSC Rookie
Group: General Forum Members
Last Login: Sunday, June 16, 2013 8:22 AM
Points: 47,
Visits: 168
Hi All,
Very interesting post.
So I wanna know more about Dundas Map ?
How can I use it with SSRS 2008R2. And is it free ?
Thank U
Post #1411936
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
