none
Use GEOGRAPHY in SSRS

    Question

  • I am starting to build some maps in SSRS and I have been able to pull shape data from a database and display it in SSRS.

    Now I want to add a layer to that map so I...

    right click > Map > Add Layer > 

    at this point it asks if I want to use a ESRI shapefile...

    I select this option > browse to my shapefile and...

    get an error that says "Length of the field of type C is 255"

    Im not sure what this means? any help is greatly appreciated!

    Wednesday, March 20, 2013 4:50 PM

Answers

  • Hi l have been importing shape files into SQL 2012 geography data fields.  Once get the data file from our client l open then using Quantum GIS (http://www.qgis.org/) when l export to a shape file Quantum GIS creates both .shp and .dbf files.  Then l use http://www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx to import the shape file, into a table.

    I can then use the geography data field in a Map Polygon layer to display the data on the map control.


    Friday, March 22, 2013 2:49 PM

All replies

  • Hi Tjunky,

    To use spatial data from an ESRI file dynamically, you must do the following:

    • In Report Builder 3.0, upload both the .shp file and the .dbf file to the same folder on a report server, and then link to the .shp file as the spatial data source.
    • In Report Designer in Business Intelligence Development Studio, add both the .shp file and the .dbf file to the report project, and then specify the name of the .shp file as the spatial data source.

    Reference: Add, Change, or Delete a Map or Map Layer (Report Builder 3.0 and SSRS)

    Hope this helps.

    Regards,
    Charlie Liao

    If you have any feedback on our support, please click here.  


    Charlie Liao
    TechNet Community Support

    Thursday, March 21, 2013 2:10 AM
    Moderator
  • This doesn't answer the question of why my shape file...that I use in other applications and works fine is giving me an error.

    My hunch is that SSRS is not GEOGRAPHY friendly and the shape file needs to be created with the shape being GEOMETRY, can anyone??? confirm this? 

    Friday, March 22, 2013 12:27 PM
  • Hi l have been importing shape files into SQL 2012 geography data fields.  Once get the data file from our client l open then using Quantum GIS (http://www.qgis.org/) when l export to a shape file Quantum GIS creates both .shp and .dbf files.  Then l use http://www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx to import the shape file, into a table.

    I can then use the geography data field in a Map Polygon layer to display the data on the map control.


    Friday, March 22, 2013 2:49 PM