8 Answers, 1 is accepted
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)
Please check the Database Server CPU spikes when I generate report forum discussion, and test the suggested approaches to reduce data via filters, to apply specific cache settings to unload resources stored in-memory, or use a web farm to handle the processing of large amount of data.
On a side note, check if data is not repeated by mistake when both the report and a Table items' DataSource properties are set to the same data source component.
I hope this information is helpful.
I am having the similar problem. My report don't show any data when records are more than around 2000 rows. How to fix this problem? Also any option of paging for a table like 100 rows per page? Can't see any paging property for a table.
Plz reply guys with guidance.
If you are not seeing a preview of the report in a web application running in IE, but it is successfully exported, most probably the number of HTML elements exceeds IE limitations for number of elements - Browsers and limitations.
To avoid the issue you can filter the data, or display the report in Print preview which will page the document.
I set page break property of detail section and table to Page break After, still all records are showing on single page.
how to split this data on multiple pages. i.e 100 records per page.
The Table item is rendered in a single continuous page in Interactive preview. You can switch to Print preview mode of the viewer to get the report paged - Understanding Pagination.
For more details, please check Design Considerations for HTML Rendering.
Telerik by Progress
Hi Telerik Team,
Can i split a single large page into multiple pages for printing and if yes then how .
I am using the nativescript-printer for print the page.
The report will be paged for printing according to the page size set in report's PageSettings property - Understanding Pagination.
In case you need to change the page size dynamically this can be achieved by modifying report instance at runtime or binding report's page settings properties to the required expression.