We Were Dead Before the Ship Even Sank (SSRS Reports on SharePoint Lists)


Now that we have released the SSRS integration in MOSS 2007 / WSS in SQL Server 2005 Service Pack 2, people often ask whether they can build reports against data in SharePoint lists. Although this functionality is not built into SSRS, if you are willing to go pick up a 3rd party component, I have heard of several customers successfully using the Enesys RS data extension for SharePoint lists. If you want to go down the free software path, you might also check out this blog from Teun Duynstee. We will consider native support for lists in a future release.

Comments (6)

  1. Eric says:

    It’s worse than you would ever know. With this, my plans for my SharePoint dashboard melted.

  2. Mark says:

    Should’t you be able to access those lists through the sharepoint web services?

  3. bwelcker says:

    Reporting Services works via ADO.NET. You can use the XML data extension in SSRS but it is awkward because of the lack of schema and design experience for the lists.

  4. Pete N says:

    I think the approach described here is viable:

    https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=472842&SiteID=1

    You can get the list data by calling GetListItems method.

  5. Last week I attended TechEd in Orlando, Florida . Here are my thoughts on the event. This year was TechEd’s

  6. Bob_Chauvin says:

    I report on WSS lists by creating a view to the userdata table and filter for the form type I am interested in.  I have to build the view with useful column names, but it works great!

    This also works for InfoPath form libraries on WSS when you promote form fields to WSS colunms.

    Not perfect:  If I move the library, the column names may get changed and so the view needs to be reworked.