使用SQL Server 2014,我有SSRS报告连接到Microsoft SharePoint列表 . 查询看起来像:

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ListName>Journaltasks</ListName>
  <ViewFields>
    <FieldRef Name="Title" />
    <FieldRef Name="Status" />
    <FieldRef Name="Project" />
  </ViewFields>
  <Query>
    <Where><Membership Type='SPGroup' ID='15'><FieldRef Name='AssignedTo'/></Membership></Where>
  </Query>
</RSSharePointList>

查询的部分值 15 ,我需要在报表参数 ReportGroupID 的值上更改它 . 希望有关此xml查询语法的帮助 .