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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Edit Masks in Crystal 1

Status
Not open for further replies.

rajanala

Technical User
Apr 5, 2006
5
US
i want to display the Amount using edit prompt
the issue is it has to read the currency type and give me differnt prompts for different currency
To explain in detail
if the currency is JAPAN-JPY then My edit prompt is 999,999,999
but if it is US Dollars-USD then it is 999,999,999.99
how can i do this and where to do it
Please help as i am nearing my dead line

Thanks in advance
 
In Crystal, can't you use the conditional formatting?

Right click on the field (in the report) and choose FORMAT FIELD.

Click CUSTOMIZE.

You can use the formula options (X+2 buttons) to specify the conditons.

It can reference a formula, parameter, value, etc....

-- Jason
"It's Just Ones and Zeros
 
I have seen that option but Couldnt understand how to use it Can you explain it in detail please or tell me where can i find a help on how to use this (X+2) option
 
It is giving me the option of specifying the edit mask only if it a string
but my field is currency (sum to be specific)
So can we specify edit masks to currency in Crystal
with this conditional formatting
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top