Formatting Currency in Reporting Services

 

Say you have a table which contains different currency values - each row in your table contains values for stored with a different currency types (see figure 1). You want to display these values in your report and ensure that each value is displayed with the correct currency symbol (figure 2). How do you to this?

Source: Russell Christopher's Semi-Useful BI Musings