Home » Fusion Middleware & Colab Suite » Business Intelligence » BI(XML) Publisher , RTF Templet, 10 line per page
BI(XML) Publisher , RTF Templet, 10 line per page [message #323587] Wed, 28 May 2008 23:01 Go to next message
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 Go to previous messageGo to next message
skooman
Messages: 912
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?
Re: BI(XML) Publisher , RTF Templet, 10 line per page [message #323698 is a reply to message #323587] Thu, 29 May 2008 04:56 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi

i made the conditional column as first column through sort icon.
In the page break attributes, there is a provision for break in first,second, third column...

thrrough BIP i controlled no of lines for the defined width.

i did it and you can also

yours
dr.s.raghunathan

Re: BI(XML) Publisher , RTF Templet, 10 line per page [message #323950 is a reply to message #323653] Fri, 30 May 2008 02:35 Go to previous message
aryanna
Messages: 44
Registered: July 2007
Member

Thanks skooman,

I never thou of it.
nvl is the solution.

Regrds, Smile
Previous Topic: How to perform date range in Report
Next Topic: can we use two repository in OBIEE Answers at same time
Goto Forum:
  


Current Time: Sun Dec 04 06:27:55 CST 2016

Total time taken to generate the page: 0.13091 seconds