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