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

Some Reports Not Displaying

1 Answer 117 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
David
Top achievements
Rank 1
David asked on 14 Aug 2015, 08:18 PM

I have a report that displays fine no matter the parameters that I put into it on my development machine.  When I push it to production when I use a small date range it comes up fine.  When I try to expand the date range it will display the attached image showing that it is fetching the records then it will just sit there in a non-selectable state for as long as you let it sit.  Running SQL profiler, the query is executing in less than 8 seconds and is returning 15,500 rows so it is not a incredibly large amount of data.

 I have a few other reports that are running fine it just a couple that seem to have this issue.  Tried it on Chrome, IE, Safari and all seem to have the same problem.

 Any ideas on where to go next?

1 Answer, 1 is accepted

Sort by
0
Nasko
Telerik team
answered on 18 Aug 2015, 12:27 PM
David,

Your SQL query may be executing for ~8 seconds, but the reporting engine will need more time to process and render the report. In case of a very complex report structure, the engine will take significantly more time to prepare the report. Our suggestion is to follow the recommendations in the Performance Considerations help article to optimize the report.

Regards,
Nasko
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
David
Top achievements
Rank 1
Answers by
Nasko
Telerik team
Share this question
or