Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.
Course Of The Month
8 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How to Filter with "starts with" in Report Builder 3.0 Reporting Model Query Designer?
Posted on 2014-02-10
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,
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,
[X]
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
3-
2
5 Comments
Active 2 days ago
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...
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...
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?
Active 2 days ago
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
Type: Boolean
Operator: =
Value: false
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2. In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
How to increase the row limit in Jasper Server.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month8 days, 23 hours left to enroll
615 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.