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?