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

Displaying currency with Conditional Formatting

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

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top