Crystal Reports Selection Criteria

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Selection Criteria
	<< Prev Page of 3

Author	Message
jswartz Newbie Joined: 24 May 2013 Location: United States Online Status: Offline Posts: 11	Posted: 30 Dec 2013 at 9:14am
	Are these 3 separate options to try, or is each separate? I tried various combinations but nothing seems to work. Even though I use parenthesis to signify that two conditions go together, Crystal always removes them and acts like each formula is a stand alone condition.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 30 Dec 2013 at 9:49am
	sorry I think I double pasted on my post try the below with the formula editor set to use defualt values for nulls ({Field1} like "HHGD" and {Field2} <> "Storage") or ((NOT({Field1} like "HHGD")) and {Field2} = "Storage")
	IP Logged

jswartz Newbie Joined: 24 May 2013 Location: United States Online Status: Offline Posts: 11	Posted: 30 Dec 2013 at 10:34am
	You guys are awesome, thank you for all your help in getting this figured out. Here is the final formula which works: not ({Field 1} = "HHGD" and {Field 2} = "Storage") I guess it was just a matter of getting the syntax correct. I'm so excited that my report is running correctly now!!!!
	IP Logged

<< Prev Page of 3

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.