Hello, I have a product parameter in the report (text). I want to show the not selected values in a textbox? how can i do it? also i need to use the unselected values in a query.

Can't you create a dataset with something like SELECT ProductName FROM TableName WHERE ProductName NOT IN (@ProductParamter) and capture the results in a table?

I need something like - productname not like @productParameter . Not In won't work for me since i need the exact productname .... For example productname not like '%a%' and productname not like '%b%' .....

I am confused. The select statement will give you product names that were not selected in the parameter. Is't it what you wanted? Please clarify.

OK i understand. I used the query yoy wrote to select the unselected productNames and used it as a parameter to another query i'm using the unselected productnames.

So you are all set now, correct?