Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, November 5, 2014 10:56 AM
Points: 9, Visits: 102
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 @ 12:55 PM
Points: 372, Visits: 989
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, November 5, 2014 10:56 AM
Points: 9, Visits: 102
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 @ 12:55 PM
Points: 372, Visits: 989
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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 5:57 PM
Points: 82, Visits: 1,026
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