Crystal Reports If, then, else formula

Report Design

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

Topic: If, then, else formula

Post Reply

Post New Topic

Author	Message
VickiM Newbie Joined: 02 May 2011 Location: United States Online Status: Offline Posts: 28	Topic: If, then, else formula Posted: 08 Jul 2011 at 4:21am
	Hi! I'm sure this is a very easy formula, but how do I write an if, then, else formula where the "else" will be a blank if there's no match? Like, If "x", then "y" else [nothing appears]. Thanks!
	IP Logged


sharona Senior Member Joined: 16 Oct 2008 Location: United States Online Status: Offline Posts: 255	Posted: 08 Jul 2011 at 4:28am
	if field ='x' then 'y' else ' ' or NULL
	sharona
	IP Logged

VickiM Newbie Joined: 02 May 2011 Location: United States Online Status: Offline Posts: 28	Posted: 08 Jul 2011 at 4:42am
	Thanks Sharona! Here is what I'm trying to do: If {BENEFIT.PLAN_CODE} = ["IUH1"] then "IUH1" else '' and I get an error that a boolean is required and the '' are highlighted. What am I doing wrong?
	VickiM
	IP Logged

sharona Senior Member Joined: 16 Oct 2008 Location: United States Online Status: Offline Posts: 255	Posted: 08 Jul 2011 at 5:02am
	If {BENEFIT.PLAN_CODE} = "IUH1" then "IUH1" else '' REMOVE THE []
	sharona
	IP Logged

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