Link to home
Start Free TrialLog in
Avatar of Wes Zalewski
Wes ZalewskiFlag for Canada

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.
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Wes Zalewski

ASKER

Unfortunately, not so easy.
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 ¥.
I should say, I replace the $ with ¥ symbol for the YEN currency.
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.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?