Currency symbol changes
-
- Posts: 2
- Joined: Tue Oct 10, 2017 12:44 pm
Currency symbol changes
I^m having trouble outputting the British pound symbol in reports. I can^t use the Windows Regional Settings because there will be both pounds (£) and dollars ($) in the same report. I also can^t find an R&R format that will output either symbol, so I think I^m stuck with defining a variable and setting it to the symbol needed for each instance.____Unfortunately, this doesn^t seem to work properly either. I^ve defined a field in my Visual FoxPro table and populated it with the pound sign (by entering Alt-156) where appropriate. When that value is output to a report, it displays a different character even though the input form and the report field both use the same font, Arial.____Am I trying to do the impossible, or missing something simple? Has anyone developed a different way to handle this situation?____Thanks in advance for any advice.____Geof.
=> RE: Currency symbol changes
Edit the file RRW.SRT that is in the R&R program folder and remove the semi colon from the start of the line that says DBCHARS=ANSI.____Then create a calculated field with the expression chr(163) and apply Arial as your font. This should produce a £ in the report.____Kathleen__R&R Support
-
- Posts: 2
- Joined: Tue Oct 10, 2017 12:44 pm
==> RE: Currency symbol changes
Thanks for the tip. It worked like a charm.____Is this something that I should have been able to find in documentation?____Is it more readily accessible in the latest version? (I^m using 9.0)
===> RE: Currency symbol changes
The documentation does mention the SRT file and the CHR() function is also documented. But putting them together to figure out how to print a pound sign is not explicitly explained.____Kathleen__R&R Support