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: Wednesday, August 24, 2016 8:02 AM
Points: 9, Visits: 122
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: Yesterday @ 9:55 AM
Points: 397, Visits: 1,135
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: Wednesday, August 24, 2016 8:02 AM
Points: 9, Visits: 122
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: Yesterday @ 9:55 AM
Points: 397, Visits: 1,135
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, September 22, 2016 10:02 AM
Points: 117, Visits: 1,285
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