Hello every one, Thanks for your reply, but already I have done changes as you said( Advanced Tab--> Click on Always Refresh). At run time if I am going to select the Country code as first parameter value then corresponding State value populates as second parameter value with unCheck option. But I need while selecting the Country code it should be populates State value with Check option. Please advice me how to fix this issue. Thanks Guru.

Go to parameter Advanced Tab-->Click on Always Refresh.Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://mycubeandreports.blogspot.com/

Hi, Are you getting list of states on passing conutry as a input parameter to the qurey. If you are doing that their should not be any problem. If any other query then revert back...Ravi Patil

Hi gurunadh, Based on your environment, please check the query and ensure that you can get available values for the second parameter which is based on the first parameter value. If possible, you can try to create simple cascading parameters in your report. For more information about How to: Add Cascading Parameters to a Report (Reporting Services), please refer to the article below: http://msdn.microsoft.com/en-us/library/aa337169(v=sql.100).aspx If you have any question, please feel free to ask. Thanks, Bin Long