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

Export to excel issue still exists after applying HFix-31103

SA-33841

Summary



When using a custom control format control in a Report Definition to display the differences between two dates the results are shown correctly in the report viewer, but when performing an "export to excel" operation the results are not shown correctly. Export to excel is not picking up the format from the custom control.

Error Messages

Not Applicable


Steps to Reproduce

  1. Create a Report Definition with pxElapsedTime as a column.
  2. Apply control to convert pxElapsedTime to days, minutes, and hrs format.
  3. Run Report and export it to excel.
  4. The format of pxElapsed column is not changed as per the control.


Root Cause



An issue in the custom application code or rules. When using a Date column in the Report Definition with custom control. Since the original property is Date column, the (number) returned by custom control is also getting converted to Date while exporting to excel.

Resolution



Perform the following local-change:

Changed the original column from date to number and access the date value via below API in the custom control.

ClipboardProperty date = tools.getActive().getParentPage().getProperty("FieldName")

Published March 1, 2017 - 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