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 01, 2012 12:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 07, 2014 8:46 AM
Points: 9, Visits: 91
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 01, 2012 12:49 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:55 PM
Points: 349, Visits: 904
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 01, 2012 12:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 07, 2014 8:46 AM
Points: 9, Visits: 91
See screenshot in step 2, lower right panel, I named Geometry name as BoundaryGeom.
Post #1309937
Posted Friday, June 01, 2012 1:01 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:55 PM
Points: 349, Visits: 904
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 02, 2012 12:35 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 4:27 PM
Points: 65, Visits: 922
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