CODEWITHSUNDEEP
reporting-services
Tito Paterson
Tito Paterson

Reputation: 307

formatting fields to show currency in SSRS

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, "£")

Upvotes: 21

Views: 77558

Answers (3)

Burhan Kaya
Burhan Kaya

Reputation: 139

currency number format 

  =Format(Sum(Fields!MyField.Value), "C")

Upvotes: 6

Tito Paterson
Tito Paterson

Reputation: 307

thanks for your help. I have found another solution to my problem.

I have changed all the formatting properties and then entered the following expression:

=CDbl(FormatNumber((CDbl(Fields!number.Value)),2))

Not the most elegent of solutions but it works.

Upvotes: 2

Ian Preston
Ian Preston

Reputation: 39566

Set the textbox format as C0, i.e. currency to 0 decimal places:

enter image description here

This will be affected by the report Language property - set to en-GB for pounds, as in your example:

enter image description here

You can also set the textbox properties, which also gives you the option to set the symbol outside of the report language:

enter image description here

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.

Upvotes: 48

Related Questions