Horizontal Scroll Issue Fix for Clob Attribute in Oracle BI

While using Oracle BI Reports in Oracle Sales Cloud, if one adds a Clob (Long Text) attribute to the report, the attribute will have "Word Wrap" and "Horizontal Scroll" issues.

For long paragraphs, the field width will be max and a horizontal scroll bar will be added at the bottom of the field (Inconvenient for some customers)

Also, new line characters are not added to the text, making text like -

"Hello

Test Message"

Appear like "Hello Test Message" (No new line characters are added)

To fix this, one can click on column properties and select "Override Default Text Format"

Then, select "Custom Text Format" and use the following -