I have a filter for a text field. I want to filter out any items that starts with two letters "AB".
I'm working with a reporting model and the related query designer.
There is a "contains" option but I don't see a starts with or ends with option. Nor do I see an option to ender my own expression. I've tried contains with variations of the % and *, but neither worked. Any suggestions as to how to use a "starts with"/"ends with" type of filter with the query designer and a reporting mode? (not sql)
Thank you,
Ow right, missed that part, sorry. This makes it a little more complicated because there's no "not like" operator, but it is possible. The trick is to build an expression that filters out the records you don't want and then use a simple boolean comparison. Here's how that goes:
Expression: =Left(Fields!YourTextField
Type: Boolean
Operator: =
Value: false