Menu
I am trying to format a field for salary and can't seem to bring out the currency symbol when doing the formatting. I have tried using the text box field formatter and then I have tried using the expression below.
When I re-run my report after entering the expression I get a #ERROR in the output. Is there anything else I can try?
=Format(Fields!number.Value, "£")
798
In SQL Server, you can use the T-SQL FORMAT() function to format a number as a currency. The FORMAT() function allows you to format numbers, dates, currencies, etc. It accepts three arguments; the number, the format, and an optional “culture” argument.
Different Ways to Format Currency Output in SQL For example, in the USA we use the $ for the currency symbol and a decimal point as a separator. Whereas in Latin America, we use the decimal point instead of a comma as the separator.
Set the textbox format as C0, i.e. currency to 0 decimal places:
This will be affected by the report Language property - set to en-GB for pounds, as in your example:
You can also set the textbox properties, which also gives you the option to set the symbol outside of the report language:
Finally, you can use a string like:
=Format(Fields!number.Value, "C0")
This does change the field type to a string, unlike the other options, which can have en effect if exporting to Excel.
179
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
