Crystal Reports if, then else statement

Writing Code
Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code

Topic: if, then else statement

Author	Message
south Groupie Joined: 31 Jul 2012 Online Status: Offline Posts: 82	Topic: if, then else statement Posted: 15 May 2014 at 10:31am
	I keep getting an error an am not sure why my formula reads: if {Est.Hrs}=0 then (({Lead.Days})"D") else {Est.Hrs} It works fine if I get rid of the "D" and keep it really simple, but I was to identify when it days and when it is hrs. Thanks for your help!
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 15 May 2014 at 10:45am
	You do not have a function associated with {Lead.Days}. Did you want to use the datepart function?
	IP Logged

south Groupie Joined: 31 Jul 2012 Online Status: Offline Posts: 82	Posted: 16 May 2014 at 2:05am
	{Est.Hrs} returns the number of hours assigned, I would like the {Lead.Days} to return the number of days assigned and would like to have a "d" appear at the end of that number so people are aware that it is days not hours. Right now if I take out the "D" in the formula, I get the correct results but it say "3" and I would like it to say "3 D". I want people to know it's 3 Day not hours.
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 16 May 2014 at 6:17am
	Then you would probably do something like this: if {Est.Hrs}=0 then totext({Lead.Days},0)+" D" else {Est.Hrs}
	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.