Skip to main content

How to make  make in report designer simple condition/rule what to show value from another field if one is empty.

Two variables
CV_PART_NO
SO_PART_NO

I’d like to get one field condition that if CV_PART_NO have value, use that, other wise SO_PART_NO

like in plsql NVL(CV_PART_NO,SO_PART_NO)

Hi,

Try the strIFF function,

vldtstr:strIFF(string-length(tns:CV_PART_NO),tns:SO_PART_NO,tns:SO_PART_NO,tns:CV_PART_NO)

Regards,

Reply


Terms & ConditionsCookie settings