Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Cowski
Starting Member
30 Posts |
 Posted - 2013-09-24 : 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.Thanks! |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2013-10-01 : 03:37:13
|
| something like this?http://www.mssqltips.com/sqlservertip/2866/sql-server-reporting-services-using-multivalue-parameters/ |
 |
|
|
|
|
|
Multiple values in the Define Query Paramaters