Post reply

type multi values in text box parameter Reporting services 2005

  • June 24, 2008 at 10:22 am

    #187496

    Hello All

    I have 5 parameters. Users want to type the multiple values in each parameter and as well as they need the default value to be shown as 'ALL' in all parameters. Is it possible.

    Thanks in Advance.

    Prem

  • June 24, 2008 at 12:08 pm

    #833520

    I solved it.

    Thanks:)

  • July 17, 2008 at 5:26 pm

    #844728

    Hello, I was hoping you could say how you solved the problem. I am having the issue right now. I have four parameters, all of which need to accept multiple values. These parameters have a lot of choices, and so the users would like to be able to type in their selections. Also, how did you get ALL to show if the user left the box blank? Please help!

  • July 20, 2008 at 11:55 pm

    #845526

    =JOIN(Parameters!ParameterName.Value,",")

    or

    =JOIN(Parameters!ParameterName.Label,",")

    Cheers,
    Hari
    Tips & Tricks for SQL BI Developers

  • February 16, 2009 at 8:43 am

    #944612

    I am an SSRS newbie. Where would you define that function? Is that on the actual WHERE clause of your query?

  • February 17, 2009 at 4:39 am

    #945076

    Its a simple expression of SSRS and you can use it in ReportItem (TextBox).

    Cheers,
    Hari
    Tips & Tricks for SQL BI Developers

  • February 17, 2009 at 8:34 am

    #945244

    This is best done using a multi value parameter.. This is available in ssrs 2005 and above.

  • February 29, 2012 at 2:46 am

    #1452997

    Bob,

    A multi-value parameter doesn't allow for the value to be typed in. I actually don't know of any type of parameter that does. Is there one? Tx.

Viewing 8 posts - 1 through 7 (of 7 total)

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