I have Interactive Report based on table (used Interactive Report + Form page wizard - this works well). In the report there is column which is code field and need to decode to display value. I am not keen to rewrite report to be based on query rather than table. I am aware that for this column I can set Type to Plain Text (based on List of Values) which would achieve decode. Problem is that looks like need to create List of Values object to achieve as I cannot see the Function Body Returning SQL Query that we use as standard for Select List edit fields. Our function has extra complexity that is neatly encapsulated within and hassle to replicate in individual List of Values objects (appreciate can have central copy and subscribe, but even this is hassle as multiple objects)
I am just checking there is no Function Body Returning SQL Query option for Plain Text (based on List of Values) for Interactive Report column where based on table.