SSRS 2014 How to pass Multiple values with like operator in a parameter
-
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!!!
-
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
-
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?
-
Use DelimitedSplit8K or something like it and then use LIKE in the join?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply