SSRS - formatting fields to show currency symbol with two place decimal

• PSB

  SSChampion

  Points: 13195

  More actions

  August 28, 2014 at 9:54 am

  #292804

  Hi,

  I need to have proper currency symbol along with displaying upto two places of decimal. The currency symbol works however it does not show the decimal part.

  =Switch(Fields!Code.Value="GBP", "'£'#,0;('£';('£'#,0.00))",

  Fields!Code.Value="USD", "'$'#,0;('$'#,0.00)",

  Fields!Code.Value="AUD", "'$'#,0;('$'#,0.00)",

  Fields!Code.Value="CAD", "'$'#,0;('$'#,0.00)",

  Fields!Code.Value="EURO", "'€'#,0;('€'#,0.00)",

  Fields!Code.Value="NOK", "'kr'#,0;('kr'#,0.00)",

  Fields!Code.Value="RUB", "'py6'#,0;('py6'#,0.00)",

  Fields!Code.Value="COP", "'COL$'#,0;('COL$'#,0.00)"

  )

  Please help.

  Thanks,

  PSB

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  September 4, 2014 at 2:38 am

  #1743119

  Hi PSB

  Imho you should add format expression, please check in this way:

  =Switch(Fields!Code.Value="GBP", Format(Fields!YourDecimalValues.Value, "'£'#,0.00;('£';('£'#,0.00))"),

  Fields!Code.Value="USD", Format(Fields!YourDecimalValues.Value, "'$'#,0.00;('$'#,0.00)"),

  Fields!Code.Value="AUD", Format(Fields!YourDecimalValues.Value, "'$'#,0.00;('$'#,0.00)"),

  Fields!Code.Value="CAD", Format(Fields!YourDecimalValues.Value, "'$'#,0.00;('$'#,0.00)"),

  Fields!Code.Value="EURO", Format(Fields!YourDecimalValues.Value, "'€'#,0.00;('€'#,0.00)"),

  Fields!Code.Value="NOK", Format(Fields!YourDecimalValues.Value, "'kr'#,0.00;('kr'#,0.00)"),

  Fields!Code.Value="RUB", Format(Fields!YourDecimalValues.Value, "'py6'#,0.00;('py6'#,0.00)"),

  Fields!Code.Value="COP", Format(Fields!YourDecimalValues.Value, "'COL$'#,0.00;('COL$'#,0.00)")

  )

  Thanks

  Mike

  Ps. Or for display up to places of non-zero decimals set "'£'#,0.##;('£';('£'#,0.00))"),