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
I GOT THE FOLLOWING ANSWER
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
BUT ....
It is giving me the option of specifying the edit mask only if it a string VALUE
but my field is currency (sum to be specific)
So can we specify edit masks to currency in Crystal
with this conditional formatting
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
I GOT THE FOLLOWING ANSWER
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
BUT ....
It is giving me the option of specifying the edit mask only if it a string VALUE
but my field is currency (sum to be specific)
So can we specify edit masks to currency in Crystal
with this conditional formatting