BI(XML) Publisher , RTF Templet, 10 line per page [message #323587] |
Wed, 28 May 2008 23:01 |
aryanna
Messages: 44 Registered: July 2007
|
Member |
|
|
Hi,
Using .rtf templet
--------------------
1. How to set page break in data row, for example 10 data display per page?
2. How to do condition else if?
For example :
Data: Company_Name, Ctc_Person_name1, Ctc_Person_name1
if Company_Name IS NOT NULL then <?Company_Name?>
else
if Ctc_Person_name1 IS NOT NULL then <?Ctc_Person_name1?>
else
<?Ctc_Person_name1?>
end if
Please Advise!
Any reference for the rtf condtioning?
[Updated on: Wed, 28 May 2008 23:03] Report message to a moderator
|
|
|
Re: BI(XML) Publisher , RTF Templet, 10 line per page [message #323653 is a reply to message #323587] |
Thu, 29 May 2008 02:42 |
skooman
Messages: 913 Registered: March 2005 Location: Netherlands
|
Senior Member |
|
|
Strictly speaking,
if Company_Name IS NOT NULL then <?Company_Name?>
else
if Ctc_Person_name1 IS NOT NULL then <?Ctc_Person_name1?>
else
<?Ctc_Person_name1?>
end if
comes down to:
nvl(Company_Name,Ctc_Person_name1)
So, why all the if/else stuff?
|
|
|
|
|