Post reply

multiple single values

  • February 6, 2006 at 2:01 am

    #170332

    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

    #619320

    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

    #725403

    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