I have created adataset to make a drop down list for a parameter. As shown:
SELECT
distinct [Table] FROM [Database]The results i get back are A, B & C. What i am trying to do is show a result as a different word.
i.e instead of displaying A is shows in drop down list as Apple, B shows Banana. etc.
Can anyone help please.
Thanks