I have 4 drop down list Cascading Parameters, each one based on a data set and each one has a default value of "All" for each of the respective levels. For example the first parameter, parameter one, has a default value of "All Level 1" The second parameter has a default value of "All Level 2" The third parameter "All Level 3" and the fourth "All Level 4" If a user selects a value from any of the parameters level 2 through 4, and then resets (select another value) from a parameter above that parameter I would like to set all the parameters below that parameter back to "All..." For example if the user selects a value other than "All Level 3" for parameter 3, then selects a value other then "All Level 4" for parameter 4, then changes parameter 3 back to "All Level 3" or another value, I would like parameter 4 set back to "All Level 4" Instead the drop down list displays "<Select a Value>" Thanks.

u made me confused ;) anyways i suppose you can use cascade parameters. For all parameters use Stored procedure in dataset (you can use SQL as well) and when you select first parameter passed to to second parameter Sp and based on value SP will generate your SQL. in Your Second parameter Sp you can put cases or IF Else Statement and based on it you can return the result the way you want. hope this gives you heads up. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/