I have two parameters, lets say P1 and P2. P2 is cascaded with P1. P1 -> P2 For the parameter P2, the following proterty set are 1. Multi Select 2. The default value is all the available value selected (Same dataset is assigned to both "Available Values" and "Default Values") The data relation be, P1 P2 A a A b A c A d B a Now the issue is, Step 1 : When i choose A in P1 first time, a,b,c and d in P2 are selected Step 2 : When i change B in P1, a is selected Step 3 : When i change back to A in P1, only a is selected in P2 (a,b,c and d should be selected) Can someone please help me with this??Bunch of thanks ~ Deva ~ mark it as answer if it answered your question :)

Hi Devanathan, According to my observation, I found that the behavior happening only when the default value of a parameter is set based on another parameter’s value. This issue has already been submitted to Connect, you can vote to it through the link below: https://connect.microsoft.com/SQLServer/feedback/details/268032/default-does-not-get-refreshed-for-cascading-parameters#tabs thanks, Bill Lu

Thanks billu.. For those whoever viewing this thread. This issue is still exists till SQL SERVER 2008 R2 and the corresponding CONNECT thread is https://connect.microsoft.com/SQLServer/feedback/details/268032/default-does-not-get-refreshed-for-cascading-parameters#tabs if someone gets the answer, post it hereBunch of thanks ~ Deva ~ mark it as answer if it answered your question :)