I want to have  a three parameters cascade which I would like to pass on the store proc ot just the last paramter of the cascade but the three parameters. So I can use the first parameter or the second parameter in my stored proc depending on the users choice to see all the info from the first paramter or the second or the thirs paramater.

 

Exemple if I have country, region and city. If the user decides to see information at the country level he would only select  the country from the list and no selection of region and city and the stored proc would get all info on country only. So is there a way to transfer only the the country to the store proc. I have tried many things but did not find a way to do this.

 

Thanks to whom will respond.

I want to have a cascade parameters so the first parameter selected is a country and reduces the list of the second parameter which is the region so I can select the second parameter including only the region within the country. That what casacde parameter is all about. But let say my user wants to see all info for country Canada and does not want to see the info of a region within the Canada country. The user would select Canada in the country parameter and would not select any region on the second parameter. I want the country parameter sent to my store proc and no value for the region parameter. What I see from the cascade parameter is that it is is only returning the bottom of the line parameter which in this case is the region parameter and the value return is null in this case.  I want to have the option to sent back both parameters to my stored proc. Is there a way to do this with the cascade parameter. I don't want to have two seperate parameters with no cascade on them. Thanks