pyStatusWork are not translated into Excel export of report
A report was run, and an Excel file was generated using Export To Excel. The Excel file does not show localized values. However, the on-screen report shows localized Values.
Steps to Reproduce
- Log into Manager Portal and go the Report menu.
- Launch the report called pyOpenCountByStatusForWorkPool (standard Pega 7 report)
- In the report viewer, pyStatusWork is in french
- export data into excel (Action menu); pyStatusWork is in English
Root CauseA defect in Pegasystems’ code or rules
ResolutionPerform the following local-change:
If you include a reference to the ‘control’ rule ‘GetLocalizedValue’ on your Report Definition – this will be picked up in the resultant EXCEL report.
Bring up the Report Definition: Possible use of ‘Private Checkout’ if this an OOTB report:
And then save the report and refresh it. The values are now localized.
Published October 3, 2016 - Updated October 13, 2016