Support Article

Report columns with format show incorrect data



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

  1. Configure format function for a column
  2. 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.


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 14, 2016 - Updated October 19, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.