Can we have a the results of a report definition loaded dynamically on a grid repeat layout, on a page, without considering the pagination?
We have a requirement where the results of a Report definition have to be exported to excel. We did this by loading the results in a section and using this as input for excel export OOTB function. But the users have a special requirement on which they want the excel to be exported along with the results of the filter conditions given by the user in their screen (grid repeat layout). When we use the grid's "Specify Custom results Page" option, and use this page as an input for excel export, the results are restricted by pagination. However, the users want the entire report to be viewed in excel (right now only the results of the first page are seen). Please advice on any other solution that would fit this requirement.
Thanks for the response. Yes we are doing this already. The problem here is the filter condition (mentioned in my question above). Let's say we use 2 reports A and B, one for the display and one for the Excel export. The users would apply filter conditions to report A on the UI screen and screen loads with the filtered results. Now, they would click on Export to Excel button, and they expect report B to be loaded on excel with the same filtered results as report A. For them it is the same report, but since we are using 2 reports, it is not possible for us to achieve this. We also tried passing all the Report A filters from clipboard to Report B, but the date filters are a problem here. They do not seem to work. Please suggest an alternative solution for this one.