Oracle Analytics and AI

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

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.

Find more posts tagged with

Accepted answers

All comments

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"?>

<DATA_DS>

<G_1>

<tandc>

ter1

ter2

</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 as a new line character . So better to handle this on Database.

So while generating the data

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

please generate as

1) Terms - 1

2) Terms -2

</TermsAndConditions>