Employees Performance goal BI report not showing properly in excel output
Summary
Employees Performance goal BI report not showing properly in excel outputContent
Hi ,
We have requirement to create bi reports to fetch the below goal columns for all employees in excel output format.
|
PERSON_NUMBER |
|
|
FIRST_NAME |
|
|
LAST_NAME |
|
|
PREFERRED_FIRST_NAME |
|
|
TERMINATION_DATE |
|
|
PERFORMANCE_YEAR |
|
|
OBJECTIVE_NAME |
|
|
START_DATE |
|
|
TARGET_COMPLETION_DATE |
|
|
CATEGORY |
|
|
ACTION_PLAN |
|
|
SUCCESS_MEASURE |
|
|
COMMENTS_ON_PROGRESS |
|
I have used the attached rtf template in which for columns success_measure and comments_on_progress used the ‘html2fo’ function to convert the html text to normal text.
I am able to run the report in excel(mhtml) format but while applying the filter in excel sheet report output is not showing correct data. This is because columns success_measure and comments_on_progress have multiple lines which is causing the excel cell to split and not allowing to filter excel properly.