How do I remove a parameter value from one paremeter after it is selected in another?
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!
October 26th, 2010 3:12pm
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
October 26th, 2010 3:36pm
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
October 26th, 2010 7:35pm
Thanks for the replies, what I did was create two separate datasets, and on the second add a filter where the value <> parmater1.value
October 27th, 2010 8:46am
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.
October 27th, 2010 9:04am