Support Article
Export to Excel functionality in report definition fails
Summary
Export to Excel functionality in report definition does not work for reports with function alias or column formats.
Error Messages
Section 'pzRDExportWrapper' execution error on page 'pegaInternalReportTempPage' of class 'Rule-Obj-Report-Definition'.
java.lang.NumberFormatException: For input string: "Moderate"
at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043) ~[?:127.0.0.1]
at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110) ~[?:127.0.0.1]
at java.lang.Double.parseDouble(Double.java:538) ~[?:127.0.0.1]
com.pega.pegarules.priv.desktop.reporting.export.excel.ExcelDataGridGenerator.fillDataCell(ExcelDataGridGenerator.java:117) ~[prpublic.jar:?]
com.pega.pegarules.priv.desktop.reporting.export.excel.StandardDataGridGenerator.generateDataRows(StandardDataGridGenerator.java:108) ~[prpublic.jar:?]
com.pega.pegarules.priv.desktop.reporting.export.excel.ExcelDataGridGenerator.generateDataGrid(ExcelDataGridGenerator.java:172) ~[prpublic.jar:?]
com.pega.pegarules.priv.desktop.reporting.export.excel.ExcelReportExporter.fillDataFromPage(ExcelReportExporter.java:181) ~[prpublic.jar:?]
com.pega.pegarules.priv.desktop.reporting.export.excel.ExcelReportExporter.processReportResults(ExcelReportExporter.java:132) ~[prpublic.jar:?]
com.pega.pegarules.priv.desktop.reporting.export.excel.ReportDefinitionExporter.calculateData(ReportDefinitionExporter.java:59) ~[prpublic.jar:?]
at com.pega.pegarules.priv.desktop.reporting.export.ReportExporter.generateFile(ReportExporter.java:39) ~[prpublic.jar:?]
at com.pega.pegarules.priv.desktop.reporting.export.ReportExportHandler.doExport(ReportExportHandler.java:21) ~[prpublic.jar:?]
com.pegarules.generated.html.ra_stream_pzrdexportwrapper_8a003fbd0799660a40b7054ec93dd4aa.performStream_1(ra_stream_pzrdexportwrapper_8a003fbd0799660a40b7054ec93dd4aa.java:188) ~[?:?]
com.pegarules.generated.html.ra_stream_pzrdexportwrapper_8a003fbd0799660a40b7054ec93dd4aa.execute(ra_stream_pzrdexportwrapper_8a003fbd0799660a40b7054ec93dd4aa.java:111) ~[?:?]
at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4202) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4024) ~[prprivate.jar:?]
at com.pega.pegarules.pub.runtime.AbstractActivity.showHtml(AbstractActivity.java:261) ~[prpublic.jar:?]
com.pegarules.generated.activity.ra_action_pzrdexportwrapper_1c30a81b24468857090a0faf8383edfc.step2_circum0(ra_action_pzrdexportwrapper_1c30a81b24468857090a0faf8383edfc.java:705) ~[?:?]
com.pegarules.generated.activity.ra_action_pzrdexportwrapper_1c30a81b24468857090a0faf8383edfc.perform(ra_action_pzrdexportwrapper_1c30a81b24468857090a0faf8383edfc.java:92) ~[?:?]
Steps to Reproduce
Perform Export to Excel for a report definition with function alias or column formats.
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
This issue is addressed in the Pega 8.2.5 patch release.
Published April 9, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.