I have created a Telerik report (Report.cs) having simple table with 4 input report parameters for user selection, sqldatasource created on design time to invoke Stored procedure. No sorting, no grouping. Hardly one or two formatted columns( to decimal).Report looked good when previewed with less data.
Next, invoked the report in web page using Telerik report viewer.
With view mode - Interactive - I faced problem when the table is getting loaded with data > 3000 records from database(Stored Procedure). Timed out , out of memory exception or controls within the report viewer started disappearing.
With view mode - PrintPreview - Now the report is getting loaded with records >20,000 , and I'm able to get paging, but the performance of the report binding seems to be too slow and while exporting to excel I rarely get Out of memory exception.
SQL Database - when the SP is executed it hardly takes some 45 seconds to pull 20,000 records, but in Telerik report viewer , report loading takes time around 4 to 5 minutes.
Question - Would it be possible for improvising the performance a bit more faster? what's the better way , when loading huge amount of data? How do we avoid memory exception when exporting data to excel? Thanks in advance.
Telerik Reporting version Used - Q2 2015 (126.96.36.1991)