You may be faced with a problem similar to this, where the user wants to display a particular currency symbol that is different for each locality. It could be possible to alter the underlying dataset to return this information as well as the actual value, but it is entirely possible from within SSRS, as follows
Assume that we have a DataSet returning this information as DataSetSales
Country Sales --------- ------- Japan 404 UK 44 USA 1255
A good year for sales in America, not so much in the UK, I think we’ll all agree.
We can then create a new DataSet in the Report to return a list of Currencies for Countries, such as Results in this DatasSet – DataSetCurrency
Country Currency --------- ---------- USA $ Japan ¥ UK £
We can then use the LOOKUP function to ‘look up’ the value for the Currency in the Currency DataSet from the table showing the results of the Sales DataSet, as follows
=Lookup(Fields!Country.Value, Fields!Country.Value, Fields!Currency.Value, "DataSetCurrency")
