Hi,
I have choice list in which I select multiple country codes which are stored in database as IN, US, UK, FR but when I create report it displays as IN, US, UK, FR but I want to show them as India, United States, United Kingdom, France how to perform this in query please suggest.
The country codes are stores in master table
Note : No hard coding allowed in query
Thanks