Not able to load large data in cross tab report

[Asim]

hello,

I am using telerik cross tab report but unable to load large data. Report generation proccess is too slow or result in out of memory exception. My stored procedure come up with all records in 1 min and 14 seconds but report don't come up after many minutes, but the same report working fine for 5000 records. Please share the solution?

Thanks

[Haor]

I have the same problem.
I use crosstab report with 700 rows & 20 columns, it takes about 20 seconds generating the report,
and the sql datasource query takes only millisecond.
Can you help us with this issue, thanks.

[Peter]

Hi Haor,

We do understand how important performance is and Improving it is a top priority task for us at the moment. 

However one has to keep in mind that handling reports (be it with large data or large number of report items) usually requires additional resources to handle all the operations. Those operations are much more complex and include data processing (aggregates, filtering, sorting, conditional formatting, expression evaluation, events) and rendering (fonts measurements, layout calculations, paging and etc.). In general report processing/rendering is quite complex process and can't compared with data retrieval and business layer processing. For more information on what happens and when it happens check out the Report Life Cycle help article.

Generally in Q2 2011 we've improved the resource consumption when rendering/working with the report viewers and we're yet to optimize the rest of the rendering formats. Additionally we have made some general speed improvements in the reporting engine that covers all of the rendering extensions. 

Also have in mind that generally reports' purpose is to transform information into "knowledge", so if your main goal is to show this data for presentation only, we can suggest a grid control instead. Another possible solution is to implement filtering for the data based on some criteria, so that your users can select only what they need. For more general tips check out the Performance Considerations KB. 

Greetings,
Peter
the Telerik team