January 21, 2010 at 10:32 am
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
January 22, 2010 at 7:22 am
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.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 27, 2010 at 10:19 am
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.
January 27, 2010 at 10:50 am
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.
January 27, 2010 at 12:54 pm
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!
January 28, 2010 at 8:52 pm
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