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.
4 Answers, 1 is accepted
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.
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.
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).