Support Article
Report definition works incorrectly with custom control HTML
SA-55493
Summary
Report definition works incorrectly when custom control HTML is used for the date properties.
Error Messages
Not Applicable.
Steps to Reproduce
- Create a report definition
- Use a DateTime property and write any custom control
- Run the report. The records are displayed correctly with custom control
- Export to Excel. The custom control changes are not applied for the records
Root Cause
This issue was determined to be a product enhancement request.
In Pega 7.3, the Export to Excel feature is rewritten to generate a real .xlsx file instead of an HTML file with the .xls extension. The application does not support custom controls on date properties to ensure that the date values is recognized by Excel.
Resolution
Perform the following local-change:Use a Function Alias to convert the date value to text, that is, use Month number function for the date time value to convert the value into text value.
Published July 23, 2018 - 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.