Reporting on SharePoint Lists

You can do Reporting on SharePoint Lists with SQL Server Reporting Services 2005 quite easy.

  1. Configure the Datasource with integrated Security
  2. Define a query like

<Method Namespace="" Name="GetListItems">  
<Parameter Name="listName">  
<DefaultValue>SharePoint List Name</DefaultValue>  
<ElementPath IgnoreNamespaces="True">*</ElementPath>  
  1. Hit the “Field Refresh” Button to get the Field from your SharePoint List
  2. Drag your Fields in the Report
  3. Use the Code to eliminate “ID;#” and “
    " from your Fields

    Use “=Code.CuttOff(Fields!ows_LinkTitle.Value)” in your Report to display your Fields