I am creating a report that shows a value chosen from a custom field (drop down menu). That custom form has values showing that don't match the drop down selection (for example - it shows designer name on the drop down and the value is their ID). The report is defaulting to showing the value, is there a way that I can show the ID? My text mode is shown below:
To my knowledge it's not possible to do.
Since you can't pull in a program value naturally in an assignment report and are using text mode already there isn't a way to get it back to the actual choice vs the value without using a series of IF statements. Hopefully someone else can weigh in to help.
I am working on a nested IF statement to solve a similar problem, but would love to here if there is another option. The same issue occurs on a journal entry report when a typeahead field text is changed.