Support Article

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.

Error Messages

Not applicable

Steps to Reproduce

  1. Log into Manager Portal and go the Report menu.
  2. Launch the report called pyOpenCountByStatusForWorkPool (standard Pega 7 report)
  3. In the report viewer, pyStatusWork is in french
  4. export data into excel (Action menu); pyStatusWork is in English

Root Cause

A defect in Pegasystems’ code or rules 


Perform 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

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.