Post reply

Selection of multiple entries for one parameter

  • February 27, 2006 at 12:18 am

    #167218

    Hi,

    I have a report that has a parameter. The requirement is to be able to select multiple entries for the parameter. With reference to another post posted in this forum (Multiple entries for one parameter, posted by: AVB), I was able to achieve selecting all the entries by making modifications in the SQL code. But what I want is to select multiple number of entries.

    For example if I have following values in the parameter dropdown:

    A, B, C, D, E, F, G, H, I, J etc... and I want to select C, D and H out of the available values.

    Thanks.

    MG

  • February 28, 2006 at 9:32 am

    #623731

    MG,

    Unless your using RS 2005 your only option, that I know of, is have the user enter a delimited string of characters - C,D,H - then parse that string into a @table of values that you can 'join' or 'in' to.  RS 2005 introduces the multi-valued feature, that when enabled, puts a check box next to each item on your list.

    Mike

Viewing 2 posts - 1 through 1 (of 1 total)

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