Spatial Data in Reporting Services

• seiler.andreas

  SSC Journeyman

  Points: 93

  More actions

  March 28, 2011 at 11:46 am

  #234742

  Hello,

  I'm new in this forum and so am I to Microsoft BI. I tried to build a map report based on spatial data. I have a table with geography data. In Management Studio I can see the spatial data in the result of my select.

  But when I try to build a report SSRS keeps saying ... no spatial data available ... it seems quite strange because in Management Studio I see the data, so I assume the data is valid.

  I would appreciate any kind of help!

  Thank you very much,

  Andreas

• Andressa Martins

  Valued Member

  Points: 70

  More actions

  March 29, 2011 at 7:39 am

  #1304854

  Andreas,

  you need a geometry layer, try use a Shapefile or spatial data with a geometry column, after this you need create a layer with your geography column.

  Andressa Alves Martins
  http://sqlgo.wordpress.com/
  Twitter: Dre_Martins