CODEWITHSUNDEEP
reporting-servicesformattingexpressionssrs-expression
GandalfTheFoolish
GandalfTheFoolish

Reputation: 3

SSRS Currency Format IIF Expression

I'm trying to format the text box properties based off an expression, I have a field 'currencyID' and I'm trying to get it to change from £ to € if the value doesn't equal 1. So far I've got this but I am terrible at SSRS Expressions...

=IIF(Fields!currencyID.Value = 1, '£'#,0.00;('£'#,0.00), '€'#,0.00;('€'#,0.00))

This is to save having a report for UK clients and a separate report for Irish clients. Any help would be greatly appreciated. Thank you.

Upvotes: 0

Views: 359

Answers (0)

Related Questions