Prevent merged rows in xpt template when there are line breaks

Question

Summary:

I run into a problem when generating a report where a field contains line breaks. The row expands to the number of line breaks present in the field. I can't find a solution without using SQL functions.

Content (please ensure you mask any confidential information):

Code Snippet (add any code snippets that support your topic, if applicable):

replace (prla.item_description, chr (10)
, ' ') item

Regards

Mallikarjuna Kuppauru-Oracle · Accepted Answer

Hi @Edisson Gabriel López

Refer -

https://docs.oracle.com/en/middleware/bi/analytics-server/administer-publisher-oas/excel-output-properties.html

Keep values in same column

Set this property to True to minimize

column merging. Column width is set based on column contents using the

values supplied in the Table Auto Layout property. Output may not appear

as neatly laid out as when using the original layout algorithm.

False

Enable row split

Set to "true" to avoid stretching a row to a large height, and allow the row to be split into multiple rows.

True

The Above values for Excel Output Properties .

Can you give me some example how the data is present at your DB ?

Regards,

Arjun