Prevent merged rows in xpt template when there are line breaks

Edisson Gabriel López

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

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