Support Article

Report columns with format show incorrect data

SA-29163

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


 
  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.

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 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.