# How to Fetch Filtered results from a GRID layout with pagination enabled whose source is Data Page? **URL:** \ **Category:** User Experience\ **Tags:** reporting, 8-8-4, user-experience, pega-platform\ **Created:** [January 8, 2024, 1:31pm UTC](https://forums.pega.com/t/how-to-fetch-filtered-results-from-a-grid-layout-with-pagination-enabled-whose-source-is-data-page/5742 "2024-01-08T13:31:10Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Pooja\_Dash](https://avatars.discourse-cdn.com/v4/letter/p/da6949/32.png) [@Pooja\_Dash](https://forums.pega.com/u/Pooja_Dash)\ **Post date:** [January 8, 2024, 1:31pm UTC](https://forums.pega.com/t/how-to-fetch-filtered-results-from-a-grid-layout-with-pagination-enabled-whose-source-is-data-page/5742/1 "2024-01-08T13:31:10Z")
Hi Everybody. we are using a repeating grid whose source is Data Page. The pagination is enabled. We wanted to export the filtered results into an excel. I tried with Report definition since the requirement is not possible with Data Page. Howvere when I am exporting it is only exporting the filtered result from current page as pagination is enabled. Can someone please suggest if this is possible from data page or Report definition. ---
**Author:** ![parav1](https://avatars.discourse-cdn.com/v4/letter/p/d6d6ee/32.png) [@parav1](https://forums.pega.com/u/parav1)\ **Post date:** [January 9, 2024, 8:19am UTC](https://forums.pega.com/t/how-to-fetch-filtered-results-from-a-grid-layout-with-pagination-enabled-whose-source-is-data-page/5742/2 "2024-01-09T08:19:52Z")
@Pooja Dash Please go through below link if it helps : > **[How to get filtered data from client side in export to excel? | Support Center](https://support.pega.com/question/how-get-filtered-data-client-side-export-excel)** > > I'm using a report definition as a source in Data Page and displaying it on the screen, on filtering the columns at the client end I'm getting the filtered data on the screen. I need to get the filtered data exported via excel. I'm using the Call... ---
**Author:** ![Pooja\_Dash](https://avatars.discourse-cdn.com/v4/letter/p/da6949/32.png) [@Pooja\_Dash](https://forums.pega.com/u/Pooja_Dash)\ **Post date:** [January 9, 2024, 11:09am UTC](https://forums.pega.com/t/how-to-fetch-filtered-results-from-a-grid-layout-with-pagination-enabled-whose-source-is-data-page/5742/3 "2024-01-09T11:09:04Z")
@parav1 I tried that approach ,but I couldn’t find the filter values in pyUI pages. The pxRetrieveReportData retrieving all results not the Filtered one ---
**Author:** ![MarijeSchillern](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/marijeschillern/32/21738_2.png) [@MarijeSchillern](https://forums.pega.com/u/MarijeSchillern)\ **Post date:** [January 16, 2024, 4:52pm UTC](https://forums.pega.com/t/how-to-fetch-filtered-results-from-a-grid-layout-with-pagination-enabled-whose-source-is-data-page/5742/4 "2024-01-16T16:52:06Z")
@Pooja Dash When using a paginated repeating grid, the export functionality will only export the current page’s results. If you want to export all filtered results, not just those on the current page, you might need to use a different approach. One possible solution is to use the ‘pxRetrieveReportData’ activity to pull all the filtered results onto another page, and then pass these results to the ‘pxConvertResultsToCSV’ activity. This should allow you to export all filtered results, not just those on the current page. Please note that this approach might require additional configuration and testing to ensure it meets your requirements. ⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references. [How to get a full list of Page List data by pxConvertResultsToCSV with pagination](https://support.pega.com/question/how-get-full-list-page-list-data-pxconvertresultstocsv-pagination) [Export to excel all data in Report Definition 6.1](https://support.pega.com/question/export-excel-all-data-report-definition-61) ---
**Author:** ![Pooja\_Dash](https://avatars.discourse-cdn.com/v4/letter/p/da6949/32.png) [@Pooja\_Dash](https://forums.pega.com/u/Pooja_Dash)\ **Post date:** [January 17, 2024, 11:11am UTC](https://forums.pega.com/t/how-to-fetch-filtered-results-from-a-grid-layout-with-pagination-enabled-whose-source-is-data-page/5742/5 "2024-01-17T11:11:14Z")
@MarijeSchillern Thank you for the suggestion. Those changes will require additional configuration. We suggested users to do the filter from excel itself, as they are using the excel very rare.