Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Create CNN-style Map in Reporting Services Expand / Collapse
Author
Message
Posted Friday, June 1, 2012 12:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 21, 2015 7:28 AM
Points: 9, Visits: 121
Please refer to my post. You should have two fields added to tl_2008_us_state: BoundaryGeom (GEOMETRY) and BoundaryGeog (GEOGRAPHY).
Post #1309927
Posted Friday, June 1, 2012 12:49 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 14, 2016 10:39 AM
Points: 395, Visits: 1,121
I do not have those two. I see the add column statement for BoundaryGeog but nothing that either renames, drops and adds, etc BoundaryGeoM

Cheers
Post #1309931
Posted Friday, June 1, 2012 12:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 21, 2015 7:28 AM
Points: 9, Visits: 121
See screenshot in step 2, lower right panel, I named Geometry name as BoundaryGeom.
Post #1309937
Posted Friday, June 1, 2012 1:01 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 14, 2016 10:39 AM
Points: 395, Visits: 1,121
Ah! Now I see it. I didn't catch that when importing the shape file. I left geom as the default.

Cheers
Post #1309941
Posted Saturday, June 2, 2012 12:35 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 7, 2016 4:09 AM
Points: 109, Visits: 1,232
I'm try to do something similiar and going through this article, line by line, has given me a lot of ideas. It's excellent and helps a lot. Thanks
Post #1310122
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse