Hi,
I have a multiple page report that uses RadGridView to organize the data. When I try to export it to excel, it only exports the current page, and not the whole thing. Is there a way to go through each page and export it all to one document? I tried setting the ItemSource for the button to be the entire Results set instead of the CurrentBatchResults but it still only gives me the current page.
Only the first page is generated at first, and subsequent pages are generated upon clicking to the next page due to performance issues. These reports often look at tens of pages at 100 rows per page, so to generate it all on one page would take too long for our users. Any ideas?
I have a multiple page report that uses RadGridView to organize the data. When I try to export it to excel, it only exports the current page, and not the whole thing. Is there a way to go through each page and export it all to one document? I tried setting the ItemSource for the button to be the entire Results set instead of the CurrentBatchResults but it still only gives me the current page.
Only the first page is generated at first, and subsequent pages are generated upon clicking to the next page due to performance issues. These reports often look at tens of pages at 100 rows per page, so to generate it all on one page would take too long for our users. Any ideas?
3 Answers, 1 is accepted
0
Hi,
You can export the AJAX RadGrid with disabled paging in order to get all data in the produced Excel file.
Other approach is to create a report definition using the native Telerik Reporting Table/Crosstab/List item or other layout, and bind it to the same data as the grid. The created report can be displayed in a viewer or exported directly.
Please test the above suggestions and let us know if you need any further help.
Regards,
Stef
Telerik
You can export the AJAX RadGrid with disabled paging in order to get all data in the produced Excel file.
Other approach is to create a report definition using the native Telerik Reporting Table/Crosstab/List item or other layout, and bind it to the same data as the grid. The created report can be displayed in a viewer or exported directly.
Please test the above suggestions and let us know if you need any further help.
Regards,
Stef
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.
0
Dev
Top achievements
Rank 1
Rank 1
answered on 30 Apr 2014, 02:53 PM
Sorry, I should clarify: we are using WPF, not AJAX.
0
Hello,
If you prefer to skip using Telerik Reporting,your grid should display the full list of data records at the time you export it. For example you can use a RadDataPager and the approach described in the following forum thread: Export all records to excel when I'm using RadDataPager for paging.
Regards,
Stef
Telerik
If you prefer to skip using Telerik Reporting,your grid should display the full list of data records at the time you export it. For example you can use a RadDataPager and the approach described in the following forum thread: Export all records to excel when I'm using RadDataPager for paging.
Regards,
Stef
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.