Skip to Content
avatar image
Former Member

UDF description onto crystal report

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.

udf.jpg (29.1 kB)
11.jpg (10.1 kB)
command.jpg (15.8 kB)
lnk.jpg (87.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers