Posts with label SQL Server 2012

SSRS. List distinct values from a SharePoint list

Monday, July 2, 2012

If you create reports using Report Builder or BIDS it's avaiblable to use SharePoint list or document library as a DataSource. To retrieve data in this case CAML query is used, thus there is no direct way to get only distinct values from DataSet.

And such is the need at least to fill parameter values: