Print Page | Close Window

Locating certain letters

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2021
Printed Date: 05 May 2024 at 10:02am


Topic: Locating certain letters
Posted By: stevbren
Subject: Locating certain letters
Date Posted: 10 Jan 2008 at 3:32am

I need to view only a description of a job that the field contain these letters, RRSNC.

They are always in this order, but can be anywhere in a job description withing the same field though. Can someone tell me how to write a formula to only make the desciption show that has these letters in this order.
For those wondering, they mean, "re-run same no change"


Replies:
Posted By: Lugh
Date Posted: 10 Jan 2008 at 5:42am
Are you talking about in Select Expert?  Use the "is like" option.  So, the formula would look something like:

Job LIKE "*RRSNC*"


If you are talking about in a formula in a report, say for conditional formatting, then it might look more like:

IF InStr({MyReport.Job},"RRSNC") = 0
THEN False
ELSE True

Posted By: stevbren
Date Posted: 12 Jan 2008 at 7:23am
Perfect.
Thank you so much.


Print Page | Close Window