Post reply

Possible Data Source for SharePoint Lists?

  • October 18, 2004 at 9:29 am

    #109601

    Is there any way for Reporting Services to access a List maintained within a Windows SharePoint Services site?  WSS has a data retrieval service that Excel can connect to (the wizard sets up an XDBC data source), but I haven't seen such an option for RS Report Designer in Visual Studio.

    If that's not possible, can SQL Server import a SharePoint List (XML) and render it as a table that RS can access?

  • October 19, 2004 at 3:18 pm

    #527255

    Look at FrontPage 2003 and search for webparts in the help menu. Webparts are small pieces of code that you can drop on to your share point site. With the webpart create a query to your list and then export to a table that Reporting services has access to. The database that SharePoint services creates will give you a shared access problem if you try to use an a query from Data Mangager or any other GUI.

    Web Parts are becoming a very handing bit of code for SharePoint sites.

    Jim

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply