Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Employees Performance goal BI report not showing properly in excel output — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Employees Performance goal BI report not showing properly in excel output

Received Response
12
Views
3
Comments
edited Dec 29, 2020 6:32PM in Reporting and Analytics for HCM 3 comments

Summary

Employees Performance goal BI report not showing properly in excel output

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!