If-then-Else Statement
XML 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.
Use the following syntax to construct an
if-then-else statement in your RTF template:
<?xdofx:if element_condition then result1 else
result2 end if?>
For example, the following statement tests the INVOICE_AMOUNT
element value. If the value is greater than 5000, show the word
"Higher"; if it is less than 3000, show the word "Lower";
else, show "Equal":
<?xdofx:if INVOICE_AMOUNT > 5000 then
’Higher’
else
if INVOICE_AMOUNT <3000 then ’Lower’
else
’Equal’
end if?>
Here we are using same RTF and RDF
which we had used in IF statement
RTF looks like
Provide proper text and Click on Add Help Text we will get another pop
window which is shown below
There we have to write below code
Which is shown below
Now we
have to publish the
report
Click on Template Builder => Preview =>
HTML/PDF/Excel/RTF (any format).
We can get below output
From the above output we can see that Inv Amt which got the result. In this
way we can use IF THEN ELSE statement
Nice info. You can also find more info on Oracle apps
ReplyDeleteat http://www.ebiztechnics.net