2

I am generating SSRS reports using SharePoint list and using below Caml query in my dataset.

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
                                          xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <ListName>Test_FAMM</ListName>
    <ViewFields>
       <FieldRef Name="Region" />
    </ViewFields>
</RSSharePointList>

However, I want to get only distinct values of the parameter. Any modification?

HaveNoDisplayName
  • 8,291
  • 106
  • 37
  • 47
Aquarius24
  • 1,806
  • 6
  • 33
  • 61

1 Answers1

0

Unfortunately, CAML doesn't allow use of DISTINCT. There are a couple of workarounds that you may be able to use.

See: https://sharepoint.stackexchange.com/questions/77988/caml-query-on-sharepoint-list-without-duplicates

Or: What is the best way to retrieve distinct / unique values using SPQuery?

Community
  • 1
  • 1
Hannover Fist
  • 10,393
  • 1
  • 18
  • 39