Solved

LIKE operator in Crystal Reports

Posted on 2011-02-14
5
1,087 Views
Last Modified: 2012-05-11
Hello,
Quick question: I am trying to use LIKE operator in my Operation field.
Operation - number value
So I want to Supress if Operation has value '9' in it.
I am using inside Format Editor --> Supress --> X2 box for Formula

thank you
0
Comment
Question by:Palmer_Admin
[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
  • 2
  • 2
5 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 34891418
You could try

{YourField} LIKE "*9*"

ANother way would be

InStr({YourField},"9") > 0

mlmcc
0
 

Author Comment

by:Palmer_Admin
ID: 34891464
Hello MLMCC,
I get this error when I use:
{YourField} LIKE "*9*" - a string is required here

if I use the other command I get this error:
Not enough arguments have been give

thanks

0
 
LVL 12

Accepted Solution

by:
JayConverse earned 350 total points
ID: 34892874
Sounds like you have a numeric field.  In that case,

ToText({yourfield}) like "*9*"

should do the trick
0
 

Author Comment

by:Palmer_Admin
ID: 34899304
JayConverse, is there a way to add exlude Operation "999"? the user came up to me and said that they want Operation "999"

thank you
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 34903694
ToText({yourfield}) like "*9*"
AND
ToText({yourfield}) <> "999"

mlmcc

0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

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.

Join & Ask a Question