Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Saturday, 2 September 2017

If then Else statement in BI/XML Publisher Reports

Conditional Format Statements:   

choose- when-otherwise

The Conditional Formatting using if statement:

If statement:

Use if statement to define a simple condition; for example, if a data field is a specific value.

Insert the following syntax to designate the beginning of the conditional area.


 Insert the following syntax at the end of the conditional area: <?end if?>

For example display 10th department employees


       <?end if?>

If statement in xml publisher reports

if-then-else statement:

   BI Publisher supports the common programming construct "if-then-else". This is extremely useful when you need to test a condition and conditionally show a result




 ‘Y’  END IF

<?xdofx:if COMM='' then 'N' else 'Y' end if?>


if else condition Report Output

Choose- when-otherwise statement:

   Use the choose, when, and otherwise elements to express multiple conditional tests. If certain conditions are met in the incoming XML data then specific sections of the template will be rendered. This is a very powerful feature of the RTF template. In regular XSL programming, if a condition is met in the choose command then further XSL code is executed

Use the following syntax for these elements:



<?otherwise?><?end otherwise?>
<?end choose?>


<?when: DEPTNO=10?>Ten<?end when?>
<?when: DEPTNO=20?>Twenty<?end when?>
<?when: DEPTNO=30?>Thirty<?end when?>
<?otherwise?>N/A<?end otherwise?>
<?end choose?>

Choose- when-otherwise statement


Choose- when-otherwise statement: output

Share this article :


  1. I cannot find anywhere that identifies the limit to the nesting of the if-the-else statement. Do you know?

  2. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  3. Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle Fusion Financials . Actually I was looking for the same information on internet for Oracle Fusion Financials and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more aboutOracle Fusion Financials . By attending Oracle Fusion FinancialsTraining .

  4. Initial You got a awesome blog .I determination be involved in plus uniform minutes. i view you got truly very functional matters , i determination be always checking your blog blesss. wylewki anhydrytowe

  5. Hmm… I interpret blogs on a analogous issue, however i never visited your blog. I added it to populars also i’ll be your faithful primer. pianobeton