Support Article

Report exported file name is appending with _ in all scenarios

SA-37879

Summary



When user create a report say Test:1 Daily Report and export this to Excel, the generated file name would be Test_1_Daily_Report.

User requirement is to have hyphen (-) instead of underscore (_) in the place of colon (:)

Every space in the file name is getting converted to underscore (_). This was working fine (Test_1 Daily Report) in earlier versions of Pega and not in Pega 7.2.2.


Error Messages



Not Applicable

Steps to Reproduce



1. Create a report say Test:1 Daily Report.
2. Export this to Excel. The generated file name would be Test_1_Daily_Report.


Root Cause



This is working as designed.


Resolution



Here's an explanation for the behavior:

Question 1. Requirement is to have hyphen(-) instead of underscore(_) in the place of colon(:)

Explanation:
Underscores are used as a convention for spaces within the file name (such as between the title of the report and the date/time).

Hyphens are already in use for the dates or times.

Example: Test_1_Daily_Report_2017-05-20_12-20-43.xlsx

Question 2. Every space in the file name is getting converted to underscore(_). This was working fine in earlier versions of Pega and not in Pega 7.2.2.

Explanation: Spaces being replaced with underscores was done to resolve an issue with UTF-8 characters. Going forward, the spaces will be replaced with underscore.

Published May 12, 2017 - Updated July 18, 2017

Have a question? Get answers now.

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