Support Article
Report columns with format show incorrect data
Summary
Reports have format function defined for a column in report definition, The results for that particular column are incorrect when exported to excel sheet.
Error Messages
Not applicable
Steps to Reproduce
- Configure format function for a column
- Export to excel
Root Cause
The user had a custom control and in this control he was converting integer into [hh:mm] format and passing it to RD column.
Resolution
In Excel if the column has value of [xx:yy] format then it automatically converts it to [xx:yy:00]. User can see the format applied by excel using ctrl+1 .
So to overcome this, suggested user to change his custom control and send the values as [xx.yy] or [xx:yy hours] instead of [xx:yy] so that EXCEL doesn't consider it as Time field.
Published October 20, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.