Answered by:
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.
Question
Answers
-
Try AdventureWorks2008R2.
Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM- Marked as answer by Marcus84 Wednesday, October 20, 2010 11:17 AM
All replies
-
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 -
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.
-
Try AdventureWorks2008R2.
Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM- Marked as answer by Marcus84 Wednesday, October 20, 2010 11:17 AM
-
Hi Marcus84,
Please try this sample(SQL Server 2008 SR4):
http://msftdbprodsamples.codeplex.com/releases/view/37109Thanks,
Jin Chen
Jin Chen - MSFT