Visualize Spatial Data in Reporting Service

Question

Is it possible to visualize a piece of geographical map from SQL server Spatial data (geometry, not geography) in a report from reporting service? If yes, how should it be done in a course of action.

A concrete example is to display the orange line from the Chinese subway's map in a specific reporting page.

Answer 1

Yes, depends on how you're hosting and serving you're service and how you are doing overlays of the orange line.

Answer 2

Use the advice given at the following address. Pay special attention to the part where it says 'Do NOT use the wizard'. Because do not use the wizard. no.

http://geekdeck.com/create-a-map-report-using-spatial-data-in-sql-server-2008-r2/

To summarize (Thanks Get Spatial!):

1. Create a new Report Server Project
2. Create a new report.
3. Drag a Map item from the Toolbox to the Design surface.
4. Select SQL Server spatial query and click Next
5. Select the Add a new dataset with SQL Server spatial data and click Next.

6. Click New, then:

   a. Set the data source’s name.

   b. Click Edit to open the Connections Properties dialog. Set the server name to “YourServer”” server alias and enter a Database Name.

7. In the Design a Query step, type a T-SQL statement which returns the route you are interested in. "Select X, Y FROM TableName WHERE RouteID = orangerouteID"