sql server reporting services: Hi,
I would like to get the symbol for the currency under the environment the
report is being run.... Is there a way to do it?

For example, in the US it would display a $
in UK, it would display either the Euro or the pound symbol

etc....

Typically, you would use the C formatcode for currency formatting. You could
for instance set the format property on the textbox. Alternatively, you
could use the Format(...) function call.

More information about numeric format codes is available on MSDN:
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandardnumericformatstrings.asp
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp


-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]