Pasting multiple values into parameter textbox

  • I have a procedure that will accept a list of multiple 'order numbers' that users receive from various sources. These numbers are delimitted by a carriage return. I use a split function to return a table that I then join against to return the information on each order number that they need. My problem is integrating this into RS. I can't seem to paste this list into the textbox for the parameter...it is truncated after the first order number in the list. The list would look like the one below, copied from an email or wherever. Anyone run into this? I want them to be able to just copy the list and paste in to a report as a parameter in order to do their research on the order.

    35274659

    35274667

    35274675

    35274679

    35275586

    35275589

    35275592

    35275595

  • I don't think this is possible with the default parameters. This is why there is the multi-value parameter available if you can use it.

  • On my place (BIDS 2008), when I use a multi-valued text parameter, the 'carriage return' is automatically converted to ', '.

    So I am able to either pass it to a stored procedure as a argument,

    or using a 'select * from tablename where fieldname in (@parameterName)' query.

  • Thanks to each of you for your reply. I have actually gotten sidetracked on other issues and have not gotten to revisit this but I will consider the multivalue approach when I do. At last attempt, I was not able to paste into the default parameter box but I will look at the others as you suggest.

  • I went back and looked at the multivalue parameter again and I was able to paste into it via control+v (but still not with the mouse so the users will have to get over it) and the behavior was just as you described, carriage returns replaced by commas. I was able to alter my sp's to split on this and everything works great! Thanks for the suggestion!

  • Thank you for your feedback!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply