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 :
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.