Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to show the (LOV) display value of the field in a report

gkthomasDec 17 2017 — edited Dec 21 2017

I have a select list field in a form with static List of values .  it has a 3 character return value and a 20 character display value .   I didn't create a table to mange this because it has only 6 values and are not going to change.

When I want to use this field in an Interactive report How can I display the Display Value instead of return value Which is saved the database without  using direct decode statement for each value.

I am on apex 5.1.3 hosted .  Database 12C

Thanks
George

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2018
Added on Dec 17 2017
2 comments
8,060 views