split large table on multiple report pages

7 posts, 0 answers
  1. marcel
    marcel avatar
    1 posts
    Member since:
    Jan 2015

    Posted 27 Oct 2015 Link to this post

    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.

  2. radha
    radha avatar
    1 posts
    Member since:
    Jul 2015

    Posted 27 Oct 2015 Link to this post

    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

  3. DevCraft banner
  4. Stef
    Admin
    Stef avatar
    3047 posts

    Posted 29 Oct 2015 Link to this post

    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
  5. Yogi
    Yogi avatar
    4 posts
    Member since:
    Sep 2015

    Posted 30 Oct 2015 Link to this post

    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

  6. Stef
    Admin
    Stef avatar
    3047 posts

    Posted 30 Oct 2015 Link to this post

    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
  7. waqas
    waqas avatar
    1 posts
    Member since:
    Jul 2016

    Posted 26 Jul Link to this post

    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.
  8. Stef
    Admin
    Stef avatar
    3047 posts

    Posted 26 Jul Link to this post

    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
Back to Top
DevCraft banner