Friday 21 April 2017

Your Report Taking Long time to load - Try this

Recently we had a problem with reports taking a long time to load. 
After much investigation by the Server Administrators we discover that it was because of the subreports, specifically subreports that were imported. What had happened was that a new server was setup and all the report files were copied across and the old server was removed. When the report was loaded it was looking to reimport the subreport, but because the original location did not exist any more, it took about 20 seconds before timing out. What we found was that there is an option under subreport format on the subreport tab to re-import the subreport when opening. By unchecking this option the problem was solved.

No comments:

Post a Comment

Control Structures (Crystal Syntax) In Crystal Report : If Expressions (Crystal Syntax) in Crystal Report

Formulas without control structures execute each expression in the formula exactly once when the formula is evaluated. The expressions are...