Changing the Currency with Reporting Services

Hi,

I am formatting a currency field within reporting services using an expression. However i get the $ sign. I need the ￡ sign. How can i change this?

Thanks

David

Weird. It seems that once you wrap the FormatCurrency() Vb function, the localization goes out the window

Two workarounds
A)
1. Kill the FormatCurrency Wrapper function in your expression.
2. Use the Format Property of the texbox instead..so Format might equal C2 (for currency with 2 decimal places of precision.
3. Set your Language to English (United Kingdom) - found in Properties, in the International group

B)
If you simply MUST have the FormatCurrency wrapper then do the following
1. Wrap that expression in a CDBL()...so CDBL(FormatCurrency(blah))
2. Follow 2 & 3 in the steps for option A

Cheers