Reporting on SharePoint Lists

Reporting Services

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 
</div>

<Query>  
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>  
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">  
<Parameters>  
<Parameter Name="listName">  
<DefaultValue>SharePoint List Name</DefaultValue>  
</Parameter>  
</Parameters>  
</Method>  
<ElementPath IgnoreNamespaces="True">*</ElementPath>  
</Query>
  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