SpatialLocation in sample AW database to create map report
Hi. I am starting to explore maps in Report Builder 3.0. I have looked at http://denglishbi.wordpress.com/2009/08/12/mapping-data-with-ssrs-2008-r2/ and managed to create the first type of map. However, I can not manage to find any SpatialLocation field anywhere. I downloaded the sample databases (AdventureWorks) from http://msftdbprodsamples.codeplex.com/releases/view/45907. Is there something that needs to be done in order to create a spatial field (if so, what?) or should it be there? What am I missing? Thanks.
October 18th, 2010 4:40pm

However, I can not manage to find any SpatialLocation field anywhere. I downloaded the sample databases (AdventureWorks) For spatial sample data you need AdventureWorks2008 or AdventureWorks2008R2. Example for table with SpatialLocation: CREATE TABLE [Person].[Address]( [AddressID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL PRIMARY KEY, [AddressLine1] [nvarchar](60) NOT NULL, [AddressLine2] [nvarchar](60) NULL, [City] [nvarchar](30) NOT NULL, [StateProvinceID] [int] NOT NULL, [PostalCode] [nvarchar](15) NOT NULL, [SpatialLocation] [geography] NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL) Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2010 5:18pm

Thanks for the reply. I´m wondering what I´m missing. The database should be included in the AdventureWorks2008R2_RTM installation, right? Yesterday I had three AW databases but I could not find any spatial field anywhere. If installing again, which database are we talking about? http://www.kodyaz.com/images/sql/sql-server-2008-r2-sample-databases-installation-2.PNG I currently only have the AdventureWorksDW2008R2 but that doesn't seem to be it.
October 19th, 2010 10:59am

Try AdventureWorks2008R2.Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2010 11:44am

Hi Marcus84, Please try this sample(SQL Server 2008 SR4): http://msftdbprodsamples.codeplex.com/releases/view/37109 Thanks, Jin ChenJin Chen - MSFT
October 20th, 2010 11:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics