• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3202
  • Last Modified:

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,
0
jaisy99
Asked:
jaisy99
  • 3
  • 2
1 Solution
 
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
 
ValentinoVBI 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
 
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now