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

 Vinay Martoori (vinnumarto) Conduent Sr Pega Developer
Conduent
US
vinnumarto Member since 2013 1 post
Conduent
Posted: Aug 2, 2016
Last activity: Aug 3, 2016
Posted: 2 Aug 2016 8:40 EDT
Last activity: 3 Aug 2016 10:57 EDT
Closed

Report definition export excel not showing decimal value

Hi

a property in report defination is decimal, it shows 2.14days in report defination whenever i do export to excel its not showing any value in that column .

If I select "Ignore formatting when exporting to excel" in RD its showing in Seconds which is conversion of Days in RD.

Please help if you have any solution or advises 

Thanks ,

Vinay 

***Updated by Moderator: Marissa. Removed user added #helpme tag. Apologies for confusion, shouldn't have been an end-user option***

To see attachments, please log in.
Reporting

Posted: 8 years ago
Posted: 2 Aug 2016 15:31 EDT
Dharanitharan Ravindran (DharanitharanR) Areteans Technologies LSA, BA, DC, CS & UI Specialist
Areteans Technologies
AU

In the Query tab of Report definition after Sort Order column there will be a Settings gear icon mention the column format, now you will get the column as expected while exporting to excel

To see attachments, please log in.
Posted: 8 years ago
Posted: 3 Aug 2016 3:38 EDT
Praveen b (PraveenK5650) Praveen b
Accenture
US

HI 

Thanks for you replay , column already having fromat(which converts seconds into days ) it showing correctly in UI level , problem is when I do export to excel it is not showing .If checked Ignore formatting when exporting to excel in Data accees tab its again showing in Seconds in excel .

To see attachments, please log in.
Posted: 8 years ago
Posted: 3 Aug 2016 10:57 EDT
Santanu Bhattacherjee (Santanu) Senior Manager, Cloud Engineering, Management Plane Services
Pegasystems Inc.
IN

Hi

Which version you are currently on. I remember seeing a HFIX ( HFIX-28262) which fixedabout similar kind of issues in 7.1.4

 

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