Business Intelligence

Get Involved. Join the Conversation.

Topic

    Roberto Val
    Text Parameter in Bi Publisher with multiple lines
    Topic posted April 17, 2019 by Roberto Val, tagged BI Publisher 
    27 Views, 2 Comments
    Title:
    Text Parameter in Bi Publisher with multiple lines
    Summary:
    Is it possible lines breaks in text parameter?
    Content:

    Hello.

    I want to enter a paragraph in text parameter through the Report Viewer.

    I tried with \n and <br/> without success. I am using RTF template.

    Do you know how to insert line break / carriage return in text parameter?

    Thanks in advance.

    Version:
    10.1.3.4

    Comment

     

    • Ron

      Do you mean using HTML output in reports?

      If so check out this: https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-4E701E73-E8EB-4CE3-898E-7B7BFFA8F547.htm#BIPRD2299

      Else could you drop a more detailed example? (XML, RTF)

    • Roberto Val

      I've finally found a soluction:

      <?xdofx:replace(FIELD,'LINE_BREAK',chr(10))?>

      Example, if your FIELD is nameLINE_BREAKsurname you will see:

      name
      surname