Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
280
Views
10
Comments

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

Capture114.PNG

below is the data coming in rtf template

image

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 7 - Analytics Coach

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

  • Rank 3 - Community Apprentice

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

  • Rank 7 - Analytics Coach

    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.

  • Rank 3 - Community Apprentice

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

  • Rank 3 - Community Apprentice

    Thanks for ur reply. I'll attach now

  • Rank 7 - Analytics Coach

    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.

  • Rank 7 - Analytics Coach

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

  • Rank 3 - Community Apprentice

    Any ideas please ?

  • Rank 3 - Community Apprentice

    Hi Thanks for your reply,

    Output shoud be like below :

    1) Terms - 1

    2) Terms -2

  • Rank 7 - Analytics Coach

    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>

Welcome!

It looks like you're new here. Sign in or register to get started.