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.
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.
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.