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

Report taking time to load

1 Answer 217 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Shiwani
Top achievements
Rank 1
Shiwani asked on 08 Mar 2017, 09:40 AM

Hello,

I have created a report in Telerik Report designer R3 2016, here i have used table and sub-report within table, for which 2 SQL queries are used in report which is taking 100 seconds to load in SQL server, but the telerik report is getting displayed in 20-25 minutes.

please help me to come out of this.

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 09 Mar 2017, 05:05 PM
Hello Shiwani,

Beside the time and resources for retrieving data, there is time and resources for generating the report that visualizes the data with native objects for the selected media(HTML for web preview, Image for design-time preview, PDF and etc.).
In addition, each data item executes its data-retrieval method on its own.

Please go through the suggestion in Performance Considerations. Also consider switching to data-binding approaches based on expressions like in How to Databind to Collection Properties and Use DataObject as a datasource for nested data items (Table, List, Crosstab, Graph. These approaches save you from re-retrieving the data for each data item.

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
Tags
General Discussions
Asked by
Shiwani
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or