Excel Report with Sort and Filter Enabled for all column"
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.
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.