Multiple integer values in Define Query Parameters dialog box - by Cowski

Status : 


Sign in
to vote
ID 803966 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 9/30/2013 10:46:46 AM
Access Restriction Public


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.
Sign in to post a comment.
Posted by Microsoft on 6/4/2014 at 4:11 PM
Thank you for submitting this feedback. After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap.
Thanks again for providing the product suggestion and continued support for our product.
Matt Jones
SSRS Tiger Dev Team