Posted: 2 Mar 2018 2:36 EST Last activity: 2 Jul 2018 7:07 EDT
How to Export UI filtered results to Excel
I have a repeat grid with data page as source . When user apply any filter on the grid , i want to export the filtered results into excel . I tried using MSOGenerateExcelFile activity . But it is exporting all the results . But am interested in exporting only filtered results. How can i do that.
***Updated by moderator: Lochan to update Categories***
If we source Data Page for Repeating Grid and filter the data and export the results to excel it will not work as even though in the UI Filtered results are showing but on the Clipboard all the data will be maintained, due to this all the results will be part of generate Excel. Instead try sourcing the Grid with Report Definition filter the data and pass the RD page to MSOGenerateExcel latest filtered data will be present in the generated Excel.