Post reply

Report Builder 3.0 Problem with filter using IN operator

  • April 16, 2014 at 9:29 am

    #306490

    Hi

    We have SSRS 2012 and using Report Builder 3.0 and am having problems using the IN operator in a filter.

    (assume that I am looking for matches to 1W or 2W)

    First, set the filter is very tricky, I am only able to make it work if a set an equation to "1W", "2W" and immediately save and leave the filter.

    Second, If I ever go back to the filter, even to just look at it, the report builder will add quote marks so the value now is ""1W"" ""2W"" and of course the filter does not work.

    Have others seen this and is there a work around?

    Thank you

    Tom D

  • April 17, 2014 at 5:33 am

    #1706719

    Just add 1W,2W without the quotes

  • April 17, 2014 at 6:39 am

    #1706733

    Hi Scott

    Thanks but just entering 1W,2W does not work for me, report builder ends ups showing ""1W"", ""2W"" after a save... and that is what is so maddening about all of this.

    I should mention that this filter is being applied to a charts series group

    Tom

  • April 17, 2014 at 7:22 am

    #1706744

    A couple of ways:

    1. use an expression for your IN clause:

    =split("1W,2W",",")

    2. Set up a hidden, multivalued parameter holding your filter values and point to that in your filter.

  • April 17, 2014 at 7:58 am

    #1706768

    The split worked great!!! Thank you!!

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

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