Sunday, 26 May 2019

How to handle NVL and IF Condition @RTF Level


NVL function In RTF level

Please use Below code for same in RTF its very Useful to use Conditions in RTF level itself.



<?xdofx: if SERIAL_NUMBER_CONTROL_CODE='1' and XX_LOT_CONTROL_CODE='1'   then 'NA' else if SERIAL_NUMBER_CONTROL_CODE!=1 and XX_SERIAL_EXIST='Y' then  nvl(SERIAL_NUMBER,'_____')else if XX_LOT_EXIST= 'Y' then nvl(LOT_NUMBER,'_________') else '_________'  end if?>

if required more details of XDOFX click_here

Its same like case function in SQL ....
Thank you.

No comments:

Post a Comment