Posts

Showing posts with the label Reports

How to use multi value paramter in SSRS Report for SharePoint 2010?

I wanted to create a report in which I have created a Parameter called "User Name" , Which shows all users from SharePoint list. Now I marked this parameter as Multi value selector. But I am not able to use values of this parameter in SSRS report because this report uses CAML Query not SQL query. When I select 1 or more users and click on 'View Report' button. It gives me an error : Cannot add multi value query parameter 'Users' for dataset 'TSADataSet' because it is not supported by the data extension. (rsErrorAddingMultiValueQueryParameter) So I used this parameter in filter option of Data Set. Now it is working fine. I just followed these steps : Create multi-value parameter as you want. Right click to ā€œ your dataset ā€ then click on ā€œ Dataset Properties ā€. In Dataset property form, Click on ā€œFiltersā€ and add expression (Field) then select Operator (Select ā€œInā€ operator in case of multivalue parameter) then select value (Click on form...