How to multiselect one field and based on the selection we need to multiselect second field in SSRS

[Anonymous]

Hi Team,

I want to use mutiselect in one parameter based on this selection, I want the next parameter to filter the value, 2nd parameter will be also be multiselect in SSRS Reporting.

Example:

In Continent I'm selecting: Asia, North America  // 1st Parameter

For next Parameter, I should get country of only these 2 continent. There also I want multiselect, Let say

In Country I'm selecting: India,USA,canada

Thanks..  

[FarhanAhmed · Accepted solution]

A parameter can be multiselect or single. I cannot be both depending on selections.

For the second parameter you need to pass 1st parameter value to 2nd Parameter's Dataset and then you will get he filtered values for your dataset. and then on parameters properties select 'Allow multiple values'