MultiValue not working.

[Phillip Foster]

I have a simple report that is simply pulling the data from a SQL db and displaying it on the report. 

the qry is something like 

select name,title,number,address from table1 where name in (@values)

I then created a new parameter, that pulls the potential options from the database, the qry is something like 
select distinct (name) from table1


When i preview the report, the values are in the drop down list, but when i select any and hit preview, I get 0 results. 


if i change the query to be 
select name,title,number,address from table1 where name = @values
(and only select one value) it does return results. 


Suggestions on what would cause this behavior?

[Steve]

Hi Phillip,

Everything looks as it should, only two things are not clear:

1. Did you set the MultiValue property of the report parameter to True
2. Did you set the report parameter as Value for the data source parameter?

Detailed instructions on what you're trying to do are available in the Using Multivalue Parameters help article.

All the best,
Steve
the Telerik team