I have 4 drop down cascading parameters. The cascading part is working fine. The 1st parameter has 5 choices, and depending on the selection, the 2nd parameters drop down list is populated and so on. However if one of the values selected in the 1st parameter is choosen, the 2nd (and 3rd and 4th) parameter has only one available choice. In the event this value is selected is their a way to automatically populate the 2nd, 3rd and 4th parameters so the user does not have to select these parameters when there is only one choice in the drop down list anyway? I do not want to have default values for any of the parameters, but I need to have parameters 2, 3 and 4 automatically selected when 1st parameter value is a particular selection. Thanks

The only way to avoid requiring a parameter selection is to set a default (which can be done using an expression) or allow null. I don't think there is any other option. One approach is to set the default to some value like '(All)' and then include query logic to ignore the parameter/field comparision if it's set to that value. Something like: WHERE ( @Country = @Country ) AND ( @StateProvince = '(All)' OR StateProvince = @StateProvince ) AND (... Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com *Please vote if helpful*