Home Forums SQL Server 2005 Business Intelligence SSRS - formatting fields to show currency symbol with two place decimal RE: SSRS - formatting fields to show currency symbol with two place decimal

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