Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: formula Post Reply Post New Topic
Author Message
makemyday
Newbie
Newbie
Avatar

Joined: 09 May 2012
Online Status: Offline
Posts: 18
Quote makemyday Replybullet Topic: formula
    Posted: 09 Oct 2013 at 5:45am

Looking for help setting up a formula that I have 2 different text fields and I want to display one if fee is 00000.00 and another text field if fee is 99999.99. 

1)  text field is:  Customer has authorized a   {WASH}.   -    This is the text I want to show if the data is sent as 99999.99                  WASH is my data string field and I want to put it in the 1 text field.

2)  text field is:  Customer has opted out of wash.   -    This is the text I want to show if the data is sent as 00000.00                       This text would not use the data string field.

I have both text fields in my form now, how do I set them up to hide or not to display when one is not used?   Or is there a better way of doing something like this?  I'm just starting on using formulas, so I'm not sure what is the best way to set this up.

Thanks for any help, I'm a beginner

dc
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 11 Oct 2013 at 4:53am
why not a formula like:
if {table.field} = 0 then   //or "000000.00"
"customer has opted out of..."
else
"customer has authorized..."
IP IP Logged
makemyday
Newbie
Newbie
Avatar

Joined: 09 May 2012
Online Status: Offline
Posts: 18
Quote makemyday Replybullet Posted: 14 Oct 2013 at 1:30am
Hey thank you, that worked great.
dc
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.016 seconds.