SSRS Multivalue Parameter with SharePoint Datasource RRS feed

  • Question

  • I am building a report with a SharePoint data source.  I want two parameters to be dynamic with the ability to select multiple values: Region and Business Line.  I don't know how to do a Select Distint from the SharePoint list to have the parameters pull from a query.  I also have not been able to select mulitple values for the parameters if I am using SharePoint as the data source.  Someone recommended creating a calculated column in the SharePoint list, but that gives me the same result as if I just used the field itself. 

    Your help is appreciated!,


    Tuesday, August 9, 2011 6:51 PM


  • Hi JC-DFW,

    Thanks for posting your question here.

    If I understand your requirement correctly, you used SharePoint list as the DataSource of your report, currently, you would like to get distinct values of the list column as one parameter’s available values.

    By default, the CAML language doesn’t have any reserved word (or tag) to set this particular filter to remove duplicate results. To work around this, we could use the custom code to get distinct records.

    You can get the detail information and steps from this thread: How to get distinct values of sharepoint column using SSRS.

    Hope it helps you. If the issue still exists, please let me know.


    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    • Proposed as answer by Sharp Wang Wednesday, August 17, 2011 5:10 AM
    • Marked as answer by Elvis Long Thursday, August 18, 2011 10:55 AM
    Thursday, August 11, 2011 7:10 AM