Tuesday, October 29, 2013

Multiple If / Nested If / If then Else in BI Publisher



  multiple or nested or if then else logic / choose  can be done using below syntax's:

 1 ) <?xdoxslt:ifelse(IND=1,'N/A',FLAG)?>

  2) <?xdofx: if IND=1 then 'N/A' else if IND=2 then '' else FLAG end if?>

  3)    <?choose:?>
         <?when:IND=1?>'N/A'<?end when?>
         <?when:IND=2?><?end when?>
         <?otherwise:?><?FLAG?><?end otherwise?>
          <?end choose?>
        
   IND,FLAG are XML tags and N/A,''(null) is static text we want to display when condition is met.

No comments:

Post a Comment