Working with Spatial Data Part III – Reporting Spatial data using Reports Builder 3.0

After completing these steps, the map control should be available in your report. Also, if you click on the map, you should be able to see the map layers on the right side as shown in the below screenshot. The geographical image that you can see in the control is the Tile Layer we selected and the data represented on this background is the Point Layer. Modify the Point Layer properties by right-clicking this layer and selecting “Point Properties”, and change the font color to white so that they are visible on the background. Also change the color of the star marker to red, so that they are visible clear and bold on the map.

After this is complete, it’s time to make the report accessible from the Report Manager. Save the report, and you would be prompted with the location to save the report. By default the location selected will be http://[machinename]/ReportServer if you have installed SSRS with the default settings in native mode. Save this report and name it “FamousBuildings.rdl”.

Navigate to the Report Manager and you should be able to see the report you just saved from Reports Builder. Generally, if you have installed
Report Server with the default settings, the URL of Report Manager should be similar to http://[machinename]/Reports/Pages/Folder.aspx. Open the report and if you have followed all the
above steps , you should be able to see a report as shown in the below screenshot.


Recapping from the first part of this series, we started with text based location information of some famous building across the globe. We then used SSIS and
the Bing Maps web services to geocode this data. Thereafter we plotted points on these locations and stored the same in a geography field. We then saw in this article how we can develop a report with a Bing Maps layer to represent geographical data on a map.

Pages: 1 2


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |