Currency symbol changes

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Geof_Shuger_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

Currency symbol changes

Post by Geof_Shuger_(Guest) » Thu May 10, 2007 2:47 pm

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.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Currency symbol changes

Post by kfleming » Mon May 14, 2007 9:07 am

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

Geof_Shuger_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Currency symbol changes

Post by Geof_Shuger_(Guest) » Mon May 14, 2007 4:25 pm

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)

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: Currency symbol changes

Post by kfleming » Tue May 15, 2007 8:58 am

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

Post Reply