Wednesday, November 15, 2017

OracleAppsKnowHows

XML Publisher RTF Report



1)  To replace Null value of XML Tag  with 'NA'  or If Else condition in RTF layout

  There are two ways to do it:
         a) using if condition, syntax: insert if and end if syntax in field

                <?if: xml_tag !=0?>  xmltag  <?end if?>
   
         b) use XDOFX  , in this we can use if, if else also, insert below syntax in XML Tag

                <?xdofx:if CP_TAX_AMT != '' then CP_TOTAL_AED+CP_TAX_AMT_AED else   'NA' end if?>
                   


No comments:

Post a Comment