Crystal Report Tips

Sunday, September 10, 2006

Reports taking long to load

Recently we had a problem with reports taking a long time to load. After much investingation by the Server Administrators we discoved 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 accross 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.