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

split large table on multiple report pages

8 Answers 292 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
marcel
Top achievements
Rank 1
marcel asked on 27 Oct 2015, 10:53 AM

How can we split a table with hundreds of records on multiple pages, using the latest  telerik reporting? I don't want a very html page, which contains the entire table, with a vertical scroll bar.

Thanks in advance.

8 Answers, 1 is accepted

Sort by
0
radha
Top achievements
Rank 1
answered on 27 Oct 2015, 11:56 AM

Telerik Team,

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 (9.1.15.731)

Regards,

Radha

0
Stef
Telerik team
answered on 29 Oct 2015, 02:46 PM
Hi Radha,

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.

Regards,
Stef
Telerik
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
0
Yogi
Top achievements
Rank 1
answered on 30 Oct 2015, 03:12 PM

Hi Guys,  

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.

Thanks,

Yogi

0
Stef
Telerik team
answered on 30 Oct 2015, 04:33 PM
Hello Yogi,

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.

Regards,
Stef
Telerik
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
0
waqas
Top achievements
Rank 1
answered on 26 Jul 2016, 12:51 PM
I have same issue, paging is not working. I have table with 2000+ records, and it is showing on same page(html5 report viewer).
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.
0
Stef
Telerik team
answered on 26 Jul 2016, 01:53 PM
Hi Waqas,

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.

Regards,
Stef
Telerik by Progress
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
0
nitin
Top achievements
Rank 1
answered on 31 Jul 2017, 07:41 AM

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.

0
Katia
Telerik team
answered on 02 Aug 2017, 12:35 PM
Hi nitin,

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.


Regards,
Katia
Progress Telerik
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
Tags
General Discussions
Asked by
marcel
Top achievements
Rank 1
Answers by
radha
Top achievements
Rank 1
Stef
Telerik team
Yogi
Top achievements
Rank 1
waqas
Top achievements
Rank 1
nitin
Top achievements
Rank 1
Katia
Telerik team
Share this question
or