List Description in the formula not working

[ella38]

I am trying to convert the key name to the full name from a list.
Here is the code:

IF (IsNull({SHIPPING_ITEM.SHIPPING_TYPE}))
THEN ListDescription ("SHIP_TYPE",{SHIPPING_ITEM.SHIPPING_TYPE})
ELSE ""


The "SHIP_TYPE" is a list item and points to the full description of the key. ie key is STORE_SUP description is Store Supplies.

This code is not working for this report but works for others using different tables/fields etc. Any thoughts???

 

[Turkbear]

Hi,
I am not familiar witha function called ListDescription,
is it a custom user-defined function or maybe a Stored Procedure in the database?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ella38]

Where do I go in the database to see if it a stroed procedure???
If I can't figure this part out, is there any way to get the description to come across in the report?