I have two single valued parameters each populated from the same dataset. After a value is selected in the first parameter I want to remove it as an available value from the second. So the first parameter list is A,B,C The users selects B, and then list of values in the second parameter changes from A,B,C to A,C. Thanks!

You should set the 'available values' for parameter2 to 'get values from a query' and for the dataset pass parameter1 as a parameter and you can modify the query to exclude that value. -Arun

Hi Adding to the previous reply... Say Value column contains the values A,B,C Dataset1 Query to populate Param1: Select Value from table Dataset2 Query to populate Param2 : Select value from table where Value != @Param1 Thanks M.Mahendra Please click the 'Mark as Answer' button if my Reply helped you to solve your problem! Thanks M.Mahendra

Thanks for the replies, what I did was create two separate datasets, and on the second add a filter where the value <> parmater1.value

In general it's a good practice to create 1 dataset for every 1 parameter. Just makes it easier to work with, like you found out yourself.