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

 Sonu Rathore (SonuR675)
]init[
Pega Consultant
]init[
DE
SonuR675 Member since 2014 7 posts
]init[
Posted: Dec 23, 2016
Last activity: Dec 23, 2016
Posted: 23 Dec 2016 6:42 EST
Last activity: 23 Dec 2016 8:58 EST
Closed

Excel Report with Sort and Filter Enabled for all column"

Hi ALL,

I have a requirement in which we need to get the data from the reporting grid and export it to excel sheet. and that exported excel has enabled  "sort and filtering"  option for all the columns in the excel sheet.

 

 

To see attachments, please log in.
Reporting

Posted: 7 years ago
Posted: 23 Dec 2016 8:27 EST
Pavan Kumar Koduri (PavanKoduri)
PEGA
Senior Software Engineer
Pegasystems Inc.
IN

Please check how report viewer is working.

When you open a report definition and run it you will see the results of the RD in a report viewer window.This window has an action tab which consists Export to Excel option.All the report viewer resutls will be populated as an excel sheet.

May be you can check its implementation for your requirement.

 

 

 

To see attachments, please log in.
Posted: 7 years ago
Posted: 23 Dec 2016 8:58 EST
Santanu Bhattacherjee (Santanu) Senior Manager, Cloud Engineering, Management Plane Services
Pegasystems Inc.
IN

The script responsible to trigger export to excel is this : Pega.report.commandribbon.exportToExcel"

So please review this function and see whether you can alter the template of the excel and then play with it further to add your own customization.

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