I have an issue where I have the Dataset declared that contains all values and I would like to have the values that are in a list that is located on SharePoint be the "Default" values that are displayed. For example, I would like to take the Client Dashboard and have a report that shows a subset of values based on the list of sites that is located on SharePoint. I can get the values from the SharePoint List, however cannot use that value to limit the content shown. I would like to have this be a repeatable process as we have over 1500 sites and would like to create report templates based on those lists - example Region 1 has these 50 Symantec Sites, Region 2 has these 50 sites and so on... The lists would exist in SharePoint so that I can easily modify the data.
Thoughts? Thank you!