Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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 20, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us