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

  • Article

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

  • Anonymous
    March 13, 2007
    It's worse than you would ever know. With this, my plans for my SharePoint dashboard melted.
  • Anonymous
    March 14, 2007
    Should't you be able to access those lists through the sharepoint web services?
  • Anonymous
    March 19, 2007
    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.
  • Anonymous
    June 03, 2007
    I think the approach described here is viable:https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=472842&SiteID=1You can get the list data by calling GetListItems method.
  • Anonymous
    June 16, 2007
    Last week I attended TechEd in Orlando, Florida . Here are my thoughts on the event. This year was TechEd's
  • Anonymous
    September 11, 2007
    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.