Implementing SSRS Reports from SharePoint Server 2007 List Data

  • Article

There are three fundamental methods for implementing reports against SharePoint Server (MOSS) 2007 list data: direct MOSS table query, web service query, and finally third party tools which implement the web service interfaces. Although the direct table query of the MOSS database structures might seem like the easy answer, the tables and relationships within MOSS are quite complex, and thus the effort to create such a direct report is not suggested. This leaves the web service implementation…either called from your own Reporting Services queries, or called indirectly through your Reporting Services queries which leverage 3rd party tools. The choice becomes a matter of build versus buy…depending upon the level of developer experience and available funds for 3rd party tool’s purchase(s).

The following links describe the three various methods for MOSS list reporting using Reporting Services 2005.

* Query directly against MOSS databases

* https://www.mssqltips.com/tip.asp?tip=1323

* Query using MOSS web services

* https://www.teuntostring.net/blog/2006/03/update-reporting-over-sharepoint-lists.html

* Query using 3rd party tools for data extensions (Enesys)

* https://www.enesyssoftware.com/Products/EnesysRSDataExtension/Overview/tabid/72/language/en-US/Default.aspx