Crystal Reports - Converting currency
I have a report that is run via our ERP system Sage X3 that displays a list of items being shipped to a customer along with their prices. When printed locally on a PC, the currency of the prices is US dollars. The report can also be sent direct to a printer when printed through the Crystal Reports Print Engine on the the Sage X3 server. When printed through the CR Print Engine, the currencies are changed to Euro.
I've set the system settings of the server to English, i've set all report and ERP settings I can find to english. Sage X3 is developed in Europe, so it may default to Euro in its settings but we'd have to pay them to fix it for us (and they charge very hefty prices)
Does anybody know of a way to force crystal reports to stick to a certain currency and not be dependant on the language settings of the print engine.
Thank you!
Kevin
|