Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
on Nov 16, 2012 10:44 AM by dekoke_i
how to write multiple condition in RTF template
Nov 1, 2012 12:54 PM
I like to create a condition in RTF template where if one column is null then the corresponding row should not print. The twist is that, the column is the combination of many fields.
Thanks in advance.
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: how to write multiple condition in RTF template
Nov 16, 2012 10:44 AM
in response to
Try the following. On your RTF template, in the column that display null value, enter <?if: V_COLUMN = “ ”?> <?DATA_YOU_WANT_TO_DISPLAY?> <?end if?>
The <?if: V_COLUMN = “ ”?> represents the column that returns the null value. If you need to create a column made up of a list of field then try <?if: V_1 || ' ' || V_2 ||' '|| V_3 = “ ”?>
Just remember to end the statement with a <?end if?>