多种货币符号 [英] multiple currency symbol

问题描述

我正在为一家公司设计一份水晶报告，根据下订单的客户需要不同的货币符号

例如，如果客户来自美国并下订单，那么它将是
生成的报告将包含$
中的价格字段如果来自英国的客户下订单，那么生成的报告应该有英镑符号。


我不知道如何锻炼一个公式，以显示不同的货币符号给客户...可以任何人帮助

任何帮助在这个问题非常感谢....

解决方案

右键单击报表设计器中的money字段...

Format Field->数字标签 - >自定义...按钮 - >货币符号选项卡 - >货币符号公式编辑器

然后输入返回正确货币符号的条件逻辑...

如果{customer_country} =" USA"然后

"

"
Else If {} =""
...



< BR>搜索结果，搜索结果，结果

I am designing a crystal report for a company which needs different currency symbols according to the customer that place orders

for example if the customer is from USA and places the order
it would be
The report generated would have the price fields in $

If a customer from UK places an order then the report generated should have pound  symbol..


I dont know how to workout a formula to display different currency symbols accordinf to customers...can any one help

any help in this issue is much appreciated....

解决方案

right click on the money field in the report designer...

Format Field-> Number tab -> Customize... button -> Currency Symbol tab -> currency symbol formula editor

Then enter the conditional logic that returns the correct currency symbol...

If {customer_country} = "USA" Then
"

"
Else If {} = ""
...
...

这篇关于多种货币符号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！