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