Wes Zalewski
asked on
Formatting (editing) a number as currency with symbol in Gupta Report Builder 2005
Hello,
I need to edit an existing .qrp file to show a total of a sales order in a currency of a country to which the product is sold using Gupta Report Builder.
Can't find where the currency symbol is inserted in front of a number and how to edit it in the first place. I need Japanese Yen to appear in the field instead of Euro and the description changed from EUR to YEN.
Your help is greatly appreciated. Thank you.
I need to edit an existing .qrp file to show a total of a sales order in a currency of a country to which the product is sold using Gupta Report Builder.
Can't find where the currency symbol is inserted in front of a number and how to edit it in the first place. I need Japanese Yen to appear in the field instead of Euro and the description changed from EUR to YEN.
Your help is greatly appreciated. Thank you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I should say, I replace the $ with ¥ symbol for the YEN currency.
ASKER
and again.... I should say.. On the GUPTA generated .qrp report however, it still reads the $ sign....
Not on the QRP file.
I am trying to find out where on the QRP file is the formatting or how is the $ symbol inserted on the generated report. This is new to me.
Not on the QRP file.
I am trying to find out where on the QRP file is the formatting or how is the $ symbol inserted on the generated report. This is new to me.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
To Admin,
Do I ask a question about, how to add a Unicode character in SQL 2005 varchar field, here, or in a separate question?
Do I ask a question about, how to add a Unicode character in SQL 2005 varchar field, here, or in a separate question?
ASKER
The ERP we use runs on SQL Server 2005 and uses GUPTA Reports.
In the Currency table I can see a $ sign entered and I added the ¥ symbol for YEN, which the table accepted. (I can see the ¥ entry in the tables in Microsoft Excel to verify).
On the GUPTA .qrp report however, it still reads the $ sign, despite the fact that vendor currency used is YEN, and symbol used is ¥.