Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2014-02-10
5
2,303 Views
Last Modified: 2014-02-12
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
Comment
Question by:jaisy99
  • 3
  • 2
5 Comments
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39849488
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
 
LVL 1

Author Comment

by:jaisy99
ID: 39851564
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
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39852477
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
0
 
LVL 1

Author Closing Comment

by:jaisy99
ID: 39853467
Perfect.  Thank you so much!
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39855460
You're welcome!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question