Categories
BI Publisher: RTF template - export to excel formatting issues
Organization Name
Deloitte
Description
The report created using RTF Template with the default output format in PDF, results in merging of cells when the output is exported as an excel format. Can we have the cells appear in single column instead of merged cells when the reported is exported in excel format?
As well, we observe that the Exporting to excel (merging columns) is inconsistent along with the sorting.
Use Case and Business Need
Business wants to have the columns individually in excel format as well to have their reconciliations done. This is business critical as the user wants to view the report in pdf as well as export to excel for recon purpose.
Original Idea Number: 2d7ea2ffc9
Comments
-
1) Check the data for special characters.
2) Try Report Properties - > Formatting -> Set up property 'Keep values in same column' as 'True' for Report Value then save it.
3) Please build an Excel template and review the output:https://docs.oracle.com/middleware/11119/bip/BIPRD/create_excel_tmpl.htm
0