Question
2
Replies
405
Views
Posted: December 23, 2016
Last activity: December 23, 2016
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.
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
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.
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.