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

Tuesday, March 13, 2007 8:11 PM bwelcker

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.

Filed under: SharePoint, Reporting Services

Comments

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

Wednesday, March 14, 2007 1:48 AM by Eric

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

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

Wednesday, March 14, 2007 3:24 PM by Mark

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

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

Monday, March 19, 2007 8:06 PM by bwelcker

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.

# When I Was Born for the 7th Time (Thoughts from TechEd)

Saturday, June 16, 2007 3:14 PM by Direct Reports (Brian Welcker's Weblog)

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

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

Tuesday, September 11, 2007 3:41 PM by Bob_Chauvin

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.

Anonymous comments are disabled

Direct Reports

Search

Tags

Archives

Related Blogs

Reporting Services Resources

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

Comments

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

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

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

# When I Was Born for the 7th Time (Thoughts from TechEd)

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