Multi value parameters with the 'IN' query.

See more:

SSRS

Hi,

I have an SSRS report with @Region as a parameter used for filtering values as per the region.

The @Region parameter can take the following values :

Americas
Africa
Asia-Pac

The report works fine if the user chooses Americas or Africa but if the user chooses
Asia-Pac, the report shows no data as the actual value for Asia-Pac is
'Asia','Japan','Australia'. i.e. for the parameter label as Asia-Pac I am setting the value for the parameter as 'Asia','Japan','Australia'.

My query used for populating the dataset is :

select * from myTable where Region in (@Region)

Any help would be much appreciated.