We're using dynamic column sorting in telerik report. But every time we click on the sort button the report calls the data source. Is there a way to avoid it. This happens when we render the report in different format(csv, pdf) too.
1 Answer, 1 is accepted
answered on 16 Apr 2019, 09:03 AM
I assume that the sorting is performed with an Action. In this case each time the actions gets executed the report will be re-processed and re-rendered and the data will be fetched again during this process. This behavior is by design, as storing potentially huge data will occupy huge memory and may reduce the overall performance of the server.
Note that the already rendered documents are cached, hence if you request the same report with the same parameter values in the same export format, it will be taken from the storage.
As a workaround, you may introduce an ObjectDataSource which will fetch the data from the original data source (e.g. database) and cache it for reuse.
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items