When the user is applying filters on one or more columns in the report, and then trying to do Actions-> Export to Excel, then the exported Excel file is showing all the results instead of the filtered results.
I understand that OOTB behavior is considering the export to Excel from the initial results of the RD data page that is already loaded in the clipboard considering the filter conditions that is defined within the RD.
But if the client requirement is to further drill down this results in the exported Excel from the applied filter on one or more columns on top of the filter defined already in the RD, do we have any OOTB approach available in the latest 8.8.x versions, please do let me know.
If anyone has tried any workaround which worked or any different design / customization that worked to achieve this requirement, please do let me know.
***Edited by Moderator Marije to add Capability tags***
Hi @GiriKonatham, a workaround for this is to create an user optimised view. After applying the filters, grouping and sorting on the portal's view the user can click on the 3 dots and there's an option "Save view as". Therein you can provide the view name and mark it as default if you wish.