Support Article
Report exported as Excel does not display value correctly
SA-100422
Summary
A report exported as Excel does not display the value in the correct Currency format.
Error Messages
Not Applicable
Steps to Reproduce
- Create a report definition.
- Add a property (double) as a column.
- On the Format option of the column, set pxCurrency.
- Set the Parameters as below for the Format:
Type: Number
Symbol: Currency and Local Currency
Currency Position: Left
Decimal Places: 4
- Save the report.
- Execute the report. The column displays the value as $zz.zzzz.
- Export the report. The value displays as $zz.zzzz.
- Schedule the report to be sent by email as Excel. The value displays as $zz.zz and is rounded off.
Root Cause
The value displayed incorrectly because the pzMergeAutoGen was not invoked in the pzRDExportWrapper. A step must be added to the pzRDExportWrapper to invoke the pzMergeAutoGen for an Excel report.
Resolution
Apply HFix-59732.
Published June 2, 2020 - 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.