Post reply

NOT LIKE CONDITION SSRS

  • April 6, 2012 at 3:14 pm

    #256043

    I can use a like condition is ssrs

    AND trim(Fields!DEPRTMNT.Value) like "???CPI"

    but how do you use not like

  • April 9, 2012 at 6:57 am

    #1470627

    I never tried to use Not Like in an SSRS before, but I don't see any clear way to do it. I checked expressions, filters, etc. and there is not option that does not show an error.

  • April 19, 2012 at 3:03 pm

    #1476296

    Did you try NOT(Fields!yourfield.Value LIKE "XX*"), "result1", "result2" ? 🙂

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

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