Print Page | Close Window

formula

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20105
Printed Date: 04 Apr 2025 at 3:18pm


Topic: formula
Posted By: makemyday
Subject: formula
Date 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


Replies:
Posted By: lockwelle
Date 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..."

Posted By: makemyday
Date Posted: 14 Oct 2013 at 1:30am
Hey thank you, that worked great.

-------------
dc


Print Page | Close Window