This is a migrated thread and some comments may be shown as answers.

Best way to handle large report

1 Answer 204 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Andrew Volz
Top achievements
Rank 1
Andrew Volz asked on 04 Feb 2010, 08:09 PM
I am new to Telerik and have been given the task to produce a report that contains 60000 rows with approx 20 columns per.  The dataset comes from a single query from a single table.  The preview/report viewer chokes and eventually stops after 10-12 minutes.  After I add parameters/filter, I can successfully display 4000 rows, and I have not tried to display any amounts inbetween.  Is there an approxmate cut-off for the amount of data Telerik will handle?  I ask this so I can plan my next course of action, since I need to render the full report.

Is there a good way to handle larger sets of data in Telerik?  My superior says the entire 60,000 row report has to be able to be displayed in one report.  Any ideas to handle such a request?

Thanks

1 Answer, 1 is accepted

Sort by
0
Schlurk
Top achievements
Rank 2
answered on 05 Feb 2010, 05:13 PM
I think that sounds like quite a bit of data since in order to render the Report on the page all of the data has to be loaded at once. Perhaps take use of SubReports and not load all of the data at once. You can also look into the Performance Considerations knowledge base article to see if you can get any further tips from there.
Tags
General Discussions
Asked by
Andrew Volz
Top achievements
Rank 1
Answers by
Schlurk
Top achievements
Rank 2
Share this question
or