The command I used to format the text box was the formatcurrency() express which states it will format the text in accordance with the settings in control panel. The only thing I can think of is that it is either using a system default setting (were on a domain with roaming profiles) or it uses the language as set on the SQL server (which I haven't checked yet).
Anyone else noticed this odd behavior or know where you type the expression pattern to make a custom currency format for UK?
I use a custom format entered in the Format code: box
￡#,##0.00
|||Yeah thats, the method I used in the end. Shame the formatcurrency() function doesn't do what it should out of the box.Thank you.
|||Yep, I'd be interested to know why we can't default to local currency settings as with say Office programs...
Let me know if you find out :)
|||Yes, would be useful. I might google once I have some spare time. Just hope one of the developers of that section who might know passes over this.|||You may want to read this: http://msdn2.microsoft.com/en-us/library/ms156493.aspx
The Report has a Language property which could be set to a static value, such as en-UK. Or you could set it to the current user's language by using an expression: =User!Language. Note: you can also override the report's language on individual textboxes by explicitly setting the textbox.Language property.
-- Robert
|||I can confirm that setting the language of the report does in fact fix the local symbol's. I never noticed this property as it is tucked away. To get to it you have to select it from the drop down menu in properties ( http://www.devstuff.eu/images/stories/msdn/ReportSelecter.JPG ). Then you can set report wide settings.
Interesting points about this :
Text boxes local settings does not override form default.|||Thanks guys.
No comments:
Post a Comment