SSRS with XML SharePoint Dataset Parameter with multiple values error

0
votes

I'm trying to add Allow Multi Values option to existing working report and getting this error Multiple selection not valid ..Because it's not supported by the data extension.

  • Data source = Microsoft SharePoint List

I first time work with the report where Dataset is actual XML schema, so I see that this parameter set in Filter option. I pasted all info in below, not sure if this will work. I'm on SSRS 2014 with most recent updates. not sure if expression will help.

screenshot1 screenshot2
screenshot3 screenshot4

1
xmlreporting-servicesssrs-2012sharepoint-list
I think for me good alternative would be to save data in table, is it possible you think with embedded sql or sp ?? - Mike S

1 Answers

1
votes

The multiple value parameter is not supported by the data extension, as per the error in the page.

However, you can filter the tablix with the multiple value parameter.

tablix filter