How to filter a SharePoint list using a CAML query?

Question

I am doing SSRS to retrieve data from two SharePoint lists. One of them is the viewing part, and the other is for the filtering part. This is easy to do in the SQLServer Data Source database, but how can this be done using SharePoint lists?

Below is my query: @name is a report parameter obtained from another list.

    <Query>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
        <Parameters>
            <Parameter Name="listName">
                <DefaultValue>{D5D33A07-D1CA-440F-8A6B-912B9CE5BB2F}</DefaultValue>
            </Parameter>
            <Parameter Name="rowLimit">
                <DefaultValue>9999</DefaultValue>
            </Parameter>
            <Parameter Name="viewName">
                <DefaultValue>{F5459664-7C2F-4618-81FC-F2275FB2FBCF}</DefaultValue>
            </Parameter>
        </Parameters>
</Method>
<Where>
     <Eq>
         <FieldRef Name='ows_Firstname' />
         <Value Type='Text'>@name</Value>
     </Eq>
</Where>
    <ElementPath IgnoreNamespaces="true">GetListItemsResponse/GetListItemsResult/listitems/data/row{@ows_EmployeeID,@ows_Firstname,@ows_Lastname,@ows_Department}</ElementPath> 
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
</Query>

Please, help.

Answer 1

Jane, you have two options:

• SQL Server 2008 R2 ships with the Sharepoint list connection type (see the link for the tutorial) , where the connection is as simple as using an SQL data source.

• , - SharePoint ( , lists.asmx) XML-. . : SQL Reporting Services SharePoint.

Answer 2

:

SOAP- (SSRS, Sharepoint)