February 6, 2006 at 2:01 am
Can reports be configured to allow users to enter multiple single values in the selection criteria(in a text box)?
In SAP, users can often click the button that looks like yellow arrow for this functionality. For example, a user would like to view company codes 1000, 1500, and 4000 (but no values in between).
Thanks
February 7, 2006 at 9:07 am
Unless your using RS 2005 your limited to a single entry per text box. You could parse an entry ( 1000,2000 etc) into a @table variable prior to using it as a filter. RS 2005 introduced what are called Multivalued parameters. Basically a combo box with a check box next to each item. The first item in the list is ( Select All ). Internally the selected items are converted to a comma delimited varchar that can be used directly in an IN clause if your report query is embedded in the xml. Although you can pass this varchar to a stored procedure, SQL2005 can't use it in an IN clause. I've had success with parsing this string into a @Table, then INNER JOINing.
Good luck
Mike
August 8, 2007 at 5:55 am
Mike
I'm using the RS2005 and SQL2005 and using stored procedures.
But I don't get it right. Could give more details how to deal with it ?
Thx in advance (C my other post to c which funtion I'm now trying to use).
JV
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply