Skip to main content
Solved

Report designer NVL condition

  • March 4, 2020
  • 1 reply
  • 1011 views

  • Sidekick (Partner)
  • 39 replies

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)

Best answer by ChanakaAmarasekara

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,

View original
Did this topic help you find an answer to your question?

1 reply

ChanakaAmarasekara
Hero (Employee)
Forum|alt.badge.img+15

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings