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
- Create a Report Definition with pxElapsedTime as a column.
- Apply control to convert pxElapsedTime to days, minutes, and hrs format.
- Run Report and export it to excel.
- 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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.