Report generation without data takes very long

5 posts, 0 answers
  1. Jolanta
    Jolanta avatar
    28 posts
    Member since:
    Oct 2014

    Posted 16 Jul Link to this post

    Hi,

    I have prepared a report template. I have not bound any data yet, but generation of such "empty" report takes very long time (more than 30sek).
    What goes wrong in it?

    Can I add somewhere here my trdx template?

    Thanks in advance for any help.
    Jola

  2. Silviya
    Admin
    Silviya avatar
    208 posts

    Posted 17 Jul Link to this post

    Hello Jola,

    Note that report processing and rendering are memory intensive operations. During the report generation, besides the retrieved data there are newly generated resources by the report which are held in memory and each item takes memory and time to be rendered in the report.I suggest to check the Performance Considerations article for hints on how to optimize report rendering.
    We would need to reproduce the issue in order to investigate it. So, please open new support ticket and attach the report definition with the current settings for local investigation.

    Regards,
    Silviya
    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
  3. Jolanta
    Jolanta avatar
    28 posts
    Member since:
    Oct 2014

    Posted 18 Jul in reply to Silviya Link to this post

    Unfortunatelly, my support licence is no more valid...
    Jola K.
  4. Jolanta
    Jolanta avatar
    28 posts
    Member since:
    Oct 2014

    Posted 19 Jul Link to this post

    Hi,
    what I can see, the problem is with a table itself:

    my table has 41 columns and 18 rows.
    5 rows belongs to header section, remaining to data section within the table.

    Generating such table - totally empty, without any logic - this itself take this long time (over 30sek, which is very strange to me).

    I have another report, where the columns are dynamically created (the table is dynamically expanded), then it goes immediatelly, even much bigger tables.

    Jola

     

  5. Silviya
    Admin
    Silviya avatar
    208 posts

    Posted 23 Jul Link to this post

    Hello Jola,

    Keep in mind that handling reports (be it with large data or large number of report items) usually requires additional resources to handle all the operations. Those operations are much more complex and include data processing (aggregates, filtering, sorting, conditional formatting, expression evaluation, events) and rendering (fonts measurements, layout calculations, paging and etc.). In general report processing/rendering is quite complex process and can't compared with data retrieval and business layer processing. For more information on what happens and when it happens check out the Report Life Cycle help article.

    The best approach for improving the report's performance would be to filter the unused amount of data by filtering the data server side - please check Performance factors in the developer’s control(Volume of the data retrieved from the data source).

    Regards,
    Silviya
    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
Back to Top