Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Currency Symbol 1

Status
Not open for further replies.

Davest11

Programmer
Oct 26, 2004
82
US
I'm running Crystal v10, and I'm trying to conditionally enable the display of a currency symbol on a numeric field. I guessed that this would work just as a suppression formula, and just entered a simple boolean statement. When I tried to save, I got the error "result of formula must be a number." I tried using an if-then to set the value to 1 when I want the currency symbol and 0 when I don't, but that didn't work. Does anyone know what the result of this formula should be to enable and disable the currency symbol?

Thanks,

-Dave
 
As Crystal XI will automatically place in comments within the formula:

// This conditional formatting formula must return one of the following Currency Symbol Constants:
//
// crNoCurrencySymbol
// crFixedCurrencySymbol
// crFloatingCurrencySymbol

So have your formula return what is appropriate from the above list.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top