Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Shubi Yang (ShubiY62)
Accenture
Senior System Architect
Accenture
JP
ShubiY62 Member since 2016 21 posts
Accenture
Posted: Aug 7, 2017
Last activity: Aug 7, 2017
Posted: 7 Aug 2017 20:35 EDT
Last activity: 7 Aug 2017 22:29 EDT
Closed
Solved

Only 3 decimal places show in exported excel report

Hi,

We have a report definition and contains one column which has 5 decimal places value like "100.12345". It shows 5 decimal places on report browser and exported PDF, but when I export this report to excel this column only shows 3 decimal places like "100.123".

I have attempted to modify the property UI control by changing the Decimal Places to "ALL" but it does not work on exported excel report.

Could anyone tell me how to change the decimal places showing when exported excel?

*We are using Pega Ver7.2 and Excel2010

Thanks

To see attachments, please log in.
Reporting

Accepted Solution

Posted: 7 years ago
Posted: 7 Aug 2017 22:08 EDT
Gisela Rodrigues (rodrg)
PEGA
Senior Principal Engineer, Technical Support
Pegasystems Inc.
IN

Hi,

In the Query tab of Report definition, after the Sort Order column there will be a Settings gear icon. Click on that icon and select Number(left align) as the column format. You will then get the decimal values as expected.

Please find below the screenshots from my end:

 

Hope this helps!

Thanks,

Gisela

To see attachments, please log in.
Posted: 7 years ago
Posted: 7 Aug 2017 22:29 EDT
Shubi Yang (ShubiY62)
Accenture
Senior System Architect
Accenture
JP

Hi Gisela,

I did as your solution and the exported excel report shows expected 5 decimal places!

Thank you so much.

Shubi

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice