Solved

Report designer NVL condition

  • 4 March 2020
  • 1 reply
  • 801 views
J
Rank
Userlevel 4
  • Jouni
  • Sidekick (Partner)
  • 38 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)

icon

Best answer by ChanakaAmarasekara 4 March 2020, 10:25

View original
-Jouni-

1 reply

ChanakaAmarasekara
Rank
Userlevel 7
Badge +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,

- Chanaka Am -

Reply


Terms & ConditionsCookie settings