Line break inside xml data is not displaying as separate lines in BI Publisher

Sujith R

Summary

Line break inside xml data is not displaying as separate lines in BI Publisher

Content

There are Line breaka inside xml data but it is showing in a single line instead of  displaying as separate lines in BI Publisher.

Below is xml data screenshot

below is the data coming in rtf template

Please help. I have googled it but couldnt get a solution for this.

Venkat Thota - BIP

please post how you want to display in report , i.e sample output , Thanks

Sujith R

Hi...Thanks again....I have attached xml and template to my post

Sherry George

I did nothing special to handle this, just added the tags as shown below. If this is not working, attach your rtf template and sample XML.

Sujith R

Thank you. How did u handle it in rtf template.....pls

Sujith R

Thanks for ur reply. I'll attach now

Sherry George

Anyway I tried with another sample xml like below

<?xml version="1.0" encoding="UTF-8"?>

<!--Generated by Oracle BI Publisher 11.1.1.9.0 -Dataengine, datamodel:__weblogic_testbip_xdm -->

<DATA_DS>

<G_1>

<ID>1</ID>

<num>52345</num>

<tandc>

ter1

<br/>

<br/>

<br/>

<br/>

<br/>

ter2

<br/>

</tandc>

</G_1>

</DATA_DS>

And got the pdf o/p with the line breaks.

Sherry George

Could you copy and paste the actual XML, rather than posting a picture. Makes it easier for us to test.

Sujith R

Any ideas please ?

Sujith R

Hi Thanks for your reply,

Output shoud be like below :

1) Terms - 1

2) Terms -2

Brajesh Shukla-95078

BI Publisher parser will not understand <br/> as a new line character . So better to handle this on Database.

So while generating the data

<TermsAndConditions>

1) Terms - 1<br/>2) Terms -2<br/></TermsAndConditions>

please generate as

<TermsAndConditions>

1) Terms - 1

2) Terms -2

</TermsAndConditions>