We have a UDF called U_ISO_RET_CAT in the returns module on SAP B1
This is a dropdown, with values and descriptions.
As you can see... 1 = ASM error, 2 = Cancelled Items etc...
I want to pull this UDF onto a crystal report. When I drop in U_ISO_RET_CAT onto the layout, it pulls through the value not the description.
I read online the easiest way to pull the description is select case statement.
I understand the implications of hard coding this, but we won't be making any additions or amendments to this UDF in a while so no issues there.
I have used the below query in a command on crystal.
SELECT CASE WHEN [U_ISO_RET_CAT] = '11' THEN 'Liqudation' ELSE NULL END FROM ORDN
I can drop this query field onto my layout layout but it doesn't output any results, in fact it actually duplicates a lot of the other data on the layout.
here have I gone wrong? The command isn't yet linked to anything.
Add comment