Home Dashboard Directory Help
Search

Multiple integer values in Define Query Parameters dialog box by Cowski


Status: 

Active


1
0
Sign in
to vote
Type: Suggestion
ID: 803966
Opened: 9/30/2013 10:46:46 AM
Access Restriction: Public
0
Workaround(s)
view

Description

It would be nice to be able to use multiple integer values in the "Define Query Parameters" dialog box within Report Builder 3.0 and Visual Studio 2010. Currently if you try to enter in multiple integer values (example: 36168, 55402) or (example: 36168 55402) you will be greated with the error "Conversion failed when converting the nvarchar value 36168 55402 data type int"
This makes sense because the Parameter value is expecting an integer, not a series of integers.
It works fine with a text value, but not an integer value.

I was instructed from the SQL Server forums to post a wish in here for this.

Any questions, please let me know.
Details
Sign in to post a comment.
Sign in to post a workaround.