Skip to Content
0

UDF description onto crystal report

May 17, 2017 at 11:19 AM

16

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers