show description from LOV in a report

I defined a list of values which has two return objects: a key and a description.
The key is the actual value in the table (a numeric value) but has no meaning to the user.

Is there a possibility to show the description from the lov file in a BO-report?

thanx Matt


Listserv Archives (BOB member since 2002-06-25)

Kevin,

You wrote:

Is there a possibility to show the description from the lov file in a
BO-report?

There is no way to get to the selected description itself, but if you select the description object that you added to the LOV query, this object will give you the description that fits the selected value.

A negative effect of this is that the query will effectively join the table from which the description comes. (With normal lookup table that have a unique index on the actual selected value, this should not be much of a problem).

Succes,
Marianne Wagt
IDETA, the Netherlands


Listserv Archives (BOB member since 2002-06-25)