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 February 17, 2017 - Updated March 1, 2017

Have a question? Get answers now.

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