How to Filter with "starts with" in Report Builder 3.0 Reporting Model Query Designer?

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,
LVL 1
jaisy99Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
ValentinoVConnect With a Mentor BI ConsultantCommented:
but I want to filter these out/exclude them

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.Value, 2) = "AB"
Type: Boolean
Operator: =
Value: false
1
 
ValentinoVBI ConsultantCommented:
It should be possible to use the Filter functionality on the dataset.  One of the operators is "like".  If you use the like in combination with a search value that ends with an asterisk (and not starts), you've got exactly the same as you'd have with Starts With.

Here's what the complete filter would look like:

Expression: YourTextField
Operator: Like
Value: AB*

Please note: this filter is different functionality than the filtering through the query designer...
0
 
jaisy99Author Commented:
Thank you.  This is working to find all that start with AB, but I want to filter these out/exclude them.  Where would I put the NOT using this filter section?
0
 
jaisy99Author Commented:
Perfect.  Thank you so much!
0
 
ValentinoVBI ConsultantCommented:
You're welcome!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.