SSRS Conditional Currency Symbols Change

If we want to change the currency symbol of a textbox, we have to use expression for Number property using custom option from here:

And click on fx and type the following expression:

=SWITCH(Parameters!LST_CURRENCY.Value = "GBP", "'£'0.00;('£'0.00)"
,Parameters!LST_CURRENCY.Value = "USD", "'$'0.00;('$'0.00)"
,Parameters!LST_CURRENCY.Value = "CAD", "'$'0.00;('$'0.00)"
,Parameters!LST_CURRENCY.Value = "EUR", "'€'0.00;('€'0.00)"
)

Here LST_CURRENCY is a parameter which has currency selection list.

 

Advertisements
By simplemsexchange Posted in SSRS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s