When working with CLOB columns in Fusion Reports we may face challenges like data splitting into multiple rows for the CLOB Column.
We faced challenges when generating report in Excel Output. The Description column showing one empty row followed by actual data as shown below.
Data Model Query:
When pasted in Excel File:
To overcome this issue convert clob value into Character using TO_CHAR function.
Ex: TO_CHAR(DESCRIPTION)
here DESCRIPTION is a CLOB Column
No comments:
Post a Comment