SSRS Multivalue Parameter with SharePoint Datasource
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!,
Justin
August 9th, 2011 9:51pm
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.
Thanks,
Sharp
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
August 11th, 2011 3:17am