Report field label and value

[Ashley]

Hi,

 

I have recently been asked to change the default entries for a field from Curacau, MGA, N/R to BS1, BS2, N/R.  Without having to update alot of historical data I can adjust the Simple List I use as below:

so the raw data stays the same, but what you now see on the screen is BS1 (Curacao), BS2 (MGA), N/R.  This is great for on-screen and saves alot of time reviewing old data.  However, is there a way of doing this on a report?  The reports take the raw data so will still show Curacao, MGA, N/R.  Is there a way to manipulate the output on the fly like on-screen and show BS1 (Curacao), BS2 (MGA)instead of the raw data?