Print Page | Close Window

"contains"or "one of" formula

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=6939
Printed Date: 18 May 2024 at 7:12pm


Topic: "contains"or "one of" formula
Posted By: MartaB
Subject: "contains"or "one of" formula
Date Posted: 02 Jul 2009 at 8:38am

Hi, I'm starter in CR and the biggest problem for me are the formulas. 

How to create one which will be like "contains" or "one of"?

 

I give you example what I want to achieve.

 

I need such history description where word "Notes" appears. In formula I used: {HISTORY.DESCRIPTION} in ["Change to Notes"]

shows only this description which is clear, but what should I put if I want to see in my reports for example: "Change to Status, Notes" (it can be many of them).

 

I can't use Selection Expert, because I want to see data without this specific history too. Besides when I create subreport for the history only and put in selection expert: History.Description is one of "Notes" it didn't work...

 

Any help please?

 
 


Replies:
Posted By: DBlank
Date Posted: 07 Jul 2009 at 8:52am
You can create a fomula that returns a value if the word NOTES is in the string and then group or suppress or whatever from that.
 
if instr({table.Field},"Notes",1)>0 then "Notes Appears" else "Notes does not appear"

Posted By: MartaB
Date Posted: 08 Jul 2009 at 2:06am
I worked! Thank you very much!


Print Page | Close Window