Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: "contains"or "one of" formula Post Reply Post New Topic
Author Message
MartaB
Newbie
Newbie


Joined: 02 Jul 2009
Location: United Kingdom
Online Status: Offline
Posts: 2
Quote MartaB Replybullet Topic: "contains"or "one of" formula
    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?

 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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"
IP IP Logged
MartaB
Newbie
Newbie


Joined: 02 Jul 2009
Location: United Kingdom
Online Status: Offline
Posts: 2
Quote MartaB Replybullet Posted: 08 Jul 2009 at 2:06am
I worked! Thank you very much!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.