SA-34501

Summary

When you Export a Report Definition (RD) to Excel, non-localized property values are exported instead of the localized field values. This issue does not occur with Export to PDF of the report.

Error Messages

Not Applicable

Steps to Reproduce

1. Create a Report Definition with pyStatusWork as the source of one column.
2. Create localized field values for pyStatusWork.
3. Run the report.
4. From the report's Actions menu, click Export to Excel.
   The Excel spreadsheet does not display the localized field values. Instead it displays non-localized property values.

Root Cause

A defect in Pegasystems’ code or rules

Rule-Utility-Functions (RUFs) used by Export to Excel do not consider pxObjclass when exporting field values because of a missing context page.

Resolution

Perform the following local-change:

1. Do a private check out of the report.
2. Edit the report to change the columns with localized field values to use the control GetLocalizedValue:
   a. Click the gear icon next to the column.
   b. In Edit Column Options, the Column Format field, specify GetLocalizedValue.
   c. Click Submit.

Related Content
If you are using Pega 7.1.8, see SA-20204, https://pdn.pega.com/support-articles/export-report-excel-does-not-localize-value.