Posted - 09/24/2013 : 16:21:35
| I'm using a "NOT IN (values)" for a logic in my query. So multiple values are allowed in there. Works fine in t-sql.
I'm in Report Builder 3.0.
I'm in the Dataset Properties -> Pasted in my t-sql code -> Query Designer. I click the ! to Run the code. The "Define Quary Parameters" dialog box comes up. At this point I start putting in my values to test.
Is there a way to allow the input of multiple values in a INT type box? Example: 33802, 55602
It appears to work for text. I'm getting the following error when I try to input the above set of numbers:
"Conversion failed when converting the nvarchar value '33802, 55602' to data type int"
which makes sense. It's expecting an integer, which it needs.