Post reply

SSRS 2014 How to pass Multiple values with like operator in a parameter

  • October 20, 2016 at 10:45 am

    #331106

    Hello,

    I am new here and looking for some help in ssrs 2014. The actual problem is that I want in a @Parameter the user to be able to enters multiple values. For example [AAABBB, BBBAAA, AAACCC, ....] and I want in the query to run the following logic somehow..

    Split each value and add * in the end and then use them as OR.

    Where [Item Category Code] Like AAABBB+'%' OR

    [Item Category Code] Like BBBAAA+'%' OR

    [Item Category Code] Like AAACCC+'%' )

    Is this possible? can some one explain me how to implement this?

    Thank you in advance!!!

  • October 20, 2016 at 10:53 am

    #1907724

    Hi

    and welcome to the forum,

    is there an option of doing this on the database side?

    😎

    There are several ways of passing multi value parameters, each has pros and cons

  • October 20, 2016 at 11:24 am

    #1907730

    Hello,

    I think yes because in the @Parameter the user will write something. This something is a string. Can we use this string and populate the code in the query?

  • October 20, 2016 at 11:39 am

    #1907733

    Use DelimitedSplit8K or something like it and then use LIKE in the join?

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

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