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
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 16, 2012 4:44 AM by
how to write multiple condition in RTF template
Nov 1, 2012 7:54 AM
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.
This content has been marked as final.
Show 1 reply
Re: how to write multiple condition in RTF template
Nov 16, 2012 4: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?>