Implementing SSRS Reports from SharePoint Server 2007 List Data

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 3^rd party tools. The choice becomes a matter of build versus buy…depending upon the level of developer experience and available funds for 3^rd 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 3^rd party tools for data extensions (Enesys)

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

Comments

• Anonymous
  March 26, 2009
  another intresting method is to use datasources against sharepoint list web services, i described this method in this blog post: http://blogs.msdn.com/mutaz/archive/2008/06/07/reporting-services-and-wss-lists.aspx