Geography data types would be more precise over long distances as the earth is actually spherical, but it would require more overhead in setting up the spatial data as additional parameters have to be provided to account for the roundness of the earth. Depending on your application, you can choose between the two data types for your spatial purposes. Geometry imagines that the world is a flat rectangle while Geography takes the curvature of the spherical earth into account. This chapter will introduce you to the basic concepts involved in map reports and then take you through some of the common scenarios involved while building map reports.ġ) Geometry and Geography: These are the two spatial data types that are available in SQL Server 2008 and above. However, they are usually a grey box for developers and hence, not been used to their full potential in most of the organizations. So here it goes:- Map reports have been a part of SQL Server Reporting Services from SSRS 2008 R2. I thought it might be useful to those who are looking to explore map reports in SSRS. I was going through some of my old documents and found this article on map reports which I had written for a SSRS book (which didn’t go through because of some time related issues).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |